Two sheets into one remapped? How to do it.
 

I am opening an on line shop and download a .csv from my supplier. I can also
upload a .csv to my store. Problem is the column headers are not the same.
Seeing as there will be possibly hundreds of items I want to merge and remap
the headers to kind of automate the process. Is this possible? I'm not all
that great with excel but have had some general experience with it. I'm using
2003 version of excel.
Thanks for any input or suggestions.

Min

Two sheets into one remapped? How to do it.
 

Hi,

we would need more info about what the two spreadsheets look like and what
you want the end product to look like, particularly the headings.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"MinConst" wrote:

I am opening an on line shop and download a .csv from my supplier. I can also
upload a .csv to my store. Problem is the column headers are not the same.
Seeing as there will be possibly hundreds of items I want to merge and remap
the headers to kind of automate the process. Is this possible? I'm not all
that great with excel but have had some general experience with it. I'm using
2003 version of excel.
Thanks for any input or suggestions.

Min

Two sheets into one remapped? How to do it.
 

Hi Shane,
I'd be happy to send you the two samples. I don't see a way to attach here.
But you can get them here.
http://www.minichillosconstruction.c.../Minconst.zip\

Thank you.

Min

"Shane Devenshire" wrote:

Hi,

we would need more info about what the two spreadsheets look like and what
you want the end product to look like, particularly the headings.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"MinConst" wrote:

I am opening an on line shop and download a .csv from my supplier. I can also
upload a .csv to my store. Problem is the column headers are not the same.
Seeing as there will be possibly hundreds of items I want to merge and remap
the headers to kind of automate the process. Is this possible? I'm not all
that great with excel but have had some general experience with it. I'm using
2003 version of excel.
Thanks for any input or suggestions.

Min