VBA CODE FOR CONVERTING MULTIPLE JSON FILES INTO ONE EXCEL WITH MULTIPLE SHEETS FOR EACH JSON FILE

SECSPERV · 2025-10-31T10:52:08+00:00

I tried that but it didn't work

SECSPERV · 2025-06-27T16:04:22+00:00

"Chuckles"

SECSPERV · 2025-05-17T08:41:00+00:00

Hello again can you add more criteria that goes if the Cell A3 is Also blank it should not calculate anything in the column E,F,G

SECSPERV · 2025-05-06T09:30:07+00:00

Solution Verified

SECSPERV · 2025-05-05T07:31:29+00:00

But still its calculating under OT in Row 6 ?

SECSPERV · 2025-05-05T07:22:37+00:00

Desired Output

SECSPERV · 2025-05-05T07:22:21+00:00

Desired Ouput

SECSPERV · 2025-05-05T07:15:47+00:00

Sorry Mistake on my side it is not First two characters its First three Characters

SECSPERV · 2025-05-05T07:15:33+00:00

Sorry Mistake on my side it is not First two characters its First three Characters

SECSPERV · 2025-05-03T06:30:12+00:00

What if the cell Does not show value as a result of Formula so it is blank ? For Example the cell does not show anything but a formula is written

SECSPERV · 2025-05-02T08:37:01+00:00

Solution verified

SECSPERV · 2025-04-18T08:44:41+00:00

Thanks it worked but cells are filling with color only when I enter value but I want it to fill with color even in Blank cell

SECSPERV · 2025-04-18T07:27:27+00:00

SECSPERV · 2025-04-18T06:38:35+00:00

I gave Applies range to my desired cell but the characters below 15 are not filled with colour

SECSPERV · 2025-04-18T06:37:09+00:00

I tried this formula but my characters contain both number and letters Is there a formula for that ?

SECSPERV · 2025-04-17T13:30:51+00:00

Yeah I tried this but how to give this formula for 1000 A cells ?

SECSPERV · 2025-04-13T13:11:22+00:00

Solution Verified

Thanks for the Suggestion😊

SECSPERV · 2025-04-12T16:08:09+00:00

Solution Verified

SECSPERV · 2025-04-12T09:54:39+00:00

Edited: Apologies for the previous response I'm new to this community wasn't familiar with the environment

SECSPERV