MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 259|Reply: 7

Copy and paste active cell and include adjacent cells

[Copy link]

2

Topics

5

Posts

16

Integral

Member

Rank: 2

Integral
16
Post on 2-10-2017 13:28:07 | All posts |Read mode
I have many rows of data in multiple columns (Cells A7:J1300).
A user selects a name from a validation list in Cell E2.
Once a name in E2 is chosen, I have a macro that selects the matching cell in Column D7:D1300 using Application.Goto .
What I am trying to do from here is:
1- Copy the active cell along with several cells adjacent to the active cell (example: copy active cell = cell D:200 + E:200 through U:200)
2- Paste values of all those cells in the next available (empty) row in say sheet2.
3- Message box confirming that cells have been pasted
4- Hide or possibly Delete the row the entire row from which all the cells were copied from.
Struggling with the adjacent cells and deleting/hiding the original row.
Any help would be greatly appreciated.
Reply

Props Report

7

Topics

603

Posts

1331

Integral

King

Rank: 6Rank: 6

Integral
1331
Post on 2-10-2017 16:48:24 | All posts



A sample of your sheet would have been useful.
How many names in your Validation List?  I normally find that approach verrrrrrrrry slow.
I will produce an example for you.
Attach a sample workbook.  Make sure there is just enough data to demonstrate your need.  Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.  Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to
[color=] Manage Attachments
to open the upload window.
Reply Support Opposition

Props Report

7

Topics

603

Posts

1331

Integral

King

Rank: 6Rank: 6

Integral
1331
Post on 2-11-2017 15:54:03 | All posts



A sample of your sheet would have been useful.
How many names in your Validation List?  I normally find that approach verrrrrrrrry slow.
I will produce an example for you.
Attach a sample workbook.  Make sure there is just enough data to demonstrate your need.  Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.  Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to
[color=] Manage Attachments
to open the upload window.








  • test.xlsm
    (35.5 KB, 0 views)
    Download
















  • Reply Support Opposition

    Props Report

    2

    Topics

    5

    Posts

    16

    Integral

    Member

    Rank: 2

    Integral
    16
     Author| Post on 2-11-2017 16:43:42 | All posts



    I was actually able to solve the basics of my original post. Thanks for the reply. I am posting a different issue that I'm now faced with a new separate thread.
    Reply Support Opposition

    Props Report

    7

    Topics

    603

    Posts

    1331

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1331
    Post on 2-11-2017 18:16:00 | All posts



    A sample of your sheet would have been useful.
    How many names in your Validation List?  I normally find that approach verrrrrrrrry slow.
    I will produce an example for you.
    Attach a sample workbook.  Make sure there is just enough data to demonstrate your need.  Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.  Make sure your desired results are shown, mock them up manually if necessary.
    Remember to desensitize the data.
    Click on GO ADVANCED and then scroll down to
    [color=] Manage Attachments
    to open the upload window.








  • test.xlsm
    (35.5 KB, 2 views)
    Download
















  • Reply Support Opposition

    Props Report

    7

    Topics

    603

    Posts

    1331

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1331
    Post on 2-11-2017 19:27:23 | All posts



    A sample of your sheet would have been useful.
    How many names in your Validation List?  I normally find that approach verrrrrrrrry slow.
    I will produce an example for you.
    Attach a sample workbook.  Make sure there is just enough data to demonstrate your need.  Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.  Make sure your desired results are shown, mock them up manually if necessary.
    Remember to desensitize the data.
    Click on GO ADVANCED and then scroll down to
    [color=] Manage Attachments
    to open the upload window.








  • test.xlsm
    (35.5 KB, 4 views)
    Download
















  • Reply Support Opposition

    Props Report

    7

    Topics

    603

    Posts

    1331

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1331
    Post on 2-11-2017 21:58:43 | All posts



    A sample of your sheet would have been useful.
    How many names in your Validation List?  I normally find that approach verrrrrrrrry slow.
    I will produce an example for you.
    Attach a sample workbook.  Make sure there is just enough data to demonstrate your need.  Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.  Make sure your desired results are shown, mock them up manually if necessary.
    Remember to desensitize the data.
    Click on GO ADVANCED and then scroll down to
    [color=] Manage Attachments
    to open the upload window.








  • test.xlsm
    (35.5 KB, 7 views)
    Download
















  • Reply Support Opposition

    Props Report

    7

    Topics

    603

    Posts

    1331

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1331
    Post on 2-12-2017 01:50:51 | All posts



    A sample of your sheet would have been useful.
    How many names in your Validation List?  I normally find that approach verrrrrrrrry slow.
    I will produce an example for you.
    Attach a sample workbook.  Make sure there is just enough data to demonstrate your need.  Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.  Make sure your desired results are shown, mock them up manually if necessary.
    Remember to desensitize the data.
    Click on GO ADVANCED and then scroll down to
    [color=] Manage Attachments
    to open the upload window.








  • test.xlsm
    (35.5 KB, 9 views)
    Download
















  • Reply Support Opposition

    Props Report

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 9-21-2017 14:35 , Processed in 0.134709 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!