AutoFill Method

[Muz1993]

Hi Everyone,

Column A
ABC




DEF



GHI

How can I fill between the range?

[FDibbins]

What would you fill it with? Your requirement is nit clear at all

[Muz1993]

Fill the existing value up to certain range.
Example :
Before :
Column
ABC


DEF


FGH

After :
Column
ABC
ABC
ABC
DEF
DEF
DEF
FGH
I hope you guys can understand it.
Thank You

[FDibbins]

Try this...
starting with the cursor somewhere in the table of data,
press F5 (GoTo), then click Special, then click Current Region;
press F5 again, then click Special, then click Blanks;
begin to enter a formula by typing "=" (without the quotes)
click on the cell immediately above the activecell (coloured white in the highlighted block);
then hold down the CTRL Key and press Enter

[Muz1993]

Quick question : If it with many columns that have many blank rows, can it be done?

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[FDibbins]

Quick question : If it with many columns that have many blank rows, can it be done?

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.