Open a File and Paste data on it...

[siobeh]

Hello, appreciate your help with this.


In Sample.xlsm:

Commandbutton1 to

- to open existing excel file and hold it. (Ex: Output_Template.xlsx)


Commandbutton2 to execute this procedure:

2. In Sample.xlsm (Sheet1): Copy Column A2:X (to LAST COUNT OR ROW) - FROM Sample to Output_Template("Consolidated Core")


3. Paste it to Column E in Output_Template("Consolidated Core) to the last row of existing data.

4. Filter Column L, if status is "On QUeue" then write UC in Column D else "C".

5 Now Filter Column K, If Column K contains "EMCC", then write "EMEA EMCC" to Column D to it.

6. Done Copying Consolidated data, now Filter Column E, if Column E is EMEA CORE then cut the data and paste it to "Core-Data Sheet for the Week" Sheet to be added it to the last row, else Paste it
to "EMCC- Data Sheet for the Week" Sheet to be added to the last row.

7. Back to "Consolidated Core" and filter it, If Column L is "Chaser or Exceptions" then cut it and paste it to "ADHOC CORE" sheet to be added to the last row.

8. Then Back to "Consolidated Core", if Last row of Column A is W2 then next row will be W3 depending on the last row of Column D so on and so forth (If W3 then next is W4...)

I've the atttached the files. Thanks in advance!

[siobeh]

appreciate your help with this.