Query

[Jaiguns63]

Hi, I need an assistance on VBA coding for my scenario. Though i am new to VBA learning, still i need some input from you.

Scenario: I have data from Column "A" to "I" (lets assume 20 rows)and based on that i am doing vlookup in column J Jand i have the data (only one cell - "J1"). Now i want to copy this "J1" formula cell and paste in in J columns until to last row of column I.

The range of number of rows with data is not the same on daily basis as it may increase or decrease. Hence depending on this can you tell me VBA code????

 

[Jaiguns63]

Hi Experts,

Hi, I need an help from you on writing an small macro coding for me.
the logic is as below:

I have close to 80-100 pdf files with different file names in my desktop folder.
all these 80-100 pdf file names are maintained in an excel (column A) and brand name (column B). when i run an macro, it should refer the excel file names and check the same file names is there in pdf copies. if yes, it should move to a folder by creating a new folder name as column B information of excel. Can you write an macro for this?

 

[FormR]

I need an help from you on writing an small macro coding for me.

Hi, you need to start new threads for new questions.