Hi guys,
This is my first post and just want to say that this site has been amazing to me for the past year with the very strange and unique excel questions but i have found myself with a question that i haven't seen posted on here yet. There have been similar questions but not anything that would be able to help me, so here goes.
Scenario:
There are two workbooks (Workbook-A and B) which contain information. Workbook-A is an automated report that consists of about 50 columns of information, stats, etc. This workbook cannot be altered.
Workbook-B is my workbook that i have created. I only need a few of the columns from Workbook-A and the information related to each column.
Question:
What I want to do is every time i export the report at the end of the week (Workbook-A), I want my specific fields from the report to be copied over to workbook B, and if the data differs from the previous report then have some form of conditional formatting happen which would highlight which cell within the range has differed.
What I have done so far...
Created my workbook-B with the columns that i require from workbook-A and have used 'Paste Special...Paste Link' to have the data update whenever the report is pulled. (Please note: I can use Paste Link because the report, once pulled, ALWAYS has the same file name so the link between the report and Workbook B will always remain.)
I am thinking, and i have started playing around with the idea, is i have the 'Paste Link' cells on another sheet (say, sheet2) in Workbook B, and have sheet 1 refer to this sheet as it held the previous report and if any of the cells from the previous report differs from the new report, then have those specific cells highlighted etc etc.
I understand that you cannot use conditional formating between worksheets so i don't know how to do this either and would ultimately like to incorporate this into this idea.
(Edit: I am using excel 2003, Windows XP Professional, and would preferable like the answer to be VBA related if possible as i have a 'self-taught / self-teaching' mentality. thanks guys)
This is my first post and just want to say that this site has been amazing to me for the past year with the very strange and unique excel questions but i have found myself with a question that i haven't seen posted on here yet. There have been similar questions but not anything that would be able to help me, so here goes.
Scenario:
There are two workbooks (Workbook-A and B) which contain information. Workbook-A is an automated report that consists of about 50 columns of information, stats, etc. This workbook cannot be altered.
Workbook-B is my workbook that i have created. I only need a few of the columns from Workbook-A and the information related to each column.
Question:
What I want to do is every time i export the report at the end of the week (Workbook-A), I want my specific fields from the report to be copied over to workbook B, and if the data differs from the previous report then have some form of conditional formatting happen which would highlight which cell within the range has differed.
What I have done so far...
Created my workbook-B with the columns that i require from workbook-A and have used 'Paste Special...Paste Link' to have the data update whenever the report is pulled. (Please note: I can use Paste Link because the report, once pulled, ALWAYS has the same file name so the link between the report and Workbook B will always remain.)
I am thinking, and i have started playing around with the idea, is i have the 'Paste Link' cells on another sheet (say, sheet2) in Workbook B, and have sheet 1 refer to this sheet as it held the previous report and if any of the cells from the previous report differs from the new report, then have those specific cells highlighted etc etc.
I understand that you cannot use conditional formating between worksheets so i don't know how to do this either and would ultimately like to incorporate this into this idea.
(Edit: I am using excel 2003, Windows XP Professional, and would preferable like the answer to be VBA related if possible as i have a 'self-taught / self-teaching' mentality. thanks guys)
Last edited:
