+ Reply to Thread
Results 1 to 11 of 11

Dynamic Data Table Query

  1. 08-11-2023, 12:18 PM #1
    McCaff84
    McCaff84 is offline
    Registered User
    Join Date
    08-24-2017
    Location
    Belfast, N.Ireland
    MS-Off Ver
    2021
    Posts
    8

    Dynamic Data Table Query

    Hi

    Was trying to find a thread linking to the query, but haven't been successful.

    I've attached an excel to explain what I'm trying to achieve, if possible without VBA coding, albeit would welcome solutions if this is required.

    At present, when using a two variable data table, I'm hardcoding in the two base case numbers. So for example Capital Receipt in cell F8 hard plugged as is the entry to the data table in K8 and the same for Costs F9 and H11.

    Is there a way to do this were K8 and H11 link to the inputs at F8 and F9 without having to then hard plug the same figures into data table please? Appreciate the spread in the data table should pick up the variances, but for new projects etc where inputs are significantly different it would be helpful. Also good for errors if forgetting to run data table before issuing.

    Thanks in advance.
    Best,
    Mike
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-12-2023, 12:55 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,953

    Re: Dynamic Data Table Query

    Are you still using Excel 2010?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 08-12-2023, 02:07 AM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Dynamic Data Table Query

    I don't even understand the question (I'm not an accountant... or anything like it)!

    What do you expect to see?

    Where do you expect to see it?
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  4. 08-12-2023, 04:13 AM #4
    McCaff84
    McCaff84 is offline
    Registered User
    Join Date
    08-24-2017
    Location
    Belfast, N.Ireland
    MS-Off Ver
    2021
    Posts
    8

    Re: Dynamic Data Table Query

    No using Excel 2021.
    Reply With QuoteRegister To Reply
  5. 08-12-2023, 04:14 AM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,953

    Re: Dynamic Data Table Query

    Then please update your forum profile to that effect. Thanks.
    Reply With QuoteRegister To Reply
  6. 08-12-2023, 04:53 AM #6
    McCaff84
    McCaff84 is offline
    Registered User
    Join Date
    08-24-2017
    Location
    Belfast, N.Ireland
    MS-Off Ver
    2021
    Posts
    8

    Re: Dynamic Data Table Query

    Sorry Glenn I've been unclear.

    In Cell K8 can I reference cell F8 and in Cell H11 can I reference cell F9 and have the data table return the correct profit see excel attached as example.

    What I expect to see is the Green cell in the middle match profit figure.

    Hope this is clearer.

    Thanks
    M
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 08-12-2023, 05:03 AM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,953

    Re: Dynamic Data Table Query

    How has the function TABLE been defined? I cannot see it in the workbook.

    Anyway, in K8:

    =F8

    and in H11:

    =F9

    and in I9 copied across and down:

    =SUM(I$8,$H9)
    Attached Files Attached Files
    Last edited by AliGW; 08-12-2023 at 05:09 AM. Reason: Workbook added.
    Reply With QuoteRegister To Reply
  8. 08-12-2023, 06:32 AM #8
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,953

    Re: Dynamic Data Table Query

    Seen, but no response ...

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
    Reply With QuoteRegister To Reply
  9. 08-12-2023, 06:41 AM #9
    McCaff84
    McCaff84 is offline
    Registered User
    Join Date
    08-24-2017
    Location
    Belfast, N.Ireland
    MS-Off Ver
    2021
    Posts
    8

    Re: Dynamic Data Table Query

    Thanks for that Ali.
    Reply With QuoteRegister To Reply
  10. 08-12-2023, 06:43 AM #10
    McCaff84
    McCaff84 is offline
    Registered User
    Join Date
    08-24-2017
    Location
    Belfast, N.Ireland
    MS-Off Ver
    2021
    Posts
    8

    Re: Dynamic Data Table Query

    Ali, I had had just opened it and was reviewing it together with other work. Apologies if I didn't acknowledge your response in a timely enough fashion!!
    Reply With QuoteRegister To Reply
  11. 08-12-2023, 06:48 AM #11
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,953

    Re: Dynamic Data Table Query

    Does it do what you want? I presume it does as you've marked this as SOLVED.

    It's always a good idea to acknowledge help offered and say that you are going to test it rather than not saying anything at all.

    If you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
    Last edited by AliGW; 08-12-2023 at 06:51 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to create dynamic source for a pivot table from a append table in power query
    By excelsorusor in forum Excel General
    Replies: 1
    Last Post: 11-12-2018, 02:46 PM
  2. Dynamic link to Access query for updating Excel table
    By BanginMyHeadOnMyDesk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2017, 11:45 AM
  3. Copy Data from Dynamic Web Query to Another Workbook
    By kingsdime29x in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2016, 10:26 AM
  4. [SOLVED] XY scatter plot and 'table' for dynamic x and dynamic names from which the data is pulled
    By Geoff. in forum Excel General
    Replies: 10
    Last Post: 10-09-2014, 06:20 PM
  5. Find data source of table, not query table ... and how is a query table not a query table?
    By gyclone in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2012, 03:48 PM
  6. Web Query dynamic destination or VBA to copy and paste new data alongside existing data
    By Marbleking in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-12-2012, 06:03 PM
  7. Dynamic table formula for sorting data to another table dynamic
    By 650dozer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2012, 07:22 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1