Copy one workbook to Another WorkBook
I have two open workbooks. I need to select data from one workbook (active worksheet) once i selected, that need to be pasted in another workbook opened, the parent workbook is having multiple sheet so its should be pasted on active worksheet. Before pasting on the parent workbook the active worksheet all rows to be deleted. Doing this manually taking more time. if some one help me for VBA code . it will be helpful.
Sorry, I'm not helping here.
I just want to understand your situation.
You have two workbooks.
1. Workbook-A ---> this is what you call "parent" workbook
2. Workbook-B
Workbook-A has many sheets, anyway, the current condition is Sheet1 ---> this is what you call the active sheet of the parent workbook.
Now in Workbook-B you select a range of data.
The automation you want is the code to copy your selected range in workbook-B (whatever active sheet name)
then paste it to your last blank row of data in the active sheet (Sheet1 in this example) of the parent workbook (workbook-A)
after that it delete the rows of your selected range in workbook-B.
Is that what you mean ?
or this one :
Now in Workbook-B you select a range of data.
The automation you want is the code to delete all the cells in the active sheet (Sheet1 in this example) of the parent workbook (workbook-A)
then copy your selected range in workbook-B (whatever active sheet name)
then paste it to the first row of the active sheet (Sheet1 in this example) of the parent workbook (workbook-A)
Last edited by karmapala; 05-07-2020 at 05:43 AM.
I want to copy Workbook B Active Sheet(whatever active sheet name) entire data
Then i need to paste in workbook A Active Sheet(whatever active sheet name) entire data.
And in what workbook that you want to delete the whole cells of the active sheet ?Originally Posted by SARAN89
Active Sheet of Workbook A
You cannot have two active sheets in two different workbooks.
The only activesheet is the visible sheet in front of you on the desktop.
So you either have to give the name of the sheet you want to copy from or make the 2nd workbook active and whatever sheet shows up on the desktop is the active sheet of that workbook.
That would be something like
Written in the raw so don't take it as gospel until tried.
Please Login or Register to view this content.
Hi
I will copy manually from Work Book "B", then i will go to Work book A and execute the code. It will work?. The code is like deleting all rows of active sheet of workbook "A" and then to be pasted, what i am copied from Workbook "B"
Kindly help me VBA code for this.
Maybe something like this :
1. This code has to be in the wbA (Parent.xlsm).Please Login or Register to view this content.
2. Before running the code, you have to be sure that the active sheet in wbB is the one that you want to copy
3. then back to wbA to run the code
Last edited by karmapala; 05-08-2020 at 02:40 AM.
Hi
Workbook B name is not specific, like WB-B
every time it will change. Can you modify the code to use any open workbook.
Last edited by SARAN89; 05-20-2020 at 11:50 AM.
Maybe like this :
Please Login or Register to view this content.
It MUST only two workbooks open.
If it's only one workbook open, the code will fail.
If it's more then one workbook open, the code will fail.
If the active sheet in wbB is not the sheet which is going to be copied to wbA,
you will get a result which is not expected.
Not tested.
You can have as many workbooks open as you want.
It's your choice
See attached
First select a workbook from the list and than select a sheet from the other list.
Site security would not let me post some additional info.
It is in the attached notepad file
Last edited by jolivanes; 05-20-2020 at 03:08 PM.
Re:
I want to copy Workbook B Active Sheet(whatever active sheet name) entire data
Then i need to paste in workbook A Active Sheet(whatever active sheet name) entire data.
You might have to change thisPlease Login or Register to view this content.
to thisPlease Login or Register to view this content.
Please Login or Register to view this content.
Hi jolivanes
Excellent your code is working fine. one small change is required. Currently its pasting the data on "A1" . but i required as its in source workbook. like if its in B9 then it should paste in B9 of target workbook.
Please Login or Register to view this content.
Hi jolivanes thank you so much. Its pasting as required. but formatting is showing different. I need to include the below lines but not sure where i need add i tried but getting errors
Please Login or Register to view this content.
Change this
to thisPlease Login or Register to view this content.
Next time, before you post, think things through on what you need so we dont have a change or addition every suggestion.Please Login or Register to view this content.
Last edited by jolivanes; 05-21-2020 at 02:19 AM. Reason: code tags
Hi jolivanes
I thought it will paste same as source hence not informed early. The addition line is working fine. thanks for your help.
No worries
Good Luck
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks