Copy & Paste the data Conditionally

Hi,
I am looking for a macro that does the things mentioned below

Copy & Paste the data from 1.xls to Book1.xlsx

macro will be placed in a macro.xlsm so the path should be hardcoded in the macro for both the files, so that i can change it as per my needs

Note there may be a data in book1.xlsx so in that case paste the data below that data (plz see the sample file for this)


Thnx For the Help

have you ever coded before? look into the workbook, worksheet, and pastespecial objects and methods:

https://docs.microsoft.com/en-us/off...e.pastespecial

https://docs.microsoft.com/en-us/off...xcel.worksheet

https://docs.microsoft.com/en-us/off...excel.workbook

No Sir, I am learning & I tried to make the same but due the logic condition, I am unable to make Sor

so what kind of assistance would you like? the entire code routine to be written for you?

I am looking for the macro for the same Sir

can you see my signature? is says: ""don't call me 'sir'"". I will take a look at your file.

I looked at your files, and the first question I have is:

why do you want to do this? you are duplicating data between 2 books. what's the purpose of that? I mean, I know this is trading data, but that doesn't justify what you want to do.

by mistake

I want to copy past the data bcoz its is important & i have to do it daily so i am looking for the macro for the same

Originally Posted by dumdumbum

I want to copy past the data bcoz its is important & i have to do it daily so i am looking for the macro for the same

that doesn't answer the question. are you doing it because your manager told you to? if you don't have an answer that's fine. I just ask because so many technology workers are asked to do things by their managers and it makes absolutely no sense. If you simply need to get it done and you're not even told why, that's fine. I, or someone else, will more than likely be able to give you a solution.

I ask bcoz, If I post all question from one account then everyone will think how much I ask (I ask many questions, & now I ask less bcoz my work is almost completed

Yes Sir but it's different, I tried to edit but I was unable to do

Correct Sir

I have no issues with it & now I will use only 1 account to ask question

This one dumdumbum

Do not delete all account bcoz I asked the question & all the post I made is important for me
I will use dumdumbum

Sure No problem Sir, Do one thing just make that account that i cant post question but the post that i posted that should not be deleted Sir, its a request