macro - loop

Hello everyone i have simple vba code to find a word in the worksheet but i have a small issue, when i find the word the cursor moves to the word but the small window where i type the text disappears , i want to run the program continuously until i press the cancel button and below is my code...

Hi everyone - hoping someone can teach me something about Macro's today! I have a filtered worksheet where I need to copy, paste, make the cells below it equal what I just pasted, and then drag down onto another tab. After that loop, I need to go back to the original tab, go down one filtered...

hello everyone i have created a vba code to send email via outlook now i have to do one thing it is to read the first row and next and next , for example in A2 ,A3....... so on there are list of email recipient to be added to the field (TO of Outlook) and B2,B3... C1,C2.... so on there are text...

Hi All, Here I go again requesting for help. :( So I have multiple workbook, which will be the dump file of the userform I made. basically what it do is track activity of each employee. This workbook called TALTracker has in itself the userform. when you open the file, the userform pops out...

I am extremely new to VBA, so please bear with me. I have searched the Excel forum but didn't see another question like mine (unless I'm not searching the correct terms). I have an Excel 2013 workbook with multiple tabs and I need to move data from the "TSA" tab to the "DRT" tab if the...

Hi all, Please could someone assist with a project that I am starting? What I would like to do is create a program that will open (one at a time) all workbooks in a specific directory. Once open I need it to open and then close a number of other workbooks from another directory. The purpose of...

Appreciate anyone's help creating the VBA code to execute a copy and paste function base upon certain criteria being selected. I think it needs to be a VBA script because I have a macro to clear the data in the New PO's tab once an "order" is written and the information is copied to the PO's...

Hi all, I really new to macros and I'd like to ask for assistance in using macro in Excel. I'l like to be able to search all the columns of a worksheet using keywords from a column from another sheet. If it gets a hit from the list it would move the whole row to a new worksheet so that...

I recorded a macro that will split what exist as one row into 8 rows for the last columns J:Q My logic was to insert 7 rows above a selected cell (which exist below the cell that will be merged) and then merge the rows with the original existing row for columns A:I This will give me one cell...

Hi, I ned to keep a record of stock sold each week in a sportstoreI have two tabs. One called "Weekly Update" and the other called "All Stock". All Columns are named and formatted the exact same on both tabs. I need to do a Weekly update of stock sold on the first tab. This has 7 Columns and...

I'm having a problem with my code that allocates the user input data. The looping works fine but it is limited to 31 lines only. Here's the code: Sub HYD_HYDMNL_TIX() Dim MNLCounter As Double, HYDCounter As Double, MNL As Double, HYD As Double Dim nextrow As Double MNL =...

Hi everybody, Briefly, What i'm trying to do is a program that creates a userform for each customer I have in a database with all the products they ordered, the details of them and a commandbutton that will work as a check. The userform helps me enlisting the orders. As every customer order...

Hello everyone, My problem looks simple on paper, but I have no idea how to get a macro to do what I want it to do. Right now, I have it to the point where it will move the entire contents of a single row into column A, but I need it to move the contents of three columns, D, E, and F, row by...

HELP!! I've been struggling for a few days with this issue now and although i've come across a few different examples which i think sound similar to what i need my to worksheet to do, given that i'm pretty much a complete novice at VBA, i cant work out how to adapt the examples i've found to...

Hello, I am trying to write a macro that will pull a selection from a drop down, update the information, and print. However, it seems that its not updating the information. It also looks like it zooms by a name here and there. Any help is appreciated! The code is below. Sub...

Firstly, thank your to everyone who posts on this site! I have looked through multiple forums, attempted to follow the advice, all to no avail. So here's my simple problem: I want to run a macro that repeats the same very simple tasks (some insert columns, some formulas) on all worksheets in a...

Hi, I've been reading numerous posts, watching multiple youtube videos, and wildly searching the internet for several days now trying to figure out how to create a VBA/macro to suit my needs, but am still stuck scratching my head, so hopefully someone here can help me! :confused: I have a...

Hello, the macro below autofills cells in column with the name above if the cell is blank. The code works well but doesnt stop with column A. for some reason it goes into Column B. Can anyone correct the code please Sub Autofill() ActiveSheet.Columns("A:A").Select...

I have this bit of code that Deletes all the unnecessary rows from my data sheet. On my other workbooks that use this nearly identical code, it runs in seconds.. Sometimes 5-10 seconds if there are a few calculations/formulas. I got tasked to do the same thing for a large workbook that has a...

Hi all: I need help on the following: Scenario: I have a master database of information in Excel Called Data. It has a lot of fields. I have a form that I need to automatically filled with each row data from the master and then a save the form with a specific style (AgencyName_SiteAddress in a...