In excel I have May's data of names and descriptions. I just received June's
data of names and descriptions. Some of the same names appear in both months
excel spreadsheets. How can I combine or merge May's and June's excel
spreadsheets into a yearly spreadsheet so that all names are listed but only
once? The description cell is a non numeric cell that may change month to
month. The latest months description should be in the yearly spreadsheet.
Thanks in advance for your help.
Phil,
Have a look at this file. I used a vlookup formula and some conditional formatting to check the June data for new items. If the item was found to be new the conditioinal formatting was applied to highlight the new items. Also, you could sort the June data by the column with the vlookup statement in it to copy and paste the new items into your yearly summary.
Compare.zip
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks