Need to add a few more lines in the code.

RAJESH1960

RAJESH1960

Banned for repeated rules violations
Joined
Mar 26, 2020
Messages
2,313
Office Version
  1. 2019
Platform
  1. Windows
Hello JohnnyL

With the help of your code, I have successfully created this new app where the range is different. There is no 2A or Tally rows in this app. It has to match the GSTIN of all rows. It works perfectly. In this app, with your edited code, I need to continue the code with a few more lines of code and also edit the message box. After the code is run, I want the code to

  • Look for errors in GSTIN verification sheet Column K, and if found I want the rows with errors to be colored Yellow in the Purchases Sheet. Message box to display “GSTIN not matching. Check & Edit.”
  • If errors not found then the msg box to display “All GSTIN Numbers Matched.”
  • When I run the code, the web site is in full view while running. If possible, avoid or run the web site in the background and hidden from display with one of those lines you use to avoid opening the hidden sheets like Application.DisplayAlerts…
  • When the code is making a copy of the Purchases sheet, avoid copying the code button in the copied sheet (GSTIN verification sheet).
  • This data doesn’t have green color but as your code runs and works for the green cells, I have colored all the rows as green. I was not able to edit that part. If it is easy to change the green part, please change it otherwise it is easy to color the rows in green and then run the code. As you wish.Test get GSTIN of Purchases Ledgers.xlsm
 
Sort by date Sort by votes
I told you in the beginning itself. I have created and customized this new one from your code and it is different from the previous one except for the range and sheets.
 
Upvote 0

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
johnnyL said:
Ok, I give you that.

You are saying the following should give an error?

