Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print sheets in Excel without blank sheets after page | New Users to Excel | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
populating sheets based on data from parent sheets | Excel Discussion (Misc queries) |