drums4monty
12-18-2014, 04:23 AM
Hi
I have 3 workbooks, Pending 1, Pending 2, Pending 3, and would like to create a new workbook, Pending Consolidated, using the information from the other 3 workbooks (i.e. take the information from all of the other 3 workbooks and merge into one workbook), to make on list.
As I update the 3 other workbooks I want the Pending Consolidated workbook to reflect the changes, i.e. information changed, new information added or information deleted. As information is deleted ideally the gap created in Pending Consolidated will be closed and new information added to the other 3 workbooks would get added to the bottom of Pending Consolidated.
The information will be held in A2 (Ref), B2 (Name), C3 (Post Code).
Is this possible?
This is way beyond me and is giving me a headache just writing it :)
I have 3 workbooks, Pending 1, Pending 2, Pending 3, and would like to create a new workbook, Pending Consolidated, using the information from the other 3 workbooks (i.e. take the information from all of the other 3 workbooks and merge into one workbook), to make on list.
As I update the 3 other workbooks I want the Pending Consolidated workbook to reflect the changes, i.e. information changed, new information added or information deleted. As information is deleted ideally the gap created in Pending Consolidated will be closed and new information added to the other 3 workbooks would get added to the bottom of Pending Consolidated.
The information will be held in A2 (Ref), B2 (Name), C3 (Post Code).
Is this possible?
This is way beyond me and is giving me a headache just writing it :)