Forum

Hi Faltoo, Welcome to our forum! You would need to use Power Query in file A to get the data in the table in file B. From there you can then merge ...

Hi Manoj, In the Demand sheet of the attached file I've added a column for Capacity. The values in red are the total capacity split across the two ...

Hi Claudine, In Power Query you use a Merge to do the equivalent of INDEX & MATCH or VLOOKUP/XLOOKUP. Your scenario isn't a straight forward mer...

Hi Manoj, If you want to see capacity at the project level then you need to change the way your data is being captured so that you're capturing it ...

Hi Manoj, Welcome to our forum. First, the easy question on how to build the percentage bars. Use Conditional Formatting Data Bars. Regarding yo...

Hi Andy, Please start a new thread in the VBA forum. Note that there is no guarantee you'll get someone to do this for you as the forum isn't a fre...

Hi Andy, Thanks for sharing your file, however I cannot access it as I don't have permission. The reason you aren't finding the answers in Googl...

Hi Tim, Thanks for sharing your file. Unfortunately, the website structure is not consistent which means the table numbers you need to extract vary...

Hi Jason, Welcome to our forum! You're on the right track, you need to create a join between the two tables, which is the equivalent of a VLOOKUP in...

Hi Jason, This error is caused by files that do not contain the column headers specified in the query, which is in line with how you've described y...

Hi Andy, Like I said, Excel can't detect cell fill colour and use that as a way to extract data...unless it's in a PivotTable and the format of you...

Hi Tom, I think VBA is probably overkill for what you want to do. I would have thought this is easily done with formulas. e.g. user chooses inputs ...

Hi Aye, I don't know what Think-cell is, but this tutorial explains how to embed Excel reports in PowerPoint. Mynda

Hi Barbara, Have you tried Unpivot Other Columns. i.e. select the columns you don't want to unpivot, then unpivot the rest. This should allow for ...

Hi Andy, Excel doesn't work like that. It's not able to detect cell fill colours with formulas. In the attached file I've used INDEX & MATCH to...