View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sean.W[_2_] Sean.W[_2_] is offline
external usenet poster
 
Posts: 4
Default Inputting data into more than one sheet at a time

A____B____C____D_____E______F_________G_____
date/item/$cost/$retail/$reimb./$difference/client name

A = INPUT
B = INPUT
C = INPUT
D = INPUT
E = INPUT
F = E MINUS C
G = INPUT

"Gary''s Student" wrote:

Which columns are input and which are calculated?
--
Gary''s Student - gsnu200857


"Sean.W" wrote:

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?