Combine Workbook - Copy_Paste_Below_Last_Cell

[Rahulwork1991]

Hello Everyone

I have two different workbooks in same folder path and both workbook has same column headers too.

From A5 to S5, headers and then from A6 i have data in both the workbook

I want to copy one workbook one workbook to other workbook and i have below code for tha

Please Login or Register  to view this content.

I am facing some issue to amend this code as my requirement.

1. Workbook Path - I am going to run this macro from other 3rd workbook and have copy and destination workbooks path in their cell in E1 and E2
2. Worksheet Name - I don't know the copy and destination sheet name but data is available on first sheet which name can we anything. (can we amend the sheet name in this macro and then perform our action or what would be best way?)
3. Copy and paste data. help me with the giving range of copy and destination range.

your prompt response will be highly appreciated. help me pls

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new, I will provide the link for you this time: https://www.mrexcel.com/board/thread...eader.1142428/)

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I will do it for you this time.)

[Rahulwork1991]

Thank u. Will take care of this. Pls help me in this question.pls