ExcelBanter - Best way to extract data on one sheet & populate it on another sheet??????

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Best way to extract data on one sheet & populate it on another sheet?????? (https://www.excelbanter.com/excel-programming/278014-best-way-extract-data-one-sheet-populate-another-sheet.html)

Best way to extract data on one sheet & populate it on another sheet??????

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.

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.
.