Copy and Paste from Workbook to another Workbook - VBA

Hi All,

I think this should be simple for any excel ninjas on here, I am relatively new to VBA, and so am no good at starting code from scratch.

I want to copy specific cells from a workbook called Master.xlsx and paste them into the next available row in another workbook called Time.xlsx

The cells from the first workbook will be from "Sheet 4" B36:K36 and to be pasted into the next available row in the Time.xlsx workbook

Any help be great

Regards

Simon

Please Login or Register  to view this content.

Thanks for the quick reply, I wasn't very clear even with myself there as to what i wanted. The document to be copied from will always be the active workbook and jus so happens to be called Master.xlsx.

These documents come in, in vast quantities, they are then viewed and logged by hand. I would like a code so once viewed a button or hot key can be pressed to copy and paste the specific cells to a document set in a specific location.

I tried playing around with your code but keep receiving an error "subscript out of range"

I also notice the paste special function in your code, but plain old text is all i am copying

The document to be copied from will always be the active workbook and jus so happens to be called Master.xlsx.

Replace Workbooks(Master.xlsx) with ActiveWorkbook

I would like a code so once viewed a button or hot key can be pressed to copy and paste the specific cells to a document set in a specific location.

Assign this macro to a button (Insert a shape / button / picutre from Insert tab. Right click on the shape and click Assign Macro, select this macro name) or assign a shortcut key to this macro. (View > Macros > Options)

I tried playing around with your code but keep receiving an error "subscript out of range"

That may be because you are playing with a file whose name is not Master.xlsx or it doesn't have a sheet named Sheet4. To be pasted book should be named Time.xlsx.... This is all hard coded there based on the information you gave in the post. You might want to change it as per your needs.

I also notice the paste special function in your code, but plain old text is all i am copying

Doesn't matter. It still works.

Apologies haripopuri, as i had stated at the start of this thread I am new enough to VBA, the code you supplied I found difficult to understand, because I am new.

Thank you pareshj for your code, this is something I am more familiar with however I'm not sure how to go about changing the "InputPath" to be the activeworkbook. I have been trying different things but to no avail, any more help be really appreciated.

Regards
Simon

I had overlooked a few things in my original post

The document sent out to fellow employees is called master.xlsx however when it is sent back to us in the office it may have been renamed for whatever reason. Each workbook received is opened to be reviewed, and so to have the code run from the already open workbook would avoid any issues with renamed documents, the sheets within the workbook will always remain the same.

I had filled in the locations of my documents into your code, but this causes the excel document to close to reopen. If this was avoidable it would be great

Thanks again

Just thought I will post my finished code for all to see, thanks for everybodies help on this topic

Please Login or Register  to view this content.