Excel - create new sheet based on values in other excel file
Budget: $30 – $250 USD
I need assistance with cleaning up and automating my Excel data.
I'm unsure if everything is possible to do, but maybe a few steps can be disregarded.
The perfect scenario would be:
Create a simple form to add 'ID number' to process and file name for the new file.
The automation:
Open designated file with info.
Create columns (based on character lenght)
Format columns (set length, add '0's eg '234' formated to '000234'.
Get only rows where Column C matches the input 'ID number', and column B has fixed value.
Insert row at top with column header titles.
Save file (as excel 97-2003 format), with the input filename.
If all works out well, I will have another project where similar things are needed.
Ideal freelancers for this project should have extensive experience with Excel, particularly in data analysis and automation.
I'm unsure if everything is possible to do, but maybe a few steps can be disregarded.
The perfect scenario would be:
Create a simple form to add 'ID number' to process and file name for the new file.
The automation:
Open designated file with info.
Create columns (based on character lenght)
Format columns (set length, add '0's eg '234' formated to '000234'.
Get only rows where Column C matches the input 'ID number', and column B has fixed value.
Insert row at top with column header titles.
Save file (as excel 97-2003 format), with the input filename.
If all works out well, I will have another project where similar things are needed.
Ideal freelancers for this project should have extensive experience with Excel, particularly in data analysis and automation.