I have 3 reports that get emailed out to 3 different companies, at the end of the day they fill out the reports and send back to me... what I am wanting to do in excel is when I get those individual reports I want to be able to merge and update the specific cells to the main report...
Individual Reports
EXAMPLE: Company A: 200 emp
Company B: 15 Trained
Company C: 25 ret
MAIN Report:
Company A: 20 emps (now I am wanting to merge and update Company A to 220 emp into main report)
Individual Reports
EXAMPLE: Company A: 200 emp
Company B: 15 Trained
Company C: 25 ret
MAIN Report:
Company A: 20 emps (now I am wanting to merge and update Company A to 220 emp into main report)