Results 1 to 3 of 3

Linking Sheets with INDIRECT Not Working

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2022
    Location
    india
    MS-Off Ver
    2013
    Posts
    2

    Linking Sheets with INDIRECT Not Working

    I have prepared a excel work book for planning the IATF Audit quarter wise from Jan to Dec 2022, sheet named as Audit Schedule IATF2022 , which is attached with this post.

    In the work book ,there is one sheet named as IATF audit Schedule (2), in this sheet the column are headed as process name, 1st Quarter, the months are named as quarterwise from jan to march first quarter,
    from this sheet , I want to link the another sheet named as quarter1, quarter 2, etc.
    the quarter sheet having column named as process , Auditor, Date of Audit. I want to update the quarter wise sheet automatically as we change the IATF audit Schedule sheet in process name , auditor name , audit date columns.

    I used offset function to get the process name and get result correctly but the offset function not working to get the result for auditor name and date of audit.

    the these two column are to get linked with the sheet named as IATF audit column in which the Auditor name and Audit date appear.

    in the attached sheet , i have done it manually but, I want to use excel function for updation
    Attached Files Attached Files
    Last edited by Vishvakarma; 10-06-2022 at 12:54 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 06-12-2020, 01:55 PM
  2. Replies: 2
    Last Post: 02-23-2020, 12:21 PM
  3. Replies: 9
    Last Post: 02-01-2019, 07:10 AM
  4. Crosstab table to pivot table to plain table exceeds Excel row limit
    By jjsilva in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-30-2017, 11:43 PM
  5. Copying Excel table range to an existing PPT slide, pasting as TABLE, not as PICTURE
    By gurnblanston27 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-2016, 04:44 PM
  6. INDEX(MATCH()) between Excel Table and Duplicate of Excel Table
    By ExcelBin in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-28-2015, 05:16 AM
  7. Replies: 0
    Last Post: 11-06-2014, 07:25 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