SamTheMan89
New Member
- Joined
- Apr 11, 2017
- Messages
- 1
Hello all,
I am not new to Excel, but I have never messed with formulas or documents with large amounts of information.
However, I am now faced with doing weekly and/or monthly updates on a master spreadsheet/workbook that has names, case numbers, completion dates, and other personal data.
I receive a separate workbook every so often from a different organization with names, case numbers, completion dates, etc.
The master workbook has multiple different tabs with all this information, and I have been taking case numbers from the new workbook and conducting a search on the old workbook, and I've been updating the completion date manually according to case number.
The master workbook looks something like this:
Case number | Name | Completion Date, Etc
The new workbook looks similar to this:
Case Number | Name | Completion Date
The new workbook has case information on every tab on the master spreadsheet, and it is incredibly tedious to search for each case number and update the completion date individually.
Is there any sort of shortcut or formula I can do to maybe find and replace the case number and blank completion date with the new completion date? Is there any way to merge the spreadsheets without compromising the integrity of each tab?
I don't know if any of this made sense, but I could really use some help.
I am not new to Excel, but I have never messed with formulas or documents with large amounts of information.
However, I am now faced with doing weekly and/or monthly updates on a master spreadsheet/workbook that has names, case numbers, completion dates, and other personal data.
I receive a separate workbook every so often from a different organization with names, case numbers, completion dates, etc.
The master workbook has multiple different tabs with all this information, and I have been taking case numbers from the new workbook and conducting a search on the old workbook, and I've been updating the completion date manually according to case number.
The master workbook looks something like this:
Case number | Name | Completion Date, Etc
The new workbook looks similar to this:
Case Number | Name | Completion Date
The new workbook has case information on every tab on the master spreadsheet, and it is incredibly tedious to search for each case number and update the completion date individually.
Is there any sort of shortcut or formula I can do to maybe find and replace the case number and blank completion date with the new completion date? Is there any way to merge the spreadsheets without compromising the integrity of each tab?
I don't know if any of this made sense, but I could really use some help.
