Could anyone point me in a good direction for doing the following.
1. I receive an Input file with data for several products, all arranged in one big table with specific column headers (formatted as range or Excel table, whatever is best)
2. I have one Calculation file where I paste data from the Input file into columns named exactly the same as in the Input file but I only input data from 1 product (using filters on the input file).
3. The calculation file is saved for the specific product.
4. The table in Calculation file is cleared and then I paste data for the second product and save the Calculation file as new name
5. I do this for all products in my input file (normally 5-50 products).
Is there a way to do this with VBA i.e. filter a table in one file and then transfer the values into another file and save that with a new name?
/H
1. I receive an Input file with data for several products, all arranged in one big table with specific column headers (formatted as range or Excel table, whatever is best)
2. I have one Calculation file where I paste data from the Input file into columns named exactly the same as in the Input file but I only input data from 1 product (using filters on the input file).
3. The calculation file is saved for the specific product.
4. The table in Calculation file is cleared and then I paste data for the second product and save the Calculation file as new name
5. I do this for all products in my input file (normally 5-50 products).
Is there a way to do this with VBA i.e. filter a table in one file and then transfer the values into another file and save that with a new name?
/H
