Best way to extract data on one sheet & populate it on another sheet??????
Hi
A non programming method is a simple formula say in sheet
Total
=SUM(Sheet1:Sheet12!A18) This sums the value in A18
accross sheets 1 to 12 (Jan to Feb)
Peter
-----Original Message-----
Hello all,
I have a workbook that contains the following:
A.) (12) Spreadsheets (1) for each month (I.E. Jan. -
Dec.) each of
these spreadsheets contain information regarding:
Sales Date, Company Branch / Location, Sales Rep,
Customer, Sell
Price, delivery date, item being ordered, etc.
B.) (1) Main spreadsheet that stores data from all (12)
monthly sheet
and runs various calculations on that data.
I want to be able to enter data in to each of the (12)
monthly sheets
and then have certain pieces of data carried over /
populated into the
main spreadsheet on individual rows.
What is the best way to accomplish this, that will not
restrict the
addition / subtraction of data, and can be used by all
sheets??? I am
currently manually enter the data into both the monthly
and main
sheet.
Any assistance will be greatly appreciated. Thank you in
advance.
.
|