Valguard
Fri Jul 31st, 2009, 09:58 AM
Is anyone in here an Excel guru? I am definitely not.
Here is what I want it to do:
I want to select a row of cells then push a button. Once the button is pushed excel selects the row below the original selected row of cells and then auto fills the information from the newly selected row of cells to the above, original, selected cells. Does that make sense? Then, I want it to select the next row off cells, below the originally selected ones, and repeat the proccess. Once the "next row" is populated by a formula, excel shuold stop running the script.
I’m not very good with VB, just never had any training in it, but Im a quick learner. If anyone has got some thoughts or ideas on where to start it would be much appreciated. I tried Google but wasn’t really getting anywhere. Any ideas?
Here is what I want it to do:
I want to select a row of cells then push a button. Once the button is pushed excel selects the row below the original selected row of cells and then auto fills the information from the newly selected row of cells to the above, original, selected cells. Does that make sense? Then, I want it to select the next row off cells, below the originally selected ones, and repeat the proccess. Once the "next row" is populated by a formula, excel shuold stop running the script.
I’m not very good with VB, just never had any training in it, but Im a quick learner. If anyone has got some thoughts or ideas on where to start it would be much appreciated. I tried Google but wasn’t really getting anywhere. Any ideas?