Forum

Hi Sheralee, No workbook attached. Click on the Start Upload button after selecting the file. Phil

Hi Nesha, Surely it's in your colleague's best interest to learn skills that make their job easier? Why persist doing something the old way just b...

Hi Nesha, Why don't you want to use Power Query? It would make things much easier than using formulae. Regarding the formatting of the numbers,...

Hi Samir, Hard to help with that since it's out of context. Need all the other code around it to see why it isn't working. Phil

Hi, He may have written the code in the editor but I didn't see him run it. If he ran it, it would generate an error because it is incorrect. I a...

Hi, Your qs has remained without a response for a few reasons: What you are asking for isn't actually a quadrant map. Quadrant maps have 4 se...

Hi, The syntax is not valid. What are you trying to do with that code? As an example, this line will hide Row 1 Range("A1").EntireRow.Hidden...

Hi Nick, No file attached. You have to click the Start Upload button after selecting the file, then wait for it to upload. Phil

You're welcome Greg, glad to be able to help. regards Phil

Hi Greg, The syntax of Record.Field around the API call wasn't right. The "price" field name was in the wrong place. This works = Record.Fie...

Hi Greg, It's hard to help because I don't have the file and code that you are using. Can you make a copy of the file, change the API credentials ...

Hi Tina, There's no file attached with data to test this on so hard to say. If I use that formula in an empty workbook, that has a sheet called ...

No worries, Phil

Hi Alan, So the end result would look like this? Description Amount SumColumn 1001 150 600 1001 200 600 1001 250 60...

You're welcome. Phil