LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lewis Shanks
 
Posts: n/a
Default Automatic transfer of data from one worksheet to another

I have two spread sheets, let's call them A and B. A could be considered the
master work sheet. It has 15 columns A -O. The B worksheet has 13 columns,
all of them which come from A. I have deleted Columns L and N in A when the
data is transferred to worksheet B.

I would like to know what the process is to set these up so that when I add
or delete new information to or from A, it automatically transfers the same
information to B, exclusive of columns L and N.

Thanks very much

Lewis Shaks


 
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
How do I copy a graph and use the data in the new worksheet? Brendanluc Charts and Charting in Excel 9 February 9th 08 06:49 AM
Excel 2003, Convert EXISTING Worksheet Data to XML? [email protected] Excel Discussion (Misc queries) 4 November 16th 05 04:45 AM
Master worksheet automatically enters data into sub worksheets Ken Excel Discussion (Misc queries) 1 November 1st 05 10:36 PM
Automatic Data Validation drop down creation Buddhapenguin Excel Discussion (Misc queries) 1 May 12th 05 08:41 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 11:39 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"