Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I share data in different worksheets?
I have one excel spreadsheet that I am inputting data for tracking purposes.
I need to also print out this information, in a different format, and forward to an end user. I have set up a second excel spreadsheet in the format necessary. Currently the information from spreadsheet 1 is automatically populating into spreadsheet 2. BUT- for every record I add I have to continually go into spreadsheet 2 and update the row number within the formula to pull in the correct data. Is there a way so that as I key in each row - the record will automatically populate correctly within spreadsheet 2? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing data across worksheets within a workbook based on identifi | Excel Discussion (Misc queries) | |||
How do I compare data from 2 worksheets to find duplicate entries | Excel Discussion (Misc queries) | |||
sorting data in linked worksheets | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |