I have a spreadsheet that is filled out and saved into a tab with a department name on it. This is working fine, but i have been asked to create a copy that pulls the information back in out of the saved information to have notes added.
I have partly cretaed the sheet to fill in but am having an issue creating the VB to pull the data back in.
Cell "C5" holds the department name and "D5" holds a unique number that can be used to search the department sheet.
What is the best way to pull the information out and into the template?
All help gratefully appreciated
Gavin
I have partly cretaed the sheet to fill in but am having an issue creating the VB to pull the data back in.
Cell "C5" holds the department name and "D5" holds a unique number that can be used to search the department sheet.
What is the best way to pull the information out and into the template?
All help gratefully appreciated
Gavin
