I want to collate data from two different tabs into a 3rd tab, but have the data synch across the row. For example: Client A info for Project Name from Tab 1 and Client A Invoice Number from Tab 2, and for these to be combined into Tab 3.
I am using ...