Posts by SUBHASHn

No blank cells

In original file the data is in column B so changed it accordingly as below.

Any way to fix it?

Getting this error in line 15

Cool, Thanks alot... Really appreciate your help

It worked well...To save the input file.xlsx can I add code like Filename.Save????

Let me try this...Thank you for your time

Only one file with a name input file.xlsx

And the workbook path is fixed as " Z:\ input file"

I have changed the code as per column, and the original file I cannot share as it is confidential... That's the reason I shared the sample

Yes the file path is in different folder..

The file path I was able to open but the code is not working for the file which I shared

PFA

And the original file contains the cell values as below

And the original file contains the cell values as below

To this file I added the code I want to open that test xlsx file and do the same

PFA

Which part of the code need to be changed if I want to open a particular file and do the same operation.like the sscreenshot.

Okay...Thanks alot for your help

Can I skip 6-11 lines of the code as it is taking lot of time and the excel I have has 80k rows