Hello,

I am trying to simplify my data entry and I have this idea that I do not know how to tackle, but it would be nice to have it worked out. I am looking for an autofill macro that will fill column B4:Bxx with values from 1 to max. value specified in some cell. Lets say I know I have 4 trees I need to enter. I want to enter "4" in a cell as a reference, and everything else will be filled in automatically with press of the button.

To make things even more productive I would like to use value from cell A4 and replicate it through the range specified above.

Example:


A:________ B:_________ C:__________ <<< columns
1: <<< misc info
2: <<< misc info
3: TreeCount: [4] [Macro Button] <<< max value, macro button, misc
4: PlotID TreeNumber <<< column headers
5: [HUM1] <<< A5 value to be replicated

Now; when I press Macro Button the spreadsheet will be filled like this:

A:________ B:_________ C:__________ <<< columns
1: <<< misc info
2: <<< misc info
3: TreeCount: 4 [Macro Button] <<< max value, macro button, misc
4: PlotID TreeNumber <<< column headers
5: HUM1 1
6: HUM1 2
7: HUM1 3
8: HUM1 4

Any ideas? Sorry about elaborate diagrams but I really had a hard time verbalizing what I need - thus no google answer...

Thanks
Radek

Configuration: Windows XP
Firefox 3.0.15