Forum Discussion

JoAvg's avatar
JoAvg
Brass Contributor
May 19, 2022
Solved

Search value in multiple Sheets - Fill adjacent cells when value is found

Hi everyone.   In Sheet1!C11 I have a value X. In Sheet 2 Table1, in Sheet 3 Table2 and in Sheet4 Table3. Value X will appear only once in all of three Tables, in Column G.   I am in need of a ...
excel
Macros and VBA
office 365
JoAvg's avatar
JoAvg
Brass Contributor
May 20, 2022

Just bumping this up.

 

HansVogelaar maybe you could be of assistance on this one?

 

Thanks.

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 20, 2022

    JoAvg 

    Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.

    • JoAvg's avatar
      JoAvg
      Brass Contributor
      May 20, 2022

      HansVogelaar 

      Made a dummy file keeping all the functions without the sensitive data.

      Hope I shared it the right way..

      https://1drv.ms/x/s!AvoleB1tsIJ8l2FgXbp1vjqpCcp3?e=s7jhvm

       

      Will be waiting for your response.

      Thank you!

       

       

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        May 20, 2022

        JoAvg 

        Thanks, I have downloaded the workbook.

        Can you now explain what you want using the sheet names and ranges of the dummy workbook?

Resources