+ Reply to Thread
Results 1 to 3 of 3

Find data on other tabs and copy the cell informaiton to the right of it to the main page

  1. #1
    Registered User
    Join Date
    07-19-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    73

    Find data on other tabs and copy the cell informaiton to the right of it to the main page

    I attached a spreadsheet that has serial numbers on the first tab and matching serial numbers on the next tabs. I am looking to pull specific information from the subsequent tabs and copy that information to the main page.

    In the example, I am looking to pull "Contract Start Date" information from the other tabs and copy that information to the main page. So I want it to find the "Contract Start Date" and copy the cell to the right which has the date and place it under the "Contract Start Date" column on the first page. The "Contract Start Date" on the other tabs may not always be on the same row so there will have to be a way to find the data regardless of where it is located, thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Find data on other tabs and copy the cell informaiton to the right of it to the main p

    Fix the spelling mistake (Contract, not Contact) in cells B1 and C1, then use the following formula in B2:C2 and downwards:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    07-19-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    73

    Re: Find data on other tabs and copy the cell informaiton to the right of it to the main p

    That is exactly what I needed thanks for all your help.

+ 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. Setting Up and Creating a Macro to copy data from multiple tabs onto one main tab
    By Carrie1990 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-29-2012, 12:19 PM
  2. Transfer data from main page to individual tabs
    By BadExcelHeadache in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-02-2012, 09:26 AM
  3. Macro to create formula for Main Page from data on other page
    By Drew Davis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2011, 06:35 AM
  4. Linking multiple tabs to one main data sheet
    By PARTRIM in forum Excel General
    Replies: 2
    Last Post: 12-02-2010, 06:04 PM
  5. Find Last Empty Cell, Copy Data from Different Worksheets to One Main Worksheet
    By scgamecock in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2007, 12:12 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