copying data from cells of one workbook into the next available row in other workbook

Hi

I have a workbook called "Quotation". Which has 3 worksheets.

The sheet I need to take data from is called "Internal Quotes" - Its sheet 1 in this workbook.

I want to run a command button that when pressed, puts information from specified cells of the "Internal Quote" worksheet into another workbook called "quotes sent".

For instance, I want to put Cells A1:A15 from the "Quotation" workbook ("Internal quote" sheet), into cell B1:B15 of the "Quotes Sent" workbook (which has only 1 sheet, Called "to date").

The only other criteria is that it needs to put it into the next clear row below the last entry, as I don't want to overwrite what is already in the "quotes sent" worksheet.

I hope you can help me with this.

Maybe:

Please Login or Register  to view this content.

Hi John just a quick question, do I need to put a path to the files anywhere?

Not if you have both workbooks open.

What if the Quotes Sent workbook is not open?

Just thought I would share what I did to get this working. It now sends information from multiple cells to another sheet that is closed. It opens that sheet, inputs the information and then closes that sheet. If you are running this locally its super fast.

The code I used is as follows:

Please Login or Register  to view this content.