+ Reply to Thread
Results 1 to 7 of 7

Search a value and copy the adjacent value in other sheet

  1. #1
    Registered User
    Join Date
    02-17-2011
    Location
    india
    MS-Off Ver
    Excel 2016 (home & student version)
    Posts
    79

    Search a value and copy the adjacent value in other sheet

    Hi all,

    I have attached a demo file, where as in that sheet there is total 7 sheets in seventh sheet i need to display the adjacent value of the criteria i had there. and want to find the all sheets i.e. all 6 sheets and fetch the data and place in sheet 7.

    I tried using indirect and countif function, but it only counts. but i need the adjacent value also.
    Attached Files Attached Files

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Search a value and copy the adjacent value in other sheet

    This is worksheet event code. Copy this to your worksheet code module and save your workbook as a macro enabled workbook. The code will execute when you make changes to cell C3 on sheet 7.

    Please Login or Register  to view this content.
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

  3. #3
    Registered User
    Join Date
    02-17-2011
    Location
    india
    MS-Off Ver
    Excel 2016 (home & student version)
    Posts
    79

    Re: Search a value and copy the adjacent value in other sheet

    Thanks for reply. but i m looking without macro i mean from formula can it be derieved.

  4. #4
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Search a value and copy the adjacent value in other sheet

    Quote Originally Posted by FUN2BALA View Post
    Thanks for reply. but i m looking without macro i mean from formula can it be derieved.
    OK, can't help you with that type of formula, but maybe someone else will pick up on the thread and provide a solution.
    Regards, JLG

  5. #5
    Forum Contributor
    Join Date
    03-30-2016
    Location
    Gillette, WY
    MS-Off Ver
    Office 365
    Posts
    230

    Re: Search a value and copy the adjacent value in other sheet

    The way you have this structured is going to make this very difficult. Can I ask why there seems to be no consistency in where values you are trying to retrieve are located across the 6 sheets? I'm assuming there is additional data that you did not attach. Can you reorganize the data so that these values are all located in the same place on each sheet?

  6. #6
    Registered User
    Join Date
    02-17-2011
    Location
    india
    MS-Off Ver
    Excel 2016 (home & student version)
    Posts
    79

    Re: Search a value and copy the adjacent value in other sheet

    thanks sir, no problem let see.

  7. #7
    Registered User
    Join Date
    02-17-2011
    Location
    india
    MS-Off Ver
    Excel 2016 (home & student version)
    Posts
    79

    Indirect function to pull data from other sheet

    Yes i know bcoz the data is like that only but i dleted the irrrelevant things. now i attaching the little bit structured sheet as u understand, i tried it. and i used the formula for that indirect function where as i ccan get the things in other sheet name then i used countif and indirect function to count and it counted but i want the advance and amt simultaneously. thanks for ur reply.
    Attached Files Attached Files
    Last edited by FUN2BALA; 02-02-2018 at 07:39 AM.

+ 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. Replies: 14
    Last Post: 10-29-2015, 07:29 PM
  2. [SOLVED] Search for string, copy adjacent cell
    By omaolain in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-05-2014, 10:44 AM
  3. [SOLVED] Search for value, and then copy value in adjacent column
    By T15K in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-01-2013, 02:08 AM
  4. Re-useability:Search a keyword and copy adjacent cell to in another sheet
    By illustratum in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2013, 06:54 PM
  5. Search for Word and Copy Adjacent Cell(s)
    By BrittanyK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-09-2011, 04:05 PM
  6. Search and copy adjacent cells
    By bennimartin in forum Excel General
    Replies: 1
    Last Post: 12-14-2010, 02:11 AM
  7. Search to find matching cells and copy/transpose adjacent data to original sheet?
    By thump4r in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-12-2009, 09:20 PM

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