Search results

Hello Marc The macro worked, appreciate all your help. Thanks.

Hello I’m looking for a macro I have a spread sheet with column A through K Column I, J, K contains phone numbers Column I is the one which has most of the phone numbers. I’m looking for a macro that will look at column I each cell by cell and if it finds a blank cell then it should go to...

Hello Alan and Narayan Thanks very much, for helping me with this macro. :)

Hello Alan Very nice. So far so good, When i ran the macro it pulled all the phone numbers into one column. Also if the macro can pull the corresponding record information down with it, then when i make calls i will be able to see the phone number and the information attached to each phone...

Hello Alan That worked great. Thanks. One last thing, when i dialed these numbers i have to pick up the number from my dialer program and paste it into excel and do a search on that number in order to find the record, and its just too much manual work. As you can see in the attached excel...

Hello Alan The macro worked great. Thanks very much. !! After i ran the macro i noticed in the phone number i wanted to have 1 in front of them, can you help me with it, and include 1 in front of them. Thanks.

Okay Great, Thanks.

When i download a new sheet every day, the LOCATION of those 2 column LIST PRICE or EXPIRED DATE changes, so they are not fixed in column AJ and AK, but one this is for sure, the column heading appears in Row1. So the marco should search ROW1 for LIST PRICE and EXPIRED DATE and when found in...

Hello Attached is the sample spread sheet. Thanks.

well when i posted on excel forum NO ONE REPLIED. so i search internet and found this web site and posted here, seems like no know how to write this macro either they are incompetent or just looking here is the post status. on excel web site. so if it not a very long lengthy complicated macro...

Hello I have a spread sheet with bunch of column almost 40 or so and some time more, and some where in that spread sheet the following columns are spread out, the heading always appears in row 1, i'm looking for a macro that will the search for following items, example LIST PRICE or EXPIRED...