macro - loop

  1. D

    Run continuously

    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...
  2. N

    First Time Ever Using A Macro

    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...
  3. D

    Read row one by one

    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...
  4. A

    VBA Code To Consolidate Data from Multiple Workbooks

    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...
  5. T

    Moving data from one tab to another via checkboxes

    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...
  6. C

    Automated Excel Workbook Updating

    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...
  7. J

    VBA to copy and paste based on filter and date

    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...
  8. T

    Macro to search entire worksheet using keyword from another sheet

    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...
  9. J

    Change or create macro from one cell to selection

    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...
  10. A

    Taking Data from one tab, looking up another tab and pasting a row in

    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...
  11. E

    Data allocation looping limited to 31 lines only.

    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 =...
  12. N

    programmatically add commandbutton's code during runtime

    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...
  13. Y

    Move Contents of Multiple Columns Recursively

    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...
  14. S

    How to generate report on rows from multiple worksheets where column has particular text

    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...
  15. B

    Macro Not Working- Help!!!!

    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...
  16. S

    Loop Macros across Worksheets

    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...
  17. M

    VBA to copy data range from multiple sheets to mastersheet - Urgent help required!

    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...
  18. E

    Code Correction Required

    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...
  19. L

    VBA Macro suddenly extremely slow. Need help in how to edit it.

    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...
  20. A

    VBA Macro to copy paste and create and save a new from from data file

    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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top