Need expert EXCEL VBA to let a user to provide the codes within the next 24 hours! (Be Quick!)
1) Open a Master excel file with macro/vba
2) Run the macro/vba which will ask user to select/open another excel file
3) Copy the contents of each sheet (only sheet name starting with "Sheet", e.g. Sheet1 to Sheet 3) . See [url removed, login to view] as an example
4) Paste the content in a single sheet on the Master file. See Master file as an example
5) Number of sheets to copy from can vary.
6) Number of columns in each group will be 7 but the number of groups in each sheet will vary
7) Number of rows in each sheet will vary
8) The value in cells "A1" and "A2", "B2" and "D2" need to be copied in each row for ALL column groups, along with the sheetname and file name. (see example in Master file)
9) The value above column header "c" should be copied in each row for the corresponding column group (see example in Master)
Resource: VBA copy/paste code example:
Freelancer who can demonstrate they have done similar work (or create the codes using the data files provided) will awarded the task (or paid directly)!
19 freelanceria on tarjonnut keskimäärin 33 $ tähän työhön
I have the expertise in scripting in VBA and can deliver this script to copy/paste from multiple files in a couple of hours. Ready to start work now