Macro to copy data to separate excel sheet

Hi

I am trying to create a macro to copy highlighted data in one excel sheet into the first empty cell down a cloumn in a separate excel sheet.

I am fairly proficient in using excel (formulas, formating etc) but i am struggling with creating macros to do what i want.

Any guidance on this issue would be very much appreciated.

Cheers
Eric

Sorry, i didnt phrase my question correctly, it should be 'selected' cells not highlighted.

Not quite what i was after.

I need the cells that i manually select to be copied and pasted into a different excel file (samples_submitted_2012.xlsx![Submitted]) in the first cell down column A that is blank.

Ok that works, thankyou very much. Is it possible for this macro to work when the destination workbook (where the values are pasted) is not open?

I have worked out how to open a the samples_submitted_2012 workbook when closed, but...if the book is already open is there away of bypassing the first line of code? so i dont re-open it.

Please Login or Register  to view this content.

Hi Xladept

I have been working on this VBA script, and i have it working the way i want...except that when the workbooks that i am copying the data into are open the the macro will not recognize this and will try to re-open them, which i dont want.

Please Login or Register  to view this content.

I am getting the error Method 'Range' of object '_worksheet' failed

and when i debug, it highlights the code: r = ws.Range("A" & Rows.Count).End(xlUp).Row + 1

Ok so i got it working, here is the code, dont fully understand why this works and not the last code you posted doesnt?

Please Login or Register  to view this content.

Thanks alot for your help on this Xladept.