+ Reply to Thread
Results 1 to 2 of 2

Getting cell number using cell value in the file

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    Getting cell number using cell value in the file

    I have multiple excel file which has product information , i need to copy paste this data to new workbook

    i can copy all the values in sample till product (cell A10)

    but the cell product visibility position in sample is A16, this may not be same for all files. it could be A20 for one file

    i need to get cell value for this 'Product visiblity' like for the sample i need A16 , based on this i would copy B16 value in other words i need 16 as return value for this sample .

    how can i do this in vba, it could change from file to file i cannot hardcode this

    please help with this code

    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010

    Re: Getting cell number using cell value in the file

    Will you be looking for "Product Visibility" all the time? Did you consider using "Find" for this word and retrieving value of a cell which is one cell right to where you find this word?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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