I need an excel expert to format data sheets into a set format based on headers
Budget: €8 – €30 EUR
My issue is I have spreadsheets from various sources and I need to get them into a specific format based off the column headers.
Basically I need a code that will take a spreadsheet and copy to a new sheet only the columns I require in the order I require them. I also need to replace header names with slightly different headers in some cases.
The formula needs to be based off the header names NOT the column location if that makes sense.
I am attaching a sample file that I would need to format with all the various headers AND the second file is how I would need the formatted file to be laid out and the headers I required. Third is a list of the headers of which headers match which column position and what they should be named
I need to get this as soon as possible please :-)
Thank you!
Basically I need a code that will take a spreadsheet and copy to a new sheet only the columns I require in the order I require them. I also need to replace header names with slightly different headers in some cases.
The formula needs to be based off the header names NOT the column location if that makes sense.
I am attaching a sample file that I would need to format with all the various headers AND the second file is how I would need the formatted file to be laid out and the headers I required. Third is a list of the headers of which headers match which column position and what they should be named
I need to get this as soon as possible please :-)
Thank you!