LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Inputting data into more than one sheet at a time

I have four worksheets containing sales figures for four different products.
I then have a sheet called "MASTER" which I would like to contain data from
all four of the other sheets. What I would like to do, is whenever I input
data into any one of the four product sheets, it should also appear on the
"MASTER" sheet, thus creating a compilation of the data on all four sheets.

All 5 worksheets have the same columns:
date/item/$cost/$retail/$reimb./$difference/client name

How can I accomplish this?
 
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
Inputting a length of time? Link New Users to Excel 12 May 22nd 07 11:49 AM
Inputting data into two worksheets 4762nicho Excel Discussion (Misc queries) 3 April 28th 07 12:54 PM
inputting data Shanor Excel Discussion (Misc queries) 0 June 15th 06 10:50 AM
Update a chart immediately after inputting data into data source MELMEL Charts and Charting in Excel 1 December 1st 05 09:34 PM
Inputting Source Data - help please foredis Charts and Charting in Excel 1 June 22nd 05 02:36 PM


All times are GMT +1. The time now is 03:21 PM.

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

About Us

"It's about Microsoft Excel"