Recent content by gmoorthy

Figured that out :D in the code determines the columns.

I changed the int no Val to string and it worked. If I have more columns what I need to do copy them ? Thanks a lot Andy and Skip

Tried changing to text still the same issue

I am doing any calculation just have to copy the data

I have zero experience in VB

Int no Val = 0 Range a and intR = 45678 This is the first instance in the spreadsheet where numbers are repeated

Getting run time error 13 type mismatch

I am getting a mismatch error IntNoVal = Range (“A” & intR).Value

Yes that is correct Andy

Skip I tried what you had suggested earlier. The issue is for example 4567 gets repeated 3 times so I have to keep dragging the formula across which is a manual process. Is there a way to sutomate this in such a away that it looks for the number of repeats takes the data and copies it acrosd

I have a huge excel spreadsheet Number description code date 1234 Test1 A 12/31/1998 1234 Test2 B 04/13/2020 7890 Test3 C 05/06/1999 4567 Test4 D 01/03/1999 4567 Test5 E 09/03/2020 4567 Test6 F 06/07/2020 What I want is that if...

I forgot to mention one thing the number of rows is large like 1000 + rows hence wanted a macro

Hi skip - thanks why I am not able to see the macro or formula that you suggested?

I have an excel spreadsheet as follows 123456 abc def 123456. Xyz Mano 7890 Tyu iOS 7890. Min opu 7890 Ire xyz 6789. Abc 5678. Mano So i need a script which will do the following Should check the first column and if the numbers are repeated the remaining two columns should be...

I am new to autosys and I have multiple files comming in for example File1 File 2 File3 I want a file watcher which will watch for these files one by one and then call another job. Can I pass the file names to the other job one by one as that will be used as a variable. This is running on windows