MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Multiple Excel documents

Posted by Cosmo on July 30, 2001 10:17 AM

How does one create a macro or lookup function to have specific information on one excel document populate in another document if the information is not always in the same column or row?

Posted by Malc on July 31, 2001 1:03 AM

Lookups would probably be the way to go. They will handle data in different rows so that leaves on the column problem. In the source sheet can you insert a column that looks along the row with if statements i.e in A2 =if(B2<>"",B2,if(C2<>"",C2 and so on. You'll only get up to 8 ifs though. Alternatives might be to delete selected cells to pull the data into common columns.