#vba #macro

I am working on a utility and almost completed it.. With the utility I am generating Excel/CSV file with dummy data for my application. On the file which will be generated, I have Product code(ex: CIDR, HQTC) in column "A" , then in "B" I have dept Id, in "C" I have positions. So if CIDR found...

I have a huge list of companies of which I need to find their website link and save in excel. Is there a way to automate the same using excel VBA?

I am trying to figure how to create a csv file with the attributes below for an EFT file. I think using a macro would work. Header Record Field # Data Element Start Length Format Description Pos. 1 Record Type 1 1 X(1) “1” 2 Date 2 8 X(8) System Date; MMDDCCYY 3 Time 10 4 X(4) HHMM 4...

Hi Gurus, I have a requirement where I need to add a macros button to execute a VBA code that will read the string value from a "cell" that contains a "data validation list" with three options ( No Revision, Revision 1, Revision 2) and based on the option selected for that cell from the...

Hello, I need some help to complete a macro. I have been googling around to see if I could figure it out myself but with no success. In Sheet1 I have data that contains a list of accounts and the amounts on these accounts. In Sheet1 in Column C, Cell C11 is the first line, "101300 Issued Share...

Hi All, This is going to be my first thread. Need some help in VBA coding. A summary worksheet which would print all the worksheet names and counts of all the used rows(After row 7) of the worksheets. I also want to exclude the worksheets like table of contents. example: WorkBook with...

Hi, I'm new to Macros... I need of code which does Autofill in VBA for dynamically columns. Columns will change which needed to be get from last column (END function) and need to do autofill function based on the rows in particular column. Since Vlookup is used to build the formula. Thanks...

Hi there i seem to be having a problem with my "master copy template" i have an online store selling computer products. i have a list of suppliers that i work with. what i had created for me by an excel master that i just cant seem to track down is this amazing template which contains all the...