Hey guys,
so i have a workbook, with information pulled from 2 other files that i refresh these files daily, then Refresh all to update the main workbook with new information.
In the main book,
how would i add to Sheet1, column F, with the highest number from Sheet2, Column R
i'd like to add to the end of column F rather than replacing what was already there.
Ideally i'd put dates that the highest number was loaded into Column F into Column G beside it
Then i'd like to highlight the rows in Sheet1 that are higher than the previous refresh number in Column F
-- ive already done a bit of mucking around with the conditional formatting so could probably work it out, im more chasing the answer to the first section, but this would be a bonus
thanks in advance!
so i have a workbook, with information pulled from 2 other files that i refresh these files daily, then Refresh all to update the main workbook with new information.
In the main book,
how would i add to Sheet1, column F, with the highest number from Sheet2, Column R
i'd like to add to the end of column F rather than replacing what was already there.
Ideally i'd put dates that the highest number was loaded into Column F into Column G beside it
Then i'd like to highlight the rows in Sheet1 that are higher than the previous refresh number in Column F
-- ive already done a bit of mucking around with the conditional formatting so could probably work it out, im more chasing the answer to the first section, but this would be a bonus
thanks in advance!