Hi,
I have 3 worksheets in a workbook.
Sheet(1) is to compare Sheet(2) and Sheet(3)
Dates in Column A and some data in B.
I'm trying to come up with a way to compare the dates in 2 & 3, by checking the dates in 3 against the dates in 2, and inserting missing dates into sheet(3) that appear in sheet(2) along with that dates associated data?
Or maybe, if a date exists in sheet2 but not sheet 3, just delete that date in sheet 2.
Is this doable?
Hi Treva,
"It" can be done - but which option do you prefer?
Here's another option:
Please Login or Register to view this content.
Last edited by xladept; 04-15-2013 at 04:43 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks