View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_3_] MyVeryOwnSelf[_3_] is offline
external usenet poster
 
Posts: 56
Default 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.