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

Can I copy data (Values) from one sheet to another with macro 7
Copying Data from One sheet to another 6
excel extract data from one sheet to another 2
Copy data from multiple columns and populate it in another sheet in one column,, 1
Copying data from one sheet to another 3
Copy data from one sheet to another 2
sort data and copy to another sheet in a different form dynamicall 9
VBA help sought 1

Top