Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating / linking
what if the data is in two separate files
"JLatham" wrote: Are both spreadsheets in the same workbook? I will presume that they are. For discussion, I'll call the imported data sheet 'PlainSheet'. If the data always comes into PlainSheet in the same cells, then over in your color coded sheet, simply set up links to the plain sheet as: ='PlainSheet'!A44 or ='PlainSheet'!X2 Those formulas can be in any (appropriate) cells on your color coded sheet, they simply echo what's in the referenced cell on the PlainSheet. "Jeff" wrote: Im making a spreadsheet but i have one problem ive made a template of what i want it to look like. All the info comes from a website that generates a normal excel file with just names and dates. Since i need these dates to be color coded i need to find a way for the color coded spreadsheet to update with all the info from the regular spreadsheet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto updating & linking 2 workbooks without opening the linked | Excel Discussion (Misc queries) | |||
Updating | Excel Worksheet Functions | |||
Linking and updating spreadsheets | Excel Discussion (Misc queries) | |||
linking/updating two files for charting | Charts and Charting in Excel | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions |