Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,182
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 56
Default 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.)
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 56
Default 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.)


  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,182
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel sheet setup, need only 2 columns with auto-tab and return Seaghost Excel Discussion (Misc queries) 1 October 12th 09 12:09 PM
Select dynamic data in 2 columns, and repeat macro to next sheet Tasha Excel Discussion (Misc queries) 2 September 17th 09 07:00 PM
Auto copy cell data from source sheet to another wrkbook sheet IVLUTA Excel Programming 2 June 2nd 09 05:07 PM
Auto Copy/autofill Text from sheet to sheet if meets criteria Joyce Excel Discussion (Misc queries) 0 November 21st 08 12:05 AM
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet. bertbarndoor Excel Programming 4 October 5th 07 04:00 PM


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"