Hi,
Not sure if this is right place to post this.
Basically i've got a multi tab workbook, one tab has a Master SKU record containing SKU codes and corresponding products, sizes, pricing etc, this info is used to populate about 5 or 6 different tabs, my SKU codes run to approx 110 lines, currently i'm using Xlookup to retrieve this information on each tab (would say i'm looking at around 2500 Xlookup formulas in total across all tabs)
My data in the Master record can change every now and then so I do need some form of lookup against it
Recently i've starting playing around with Power Query, I was wondering if i'd see any potential gains from using Power Query and Merge Query to retrieve the information so the sheets aren't having to constantly do the Xlookups and then only doing a Refresh once i know a SKU has changed.
Anyone able to offer any insights on if this could be benefical or would be a colossal failure in the making?
Kind Regards
Nim
Not sure if this is right place to post this.
Basically i've got a multi tab workbook, one tab has a Master SKU record containing SKU codes and corresponding products, sizes, pricing etc, this info is used to populate about 5 or 6 different tabs, my SKU codes run to approx 110 lines, currently i'm using Xlookup to retrieve this information on each tab (would say i'm looking at around 2500 Xlookup formulas in total across all tabs)
My data in the Master record can change every now and then so I do need some form of lookup against it
Recently i've starting playing around with Power Query, I was wondering if i'd see any potential gains from using Power Query and Merge Query to retrieve the information so the sheets aren't having to constantly do the Xlookups and then only doing a Refresh once i know a SKU has changed.
Anyone able to offer any insights on if this could be benefical or would be a colossal failure in the making?
Kind Regards
Nim