Previous Topic Next Topic

Copy certain Excel cells to new sheet

Closed
E - 27 May 2010 à 11:26
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 28 May 2010 à 17:23
Hello,

I have data that is inserted in a row. I'm trying to create a macro that will copy certain cells within that row and paste them into cells in a different worksheet. The macro will be assigned to a text box at the end of each row, so in clicking that text box, the user is prompted for the file name and then the macro copies and pastes the data in the appropriate cells in the new sheet. How do I get the macro to reference only the row I'm currently inputting data into? Here's a snippet; I believe the rest of the code I'm using works since I copied it from another macro similar to this (but used in a different manner).

invoiceWS.Range(invoiceInvoiceCell) = srcWS.Range(srcInvoiceCol & ???)
invoiceWS.Range(invoiceDateCell) = srcWS.Range(srcDateCol & ???)
invoiceWS.Range(invoiceLastNameCell) = srcWS.Range(srcLNameCol & ???)



4 responses

Réponse 1 / 4
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
27 May 2010 à 16:44
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.
Réponse 2 / 4
add
27 May 2010 à 19:01
have a button on each row to activate the macro that will copy that row
Réponse 3 / 4
Er
28 May 2010 à 17:20
Columns A, B, C, D, E, F, G, H, I, J, K, L, M will have data as it's entered into that row. Columns A, B, C, D, G, contain data that I need to copy and paste to a different spreadsheet, in different locations (meaning A1 of source is F13 of destination). I can create a button to place at the end of the row and create a macro but I haven't been able to get it to replicate properly when the button and macro are copied to each row. If data starts on row 3, for example, and I create the first button there, it copies row 3. Copy the button and macro to row 4, it tries to copy row 3 again.

LAST FIRST EMAIL PHONE COUNTRY STATE CITY.....
Doe John j@d.c 111-111-1111 US GA Atlanta
Réponse 4 / 4
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
28 May 2010 à 17:23
That is the reason that I was saying if you can upload a sample file with sample data and MACRO, it is easier to see what is the issue.

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses