Auto Repeat of columns sheet 2, not sheet 3, 4, 5
 

How do I repeat columns 1, 2, 3 (#, Last Name, First Name) on just one sheet (sheet 2) automatically (5 sheets total). That way when that database gets updated, the information will change accordingly on the next sheet.

Auto Repeat of columns sheet 2, not sheet 3, 4, 5
 

It sounds like you want to take the columns A:C of Sheet2 and automatically populate four other sheets with the same values in those columns whenever Sheet2 gets updated.

One way is to start in the first "other" sheet and put this in A1:
=IF(Sheet2!A1="","",Sheet2!A1)
Then copy A1 into B1 and C1. Then copy A1:C1 downward farther than the data can ever reach.

If necessary, re-format the columns as desired.

Then select columns A:C of the first "other" sheet, and paste them into each of the three other "other" sheets.

Hope this helps.

Hope this helps.

Auto Repeat of columns sheet 2, not sheet 3, 4, 5
 

The formula...

=Sheet2!A1

...will return empty if it's empty and so why use an IF()?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Auto Repeat of columns sheet 2, not sheet 3, 4, 5
 

=Sheet2!A1
..will return empty if it's empty and so why use an IF()?

One would think so, but actually it returns the number zero. (Long story.)

(I have Excel 2010.)

Auto Repeat of columns sheet 2, not sheet 3, 4, 5
 

=Sheet2!A1
..will return empty if it's empty and so why use an IF()?

One would think so, but if the cell has no value or formula in it,
=Sheet2!A1
actually returns the number zero.

(I have Excel 2010.)

Auto Repeat of columns sheet 2, not sheet 3, 4, 5
 

=Sheet2!A1
..will return empty if it's empty and so why use an IF()?

One would think so, but if the cell has no value or formula in it,
=Sheet2!A1
actually returns the number zero.

(I have Excel 2010.)

Ah yes, quite correct! My mistake for thinking otherwise...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion