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?

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

        HansVogelaar 

        Sorry for the late reply.

        So, in Sheet SL&UR I got a search box in B3, which returns a code in C11. In the example the value is CP42735.

        I want to search for the C11 value in Sheets SL_2019, SL_2021 and SL_2022 and in whatever row it is found I want to fill the adjacent rows in Columns L with Today() date, M with "Crew_1" and Q with "Drawn".

        In the example the value is found in SL_2019!G13, so the end result would be:

        SL_2019!L13=23/5/2022

        SL_2019!M13=Crew_1

        SL_2019!Q13=Drawn

         

        Hope you can come with up with some of your magic.

Resources