Forum

Hi Poh, I'd probably use SUMPRODUCT but I don't clearly understand your question. What is it you want to sum, the Amount? If so, how does F c...

Hi Chris, It will be much easier, and new rows added to your source table will be automatically included in the final report, if you create a pivot...

Hi Oscar, Just change the IF statement in the Worksheet_Change event If (Not Intersect(Target, ActiveSheet.Range("DV_Range")) Is Nothing) Or (No...

Hi Chris, the output table in the workbook isn't in a tabular format so it's not in a layout that can easily be used with pivot tables etc. The ...

Hi Robb, Your PT will only display the data you feed into it. So if you want to show all dates in a month, you need to have all those dates in the...

Hi Christine, This post has code that creates PDF's VBA to Create PDF from Worksheet and this one has code to automate Pivot Tables VBA to...

Hi, The 3rd word in your list is cats and ~c?t matches the cat part, so replacing cat with cass you get casss cats casss Regards Phil

Hi, All posts from non-course members are moderated. We don't sit in front of our PC's all day, so sometimes approving posts takes a few hours. ...

Hi Robert, This might sound odd, but why would you want to do that? It breaks the ideal tabular data format. You should have dates in a single co...

No worries Stan, glad you figured it out. Regards Phil

Hi Mohamed, I'll need to see the text file(s) and an example of what you want the resulting table to look like. Without these I can't write a quer...

Hi, Try this Workbooks.Open Range("A1").Value & ".xlsx" Regards Phil

Hi Stan, Please supply your workbook and query, and some source data. Phil

Hi Bob, Please attach your file for me to check. Thanks Phil