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

W

WebWizard97

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

Peter Atherto

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Copy Data from one worksheet to another 1
Extracting data from database into separate sheets 0
Query from Multiple Workbooks 6
Many sheets, one DB? 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Combining lines from individual sheets into one summary sheet 1
Can I copy data (Values) from one sheet to another with macro 7
Automatic Date if data entered in sheet 5

Top