Copy Data from Another Worksheet and Paste it to Another Worksheet

[puuts]

Hello, could you please help me with this, I just want:


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!

[puuts]

can anyone help me on this?

[arlu1201]

Any reason for this

Commandbutton1 to

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

You can have one command button itself which does the entire task.

[puuts]

Hi arlu, nothing special with that, it's just I want . Also, i just want a textbox right of it so the path will be visible.

[arlu1201]

Also, i just want a textbox right of it so the path will be visible.

You want the textbox to reflect the path of the file once the button is clicked?

[puuts]

I mean, when Commandbutton1 is clicked, user will browse the file, and once user have choose the file, the path of the file will be reflected to the textbox.

[puuts]

any one can help me please.