M
mcarrigg
Hi Guys,
Thanks in advance for any help you may be able to offer.
I have a workbook with three sheets. "Comparison", "Last year" & "This Year".
Each sheet will only have one calendar month of data in it (ie 1st Aug
through to 31st Aug, 1 row per day)
I would post the sheet here to view however I am new here and cant seem to
find a link to attach a sheet.
I would like to import "Last Year" & "This Year" into "Comparison". The
problem I am having is that I would like to import the 1st day of month of
2008 into "Comparison". Say for arguments sake that this day is a Friday for
instance, I would like to import the first friday of "Last Year" and import
it into "Comparison" into the cell above the imported "This Year" row. In
the row below these two rows, I would like a row calculating the difference
between the two days of data.
I would like this repeated so that "Comparison" is comparing each day from
there on in for the whole months' data.
ie, "Comparison" rows should be something like...
Date Day PULP ULP Diesel Total Fuel
03-Aug-07 Friday 1,381 7,746 4,799 13,926
01-Aug-08 Friday 2,834 13,662 13,191 29,687
Difference 1,453 5,916 8,392 15,761
04-Aug-07 Saturday 943 5,883 2,767 9,593
02-Aug-08 Saturday 1,288 8,094 8,588 17,970
Difference 345 2,211 5,821 8,377
05-Aug-07 Sunday 1,497 10,880 11,969 24,346
03-Aug-08 Sunday 780 6,022 5,143 11,945
Difference -717 -4,858 -6,826 -12,401
I want this to automatically import so that I can change the month to
September and send out to the sites and it automatically compares the right
days for whatever month I put in.
Thanks heaps again!
Thanks in advance for any help you may be able to offer.
I have a workbook with three sheets. "Comparison", "Last year" & "This Year".
Each sheet will only have one calendar month of data in it (ie 1st Aug
through to 31st Aug, 1 row per day)
I would post the sheet here to view however I am new here and cant seem to
find a link to attach a sheet.
I would like to import "Last Year" & "This Year" into "Comparison". The
problem I am having is that I would like to import the 1st day of month of
2008 into "Comparison". Say for arguments sake that this day is a Friday for
instance, I would like to import the first friday of "Last Year" and import
it into "Comparison" into the cell above the imported "This Year" row. In
the row below these two rows, I would like a row calculating the difference
between the two days of data.
I would like this repeated so that "Comparison" is comparing each day from
there on in for the whole months' data.
ie, "Comparison" rows should be something like...
Date Day PULP ULP Diesel Total Fuel
03-Aug-07 Friday 1,381 7,746 4,799 13,926
01-Aug-08 Friday 2,834 13,662 13,191 29,687
Difference 1,453 5,916 8,392 15,761
04-Aug-07 Saturday 943 5,883 2,767 9,593
02-Aug-08 Saturday 1,288 8,094 8,588 17,970
Difference 345 2,211 5,821 8,377
05-Aug-07 Sunday 1,497 10,880 11,969 24,346
03-Aug-08 Sunday 780 6,022 5,143 11,945
Difference -717 -4,858 -6,826 -12,401
I want this to automatically import so that I can change the month to
September and send out to the sites and it automatically compares the right
days for whatever month I put in.
Thanks heaps again!