Macro needed for copy paste!

Hi everyone,

Here is my scenario.

A = Column, 1 = Row

A1 = X
A5 = Y
A19=Z
A24=ZXCV

Is there a macro whereby I can fill up A2 - A4 with A1 (X), fill A6-A18 with A5 (Y), and fill A20-A23 with Z?

Not sure if copy+paste, or autofill will help.

Any help will be much appreciated.

Thanks,
Rukia

If the cells you're wanting to "fill up" are currently empty, this is an easy little trick:

1) Highlight A1:A24
2) Press F5 and click on Special
3) Select Blanks and then OK

You now have all the empty cells selected

4) Press the = sign one time
5) Press the Up Arrow one time
6) Careful here, press CTRL-ENTER

All the empty cells filled up with the value from above.

Hi rukia
maybe something like

Please Login or Register  to view this content.