Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate excel sheet based on values in a separate sheet | Excel Discussion (Misc queries) | |||
Need conditional data from 1 sheet to populate another sheet | Excel Worksheet Functions | |||
Populate order sheet with data from work sheet | Excel Worksheet Functions | |||
Help me, compare 2 sheet and extract the match data into the new sheet. | Excel Discussion (Misc queries) | |||
How to populate one sheet with data from another sheet | New Users to Excel |