Couple of ways.
If you have data in an adjacent column, you could *double* click on the
"fill handle", which will automatically copy the contents of the cell as far
down the column as there is data in the adjoining column.
If there is data in both adjacent columns, the length of the left column
takes precedence.
Another way is to select the cell after it's revised, then click in the
"name box", and type in the address of the last cell in the column to be
copied to (i.e. B500), hold down <Shift> and hit <Enter>.
This selects the cells in the column that you wish to copy TO, with the
focus on the cell that you revised.
Then hit <F2>, and then <Ctrl> <Enter>, which will now copy the revision to
the entire selection.
If all your WSs are identical, and you wish to duplicate this copying, you
could "group" the sheets before you perform this revision and copying.
Click on the tab of the first sheet, hold down <Shift>, and click in the tab
of the last sheet.
All the tabs in the "group" are now white, with the name tab of the main
sheet in bold, and the word "Group" is appended to the name of the WB in the
title bar.
Don't forget to "un-group" when you're done, by right clicking in a tab and
choosing "Ungroup Sheets".
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
I'm constantly revising a large workbook. Having revised a cell, is there a
quick way of copying that revision down all 500 rows, and also revising the
other 20 odd worksheets with the same revision, rather than doing each
individual column manually ? I dont want to lose any existing data in the
workbook ? Many Thanks
