Just use "=". So for example -- vt_mughal 10/08/2019 10:24AM
Don't even have to create a macro... -- 81_Hokie 10/08/2019 08:33AM
Is that a data sort exercise? -- bigbadbird 10/08/2019 08:56AM
Same thing... just copy the first sheet to the second and rearrange order ** -- 81_Hokie 10/08/2019 09:08AM
Make each column a separate table -- VTHokie01 10/08/2019 08:11AM
Record a macro during your initial cut & paste -- BTHokie 10/08/2019 07:06AM
The HLOOKUP function might work ** -- BleedinOandM 10/08/2019 06:09AM