Hi all, please help me to solve this problem.
I have 1 file CSV and 1 file Summary excel. I need someone help me to make some action as below
Step 1 : I want to copy data from specific cell from CSV file ( ex : G2~G1000)
Step 2 : Paste data into sheet "sample" of excel file (ex : Summary file have 3 sheet "Summary", "process", "sample")
Step 3 : In excel file run my own marco to process data
Step 4 : copy all data after process from cell E2 -> end data from sheet "sample" to cell G1 of sheet "process"
Step 5 : Run another my marco
Step 6 : Copy data after process from cell A1-> A165 of sheet "process" to E8 of sheet "Summary"
Step 7 : Loop for next cell in CSV file ( G3, G4, G5...) and do all process above then paste to F8 of sheet " Summary" and so on
Sorry because I can attached file in here, if anyone want to see file for more detail please contact and help me
I have 1 file CSV and 1 file Summary excel. I need someone help me to make some action as below
Step 1 : I want to copy data from specific cell from CSV file ( ex : G2~G1000)
Step 2 : Paste data into sheet "sample" of excel file (ex : Summary file have 3 sheet "Summary", "process", "sample")
Step 3 : In excel file run my own marco to process data
Step 4 : copy all data after process from cell E2 -> end data from sheet "sample" to cell G1 of sheet "process"
Step 5 : Run another my marco
Step 6 : Copy data after process from cell A1-> A165 of sheet "process" to E8 of sheet "Summary"
Step 7 : Loop for next cell in CSV file ( G3, G4, G5...) and do all process above then paste to F8 of sheet " Summary" and so on
Sorry because I can attached file in here, if anyone want to see file for more detail please contact and help me