Test get GSTIN of Purchases Ledgers.xlsm
ABC
1LineGSTIN of supplierTrade/Legal name of the Supplier
21GSTIN NO. 1
32GSTIN NO. 2
43GSTIN NO. 3
54GSTIN NO. 4
65GSTIN NO. 5
76GSTIN NO. 6
87GSTIN NO. 7
98GSTIN NO. 8
109GSTIN NO. 9
1110GSTIN NO. 10
1211GSTIN NO. 11
1312GSTIN NO. 12
1413GSTIN NO. 13
1514GSTIN NO. 14
1615GSTIN NO. 15
1716GSTIN NO. 16
1817GSTIN NO. 17
1918GSTIN NO. 18
2019GSTIN NO. 19
2120GSTIN NO. 20
2221GSTIN NO. 21
2322GSTIN NO. 22
2423GSTIN NO. 23
2524GSTIN NO. 24
2625GSTIN NO. 25
2726GSTIN NO. 26
2827GSTIN NO. 27
2928GSTIN NO. 28
3029GSTIN NO. 29
3130GSTIN NO. 30
3231GSTIN NO. 31
3332GSTIN NO. 32
3433GSTIN NO. 33
3534GSTIN NO. 34
3635GSTIN NO. 35
3736GSTIN NO. 36
3837GSTIN NO. 37
3938GSTIN NO. 38
4039GSTIN NO. 39
4140GSTIN NO. 40
4241GSTIN NO. 41
4342GSTIN NO. 42
4443GSTIN NO. 43
4544GSTIN NO. 44
4645GSTIN NO. 45
4746GSTIN NO. 46
4847GSTIN NO. 47
4948GSTIN NO. 48
5049GSTIN NO. 49
5150GSTIN NO. 50
5251GSTIN NO. 51
5352GSTIN NO. 52
5453GSTIN NO. 53
5554GSTIN NO. 54
5655GSTIN NO. 55
5756GSTIN NO. 56
5857GSTIN NO. 57
5958GSTIN NO. 58
6059GSTIN NO. 59
6160GSTIN NO. 60
6261GSTIN NO. 61
6362GSTIN NO. 62
6463GSTIN NO. 63
6564GSTIN NO. 64
6665GSTIN NO. 65
6766GSTIN NO. 66
6867GSTIN NO. 67
6968GSTIN NO. 68
7069GSTIN NO. 69
7170GSTIN NO. 70
7271GSTIN NO. 71
7372GSTIN NO. 72
7473GSTIN NO. 73
7574GSTIN NO. 74
7675GSTIN NO. 75
7776GSTIN NO. 76
7877GSTIN NO. 77
7978GSTIN NO. 78
8079GSTIN NO. 79
8180GSTIN NO. 80
8281GSTIN NO. 81
8382GSTIN NO. 82
8483GSTIN NO. 83
8584GSTIN NO. 84
8685GSTIN NO. 85
8786GSTIN NO. 86
8887GSTIN NO. 87
8988GSTIN NO. 88
9089GSTIN NO. 89
9190GSTIN NO. 90
9291GSTIN NO. 91
9392GSTIN NO. 92
9493GSTIN NO. 93
9594GSTIN NO. 94
9695GSTIN NO. 95
9796GSTIN NO. 96
9897GSTIN NO. 97
9998GSTIN NO. 98
10099GSTIN NO. 99
101GSTIN NO. 100
102GSTIN NO. 101
103GSTIN NO. 102
104GSTIN NO. 103
105GSTIN NO. 104
106GSTIN NO. 105
107GSTIN NO. 106
108GSTIN NO. 107
109GSTIN NO. 108
110GSTIN NO. 109
111GSTIN NO. 110
112GSTIN NO. 111
113GSTIN NO. 112
114GSTIN NO. 113
115GSTIN NO. 114
116GSTIN NO. 115
117GSTIN NO. 116
118GSTIN NO. 117
119GSTIN NO. 118
120GSTIN NO. 119
121GSTIN NO. 120
122GSTIN NO. 121
123GSTIN NO. 122
124GSTIN NO. 123
125GSTIN NO. 124
126GSTIN NO. 125
127GSTIN NO. 126
128GSTIN NO. 127
129GSTIN NO. 128
130GSTIN NO. 129
131GSTIN NO. 130
132GSTIN NO. 131
133GSTIN NO. 132
134GSTIN NO. 133
135GSTIN NO. 134
136GSTIN NO. 135
137GSTIN NO. 136
138GSTIN NO. 137
139GSTIN NO. 138
140GSTIN NO. 139
141GSTIN NO. 140
142GSTIN NO. 141
143GSTIN NO. 142
144GSTIN NO. 143
145GSTIN NO. 144
146GSTIN NO. 145
147GSTIN NO. 146
148GSTIN NO. 147
149GSTIN NO. 148
150GSTIN NO. 149
151GSTIN NO. 150
152GSTIN NO. 151
153GSTIN NO. 152
154GSTIN NO. 153
155GSTIN NO. 154
156GSTIN NO. 155
157GSTIN NO. 156
158GSTIN NO. 157
159GSTIN NO. 158
160GSTIN NO. 159
161GSTIN NO. 160
162GSTIN NO. 161
163GSTIN NO. 162
164GSTIN NO. 163
165GSTIN NO. 164
166GSTIN NO. 165
167GSTIN NO. 166
168GSTIN NO. 167
169GSTIN NO. 168
170GSTIN NO. 169
171GSTIN NO. 170
172GSTIN NO. 171
173GSTIN NO. 172
174GSTIN NO. 173
175GSTIN NO. 174
176GSTIN NO. 175
177GSTIN NO. 176
178GSTIN NO. 177
179GSTIN NO. 178
180GSTIN NO. 179
181GSTIN NO. 180
182GSTIN NO. 181
183GSTIN NO. 182
184GSTIN NO. 183
185GSTIN NO. 184
186GSTIN NO. 185
187GSTIN NO. 186
188GSTIN NO. 187
189GSTIN NO. 188
190GSTIN NO. 189
191GSTIN NO. 190
192GSTIN NO. 191
193GSTIN NO. 192
194GSTIN NO. 193
195GSTIN NO. 194
196GSTIN NO. 195
197GSTIN NO. 196
198GSTIN NO. 197
199GSTIN NO. 198
200GSTIN NO. 199
201GSTIN NO. 200
202GSTIN NO. 201
203GSTIN NO. 202
204GSTIN NO. 203
205GSTIN NO. 204
206GSTIN NO. 205
207GSTIN NO. 206
208GSTIN NO. 207
209GSTIN NO. 208
210GSTIN NO. 209
211GSTIN NO. 210
212GSTIN NO. 211
213GSTIN NO. 212
214GSTIN NO. 213
215GSTIN NO. 214
216GSTIN NO. 215
217GSTIN NO. 216
218GSTIN NO. 217
219GSTIN NO. 218
220GSTIN NO. 219
221GSTIN NO. 220
222GSTIN NO. 221
223GSTIN NO. 222
224GSTIN NO. 223
225GSTIN NO. 224
226GSTIN NO. 225
227GSTIN NO. 226
228GSTIN NO. 227
229GSTIN NO. 228
230GSTIN NO. 229
231GSTIN NO. 230
232GSTIN NO. 231
233GSTIN NO. 232
234GSTIN NO. 233
235GSTIN NO. 234
236GSTIN NO. 235
237GSTIN NO. 236
238GSTIN NO. 237
239GSTIN NO. 238
240GSTIN NO. 239
241GSTIN NO. 240
242GSTIN NO. 241
243GSTIN NO. 242
244GSTIN NO. 243
245GSTIN NO. 244
246GSTIN NO. 245
247GSTIN NO. 246
248GSTIN NO. 247
249GSTIN NO. 248
250GSTIN NO. 249
251GSTIN NO. 250
252GSTIN NO. 251
253GSTIN NO. 252
254GSTIN NO. 253
255GSTIN NO. 254
256GSTIN NO. 255
257GSTIN NO. 256
258GSTIN NO. 257
259GSTIN NO. 258
260GSTIN NO. 259
261GSTIN NO. 260
262GSTIN NO. 261
263GSTIN NO. 262
264GSTIN NO. 263
265GSTIN NO. 264
266GSTIN NO. 265
267GSTIN NO. 266
268GSTIN NO. 267
269GSTIN NO. 268
270GSTIN NO. 269
271GSTIN NO. 270
272GSTIN NO. 271
273GSTIN NO. 272
274GSTIN NO. 273
275GSTIN NO. 274
276GSTIN NO. 275
277GSTIN NO. 276
278GSTIN NO. 277
279GSTIN NO. 278
280GSTIN NO. 279
281GSTIN NO. 280
282GSTIN NO. 281
283GSTIN NO. 282
284GSTIN NO. 283
285GSTIN NO. 284
286GSTIN NO. 285
287GSTIN NO. 286
288GSTIN NO. 287
289GSTIN NO. 288
290GSTIN NO. 289
291GSTIN NO. 290
292GSTIN NO. 291
293GSTIN NO. 292
294GSTIN NO. 293
295GSTIN NO. 294
296GSTIN NO. 295
297GSTIN NO. 296
298GSTIN NO. 297
299GSTIN NO. 298
300GSTIN NO. 299
301GSTIN NO. 300
302GSTIN NO. 301
303GSTIN NO. 302
304GSTIN NO. 303
305GSTIN NO. 304
306GSTIN NO. 305
307GSTIN NO. 306
308GSTIN NO. 307
309GSTIN NO. 308
310GSTIN NO. 309
311GSTIN NO. 310
312GSTIN NO. 311
313GSTIN NO. 312
314GSTIN NO. 313
315GSTIN NO. 314
316GSTIN NO. 315
317GSTIN NO. 316
318GSTIN NO. 317
319GSTIN NO. 318
320GSTIN NO. 319
321GSTIN NO. 320
322GSTIN NO. 321
323GSTIN NO. 322
324GSTIN NO. 323
325GSTIN NO. 324
326GSTIN NO. 325
327GSTIN NO. 326
328GSTIN NO. 327
329GSTIN NO. 328
330GSTIN NO. 329
331GSTIN NO. 330
332GSTIN NO. 331
333GSTIN NO. 332
334GSTIN NO. 333
335GSTIN NO. 334
336GSTIN NO. 335
337GSTIN NO. 336
338GSTIN NO. 337
339GSTIN NO. 338
340GSTIN NO. 339
341GSTIN NO. 340
342GSTIN NO. 341
343GSTIN NO. 342
344GSTIN NO. 343
345GSTIN NO. 344
346GSTIN NO. 345
347GSTIN NO. 346
348GSTIN NO. 347
349GSTIN NO. 348
350GSTIN NO. 349
351GSTIN NO. 350
352GSTIN NO. 351
353GSTIN NO. 352
354GSTIN NO. 353
355GSTIN NO. 354
356GSTIN NO. 355
357GSTIN NO. 356
358GSTIN NO. 357
359GSTIN NO. 358
360GSTIN NO. 359
361GSTIN NO. 360
362GSTIN NO. 361
363GSTIN NO. 362
364GSTIN NO. 363
365GSTIN NO. 364
366GSTIN NO. 365
367GSTIN NO. 366
368GSTIN NO. 367
369GSTIN NO. 368
370GSTIN NO. 369
371GSTIN NO. 370
372GSTIN NO. 371
373GSTIN NO. 372
374GSTIN NO. 373
375GSTIN NO. 374
376GSTIN NO. 375
377GSTIN NO. 376
378GSTIN NO. 377
379GSTIN NO. 378
380GSTIN NO. 379
381GSTIN NO. 380
382GSTIN NO. 381
383GSTIN NO. 382
384GSTIN NO. 383
385GSTIN NO. 384
386GSTIN NO. 385
387GSTIN NO. 386
388GSTIN NO. 387
389GSTIN NO. 388
390GSTIN NO. 389
391GSTIN NO. 390
392GSTIN NO. 391
393GSTIN NO. 392
394GSTIN NO. 393
395GSTIN NO. 394
396GSTIN NO. 395
397GSTIN NO. 396
398GSTIN NO. 397
399GSTIN NO. 398
400GSTIN NO. 399
401GSTIN NO. 400
402GSTIN NO. 401
403GSTIN NO. 402
404GSTIN NO. 403
405GSTIN NO. 404
406GSTIN NO. 405
407GSTIN NO. 406
408GSTIN NO. 407
409GSTIN NO. 408
410GSTIN NO. 409
411GSTIN NO. 410
412GSTIN NO. 411
413GSTIN NO. 412
414GSTIN NO. 413
415GSTIN NO. 414
416GSTIN NO. 415
417GSTIN NO. 416
418GSTIN NO. 417
419GSTIN NO. 418
420GSTIN NO. 419
421GSTIN NO. 420
422GSTIN NO. 421
423GSTIN NO. 422
424GSTIN NO. 423
425GSTIN NO. 424
426GSTIN NO. 425
427GSTIN NO. 426
428GSTIN NO. 427
429GSTIN NO. 428
430GSTIN NO. 429
431GSTIN NO. 430
432GSTIN NO. 431
433GSTIN NO. 432
434GSTIN NO. 433
435GSTIN NO. 434
436GSTIN NO. 435
437GSTIN NO. 436
438GSTIN NO. 437
439GSTIN NO. 438
440GSTIN NO. 439
441GSTIN NO. 440
442GSTIN NO. 441
443GSTIN NO. 442
444GSTIN NO. 443
445GSTIN NO. 444
446GSTIN NO. 445
447GSTIN NO. 446
448GSTIN NO. 447
449GSTIN NO. 448
450GSTIN NO. 449
451GSTIN NO. 450
452GSTIN NO. 451
453GSTIN NO. 452
454GSTIN NO. 453
455GSTIN NO. 454
456GSTIN NO. 455
457GSTIN NO. 456
458GSTIN NO. 457
459GSTIN NO. 458
460GSTIN NO. 459
461GSTIN NO. 460
462GSTIN NO. 461
463GSTIN NO. 462
464GSTIN NO. 463
465GSTIN NO. 464
466GSTIN NO. 465
467GSTIN NO. 466
468GSTIN NO. 467
469GSTIN NO. 468
470GSTIN NO. 469
471GSTIN NO. 470
472GSTIN NO. 471
473GSTIN NO. 472
474GSTIN NO. 473
475GSTIN NO. 474
476GSTIN NO. 475
477GSTIN NO. 476
478GSTIN NO. 477
479GSTIN NO. 478
480GSTIN NO. 479
481GSTIN NO. 480
482GSTIN NO. 481
483GSTIN NO. 482
484GSTIN NO. 483
485GSTIN NO. 484
486GSTIN NO. 485
487GSTIN NO. 486
488GSTIN NO. 487
489GSTIN NO. 488
490GSTIN NO. 489
491GSTIN NO. 490
492GSTIN NO. 491
493GSTIN NO. 492
494GSTIN NO. 493
495GSTIN NO. 494
496GSTIN NO. 495
497GSTIN NO. 496
498GSTIN NO. 497
499GSTIN NO. 498
500GSTIN NO. 499
501GSTIN NO. 500
502GSTIN NO. 501
503GSTIN NO. 502
504GSTIN NO. 503
505GSTIN NO. 504
506GSTIN NO. 505
507GSTIN NO. 506
508GSTIN NO. 507
509GSTIN NO. 508
510GSTIN NO. 509
511GSTIN NO. 510
512GSTIN NO. 511
513GSTIN NO. 512
514GSTIN NO. 513
515GSTIN NO. 514
516GSTIN NO. 515
517GSTIN NO. 516
518GSTIN NO. 517
519GSTIN NO. 518
520GSTIN NO. 519
521GSTIN NO. 520
522GSTIN NO. 521
523GSTIN NO. 522
524GSTIN NO. 523
525GSTIN NO. 524
526GSTIN NO. 525
527GSTIN NO. 526
528GSTIN NO. 527
529GSTIN NO. 528
530GSTIN NO. 529
531GSTIN NO. 530
532GSTIN NO. 531
533GSTIN NO. 532
534GSTIN NO. 533
535GSTIN NO. 534
536GSTIN NO. 535
537GSTIN NO. 536
538GSTIN NO. 537
539GSTIN NO. 538
540GSTIN NO. 539
541GSTIN NO. 540
542GSTIN NO. 541
543GSTIN NO. 542
544GSTIN NO. 543
545GSTIN NO. 544
546GSTIN NO. 545
547GSTIN NO. 546
548GSTIN NO. 547
549GSTIN NO. 548
550GSTIN NO. 549
551GSTIN NO. 550
552GSTIN NO. 551
553GSTIN NO. 552
554GSTIN NO. 553
555GSTIN NO. 554
556GSTIN NO. 555
557GSTIN NO. 556
558GSTIN NO. 557
559GSTIN NO. 558
560GSTIN NO. 559
561GSTIN NO. 560
562GSTIN NO. 561
563GSTIN NO. 562
564GSTIN NO. 563
565GSTIN NO. 564
566GSTIN NO. 565
567GSTIN NO. 566
568GSTIN NO. 567
569GSTIN NO. 568
570GSTIN NO. 569
571GSTIN NO. 570
572GSTIN NO. 571
573GSTIN NO. 572
574GSTIN NO. 573
575GSTIN NO. 574
576GSTIN NO. 575
577GSTIN NO. 576
578GSTIN NO. 577
579GSTIN NO. 578
580GSTIN NO. 579
581GSTIN NO. 580
582GSTIN NO. 581
583GSTIN NO. 582
584GSTIN NO. 583
585GSTIN NO. 584
586GSTIN NO. 585
587GSTIN NO. 586
588GSTIN NO. 587
589GSTIN NO. 588
590GSTIN NO. 589
591GSTIN NO. 590
592GSTIN NO. 591
593GSTIN NO. 592
594GSTIN NO. 593
595GSTIN NO. 594
596GSTIN NO. 595
597GSTIN NO. 596
598GSTIN NO. 597
599GSTIN NO. 598
600GSTIN NO. 599
601GSTIN NO. 600
602
Purchases
Click to expand...
Yes this will give an error.
 
Upvote 0
If the rows are upto GSTIN No.499 it will work without error.
 
Upvote 0
One second. Let me check once more.
 
Upvote 0
It is working. My bad. I was thinking in the opposite direction.
 
Upvote 0
Now I understand this. If there are more than 500 correct GSTIN numbers in column B then it will create an error because on the web you can verify 500 GSTIN numbers only.
 
Upvote 0
You must log in or register to reply here.

Similar threads

RAJESH1960
  • Solved
Need to edit / correct code
Replies
9
Views
336
Alex Blakenburg
A
RAJESH1960
  • Solved
Get data from web multiple times using loop
3 4 5
Replies
43
Views
2K
RAJESH1960
RAJESH1960
Z
  • Question
Center Across Selection Issue in Web App.
Replies
0
Views
140
Z01NK5
Z
RAJESH1960
  • Solved
Need to make a few changes in this code
2 3
Replies
26
Views
810
johnnyL
J
M
  • Question
Clipboard error when copying shape
Replies
4
Views
469
marc81
M

Forum statistics

Threads
1,215,467
Messages
6,124,984
Members
449,201
Latest member
Lunzwe73

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top