Closed Thread
Results 1 to 2 of 2

To copy cell names along with their values in other sheet

  1. #1
    Forum Contributor
    Join Date
    08-28-2010
    Location
    delhi,india
    MS-Off Ver
    Excel 2007
    Posts
    128

    To copy cell names along with their values in other sheet

    Here's an attached sample file which will clearly indicate what I require.
    I just found out that same name cannot represent two cells in a workbook.
    Sheet1 contains the format which is copied to sheet2 in the way as shown.
    Now Sheet1 has names defined for various cells like Potato for cell containing Potato and so on.
    You will find that sheet2 has name Title_potato name for cell contaning potato.
    This Title_potato and other names in sheet2 I want to generate with a vba code when contents are copied from sheet1 from sheet2.
    I hope now it is clear.
    any help will be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: To copy cell names along with their values in other sheet

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

Closed Thread

Thread Information

Users Browsing this Thread

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

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