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

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

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

Then include the other file's name as part of the formula as:
=[OtherWorkbookName.xls]'PlainSheet'!A44

Actually, if you have both workbooks open, you can click in a cell in your
formatted sheet, type an = to start a formula then choose the other workbook,
the needed sheet, and the desired cell and press [Enter] and Excel will build
the formula for you.

When you close that other workbook, the formulas will also update to
included the path to the file.

If several people are going to use the file on a network, it is best to save
the book with 'PlainSheet' in it using Save As and then browsing through 'My
Network' for the location to save it. This will provide a network path to it
when it is closed so that your color coded workbook can find the data from
any other system on the network.


"Jeff" wrote:

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