+ Reply to Thread
Results 1 to 8 of 8

clicking on any one of the cell in a group should select all cells in group and copy value

  1. #1
    Registered User
    Join Date
    06-02-2016
    Location
    mumbai,india
    MS-Off Ver
    2007
    Posts
    18

    clicking on any one of the cell in a group should select all cells in group and copy value

    Hello

    Clicking on any cell of the group ( range of cells ),should select and copy all the cell values of that group

    like example

    there is range of cells from

    C1 - G1
    . .
    . .
    . .
    C11-G11

    If i click on any cell of this range say D7, C3 ,E6 , F11,G6 etc etc.....like that any cell with in this range should select all cells of this range group and copy automatically....

    Thank you

  2. #2
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: clicking on any one of the cell in a group should select all cells in group and copy v

    Where do you want to copy it to? Or do you just want it to copy?
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

  3. #3
    Registered User
    Join Date
    06-02-2016
    Location
    mumbai,india
    MS-Off Ver
    2007
    Posts
    18

    Re: clicking on any one of the cell in a group should select all cells in group and copy v

    wanted to be copied and pasted in new next sheet if possible

  4. #4
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: clicking on any one of the cell in a group should select all cells in group and copy v

    Hi,

    Try the attached sheet. Is this what you are after?
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-02-2016
    Location
    mumbai,india
    MS-Off Ver
    2007
    Posts
    18

    Re: clicking on any one of the cell in a group should select all cells in group and copy v

    Thats working fine but when I am clicking any cell it is selecting only row

    but i want all the cells from this particular range of " c1-g1 " to " c11 to g11 " only ,means selecting columns and rows also.

    the cells which are getting copied are very finely pasted automatically in other sheet...that looks very fine.

    Is it possible to save separately that "sheet 2 " separately in " csv format " once the values are pasted in it from sheet 1 once i clicked any one of the cell from that only particular range of group of cells from sheet 1

  6. #6
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: clicking on any one of the cell in a group should select all cells in group and copy v

    Oh ok, try this...
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    06-02-2016
    Location
    mumbai,india
    MS-Off Ver
    2007
    Posts
    18

    Re: clicking on any one of the cell in a group should select all cells in group and copy v

    I am getting error msg - run time error

  8. #8
    Registered User
    Join Date
    06-02-2016
    Location
    mumbai,india
    MS-Off Ver
    2007
    Posts
    18

    Re: clicking on any one of the cell in a group should select all cells in group and copy v

    If I am editing anything in that sheet and range in the code , it is not running as per the new range given it was copying only the first given range only but also with a runtime eroor path not found

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] (VBA) How Assign Column Cell To Corresponding Group, and Paste Group Cells into Groups WS?
    By eryksd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-08-2016, 06:18 PM
  2. Replies: 0
    Last Post: 10-21-2014, 03:20 PM
  3. VBA to search a group of cells and input a message if a value is missing from the group
    By ntaylor652 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-19-2014, 05:30 AM
  4. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  5. [SOLVED] Look up value then determine group then copy group to different worksheet.
    By kkezir in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-01-2013, 01:35 PM
  6. Replies: 0
    Last Post: 02-04-2013, 03:25 PM
  7. [SOLVED] copy cell info to another group of cells
    By dalerdd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2012, 07:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1