Forum

Hi Sarfraz, Here is a formula you can use in column J, for Billing/Tripexp values: =IF(AND(O2<>"",ISNUMBER(SEARCH("vendor",C2))),"Bill...

Hi Thomas, A possible solution is to use a simple code to make a mirror copy of the Web Query sheet data: Sub CopyData() Sheets("Sheet3").U...

Hi, Can you share your query?

Hi, That does not seem to be your case. How is data coming into your workbook? Hard to see the problem without seeing the structure, but you mig...

Try Sheets("Sales Pivot").PivotTables("PivotTable2").Update

Hi, Try again with DoEvents placed in the first line of code, maybe some processes are not completed when the next line is called. Let us know i...

DoEvents should be enough. After you call a recalculation, check the calculation state before allowing the code to go to next stage: Applica...

There is a nice trick I use to create new rows, which may be very useful in case your data does not have an equal amount of rows to be added. This way...

Hi Julian, Try this: Remove the last formatting step (that formats the Full Name column as text) Delete the results table, refresh the query,...

Hi Michael, The only way is to put the tables side by side or in different sheets, there is no way to change the default background behavior, those...

Thanks for feedback Anders, I've seen the TEXT function used in visual basic UDF, to overcome regional settings (as there can be many variations, a...

You're welcome, glad to hear that it works as you waned.

Hi Keith, Only the version of Excel matters, 64 bit office needs a different API function declarations. Here is a sample of how you can change the ...

Hi Anders, Is the Excel version you are using in Swedish or in English? I know that text function behaves differently if the installed excel ver...

Hi, The code failed at: 8OZ GUSSRP Range Planning Grap sheet, the full name of that sheet was 8OZ GUSSRP Range Planning Graph The source of the ...