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 LookUp to collect the data into the 3rd Tab but the info isn’t pairing together. The data is falling into different rows. Does anyone know of a way to put both lookup info into the one row?
All help is welcomed!