macro help

  1. X

    Is it possible to run a vba code for a set amount of time?

    For example i have a code that will select a cell on the startup of the workbook. i want the user to see which cell is currently activated by highlighting it for 5 seconds in a different color. Is that possible? And if yes, how?
  2. T

    VBA How to delete rows in column G that begin with...

    I've tried recording,editing multiple recordings, understanding other forum posts, the kutools vba is useless. The sheet is called "Columns"; column G has a header and the number of rows occupied will vary. There are 19 If the cell begins with "x" delete the rows These keywords will stay the...
  3. T

    Need a macro or formula to number occurrences of a defined string in the cell sequentially Example inside

    In the below example "]Engine Oil: is the defined string. Input <tbody> Quantities: ]Engine Oil:10W-40 oder 10W-50Â SAE]Engine Oil:SHÂ API]Engine Oil:MAÂ JASO]Engine Oil with Filter:4,0Â Litre]Brake fluid:DOT 4Â specification]Transmission Oil:75W/90Â SAE]Cooling system:2,8Â Litre]Fork...
  4. E

    macro to compile what to bring on certain days

    my first sheet is called database. column a is the serial number, column B is the activity name and column C to the end is what items are needed for a certain activity. my second sheet is called schedule. column a is the serial number, column B and c is the dates (beginning and end) column D...
  5. C

    Print to PDF from Data Validation Drop Down

    I am trying to Print to PDF from a data validation list. I have a pay summary sheet that auto fills when i select the employees name from a drop down list in Cell C6. I need to be able to print off each persons pay summary without having to manually select each persons name Currently i have a...
  6. B

    In need of help with my macro code

    I am trying to write a macro that will match a number in the IO# column on one sheet match in the other sheet. Then copy and paste my notes from one sheet to another. I have no idea why its not working. any help would be greatly appreciated. code: Sub Macro3() ' ' Macro3 Macro ' '...
  7. M

    Separating $1 and $2 Coupons by Bar Code

    I'm having a hard time coming up with a macro that will sort this data the way I want. We have farmers market coupon barcodes that will be for $1 and $2 food coupons. The $1 coupons will all have barcodes that fall within this range: 850001-860000. The coupons will always start with HB2016. So...
  8. L

    Need macro to search column A Sheet 1 for a similar match (about 6 common characters in the same order in the cell) in Sheet 2 then cut column B,C,D,E

    I have a bit of a complex problem that i have been having trouble fixing. We currently perform alot of data entry and i would like this macro to avoid doing it manually. We recieve a list from our client and in column A is a list of their clients. I need the macro to verify as close a match as...
  9. M

    Trouble with event changes

    I am new to VBA and have been following many different YouTube videos. I have had great success until it came to event changes. In a specific worksheet I have entered the following: Sub addition() Cells(3, 1) = Cells(2, 1) + Cells(1, 1) End Sub Private Sub commandbutton_click() Call...
  10. J

    Macro Help - Parse Worksheet Name

    I'm Trying to create a macro that will save each worksheet as the tab name instead of saving the file as "Sheet#". What am I missing in the code below? Sub SaveShtsAsBook() Dim Sheet As Worksheet, Sheet$, MyFilePath$, N& MyFilePath$ = ActiveWorkbook.Path &...
  11. M

    Help! In VBA, how do I add in protect sheet options into my coding

    Hi all, Need some help please. The macro I have created currently creates a new sheet from a current one (copies it exactly and then changes a few things in the sheet as per what I have asked it to do). The macro is currently working fine and does what I want it to do, however I've noticed...
  12. D

    Macro to create new workbooks from current workbook data

    I have a table with 7 columns. Cust Id, Customer name, cust part number, cust description, our part number, price, uom. I need to create a workbook for each customer (782 total workbooks/customers) that has columns 3 to 7, each customer has multiple rows for each item(over 16000 rows), but no...
  13. M

    Help creating a Marco that will Populate another Cell on a Separate sheet dependent on a data validation list

    Hi guys, My first post! Wh00! Okay, I'm a little stuck around these VB Macro's. I've done some C# about a year ago (a bit rusty now) but I understand the concepts so hopefully any technical jargon and methods should be understood fine. I've been asked to put together a Quick (and dirty) little...
  14. S

    Need help to create one challenging excel macro

    Hi Guys, Thank you so much for reading my post. I really need your help to create the following excel macro. I want to get some particular data from the website but unable to get it. What i do is 1) Go the website www.ebharatgas.com 2) Click on "Transparency Portal" which is available on...
  15. C

    Macro Help Required for Multiple Column to Single Column Conversion (With Header Info)

    Dear Experts, I intend to re-arrange the data generated by system. I am using Office 2010 Current Format: Mat No Cost1 Cost2 Cost3 A 5 3 2 B 6 9 3 C 7 6 2 To be Format: Mat No A 5...
  16. M

    Protect worksheet and prompt for a password using macro

    Hi all, Can someone help me please. I need 2 macros: 1. Protect the current worksheet only, and prompt me for a password. 2. Protect the whole workbook (so that sheets cannot be rearranged) and prompt me for a password. Thanks :biggrin:
  17. M

    Unhide rows in multiple worksheets using a macro in vba

    Hi all, I am currently using a macro which hides rows with a 'NO' in column A in all worksheets in the workbook. Now I need a macro which will unhide rows in all worksheets, as it is too long unhiding manually. I need it to unhide between rows 16-55. Can anyone help? Thanks :biggrin:
  18. C

    Xl2007 Find Replace VBA Increment Column Letter

    Hi, I am setting up an excel file to use as a database (MSAccess currently not an option) with a data entry sheet and a table sheet. The data entry sheet is set up to use 8 columns per day times 365 days (data is entered in columns B to DHQ). I have set it up like this as it is the currently...
  19. J

    How to search for specific data from several workbooks and import to one sheet.

    <tbody> Run ID Carrier ID % LIVE Cut Time LOADING/DONE Trailer # Bills Cut </tbody> Above is the information that is contained in each work book. I need to create a Macro that will allow me to search up to 7 days of these files. Each day of operation is saved to a new file. I need to be...
  20. J

    Quick Macro Help

    Hey all I need some help. Just discovered macros and need to use one for a big file. I have a set of data like so: <tbody> date time number number </tbody> which has 25 numbers for each date/time. i need to copy and past, then transpose to this format on a separate sheet: <tbody> date...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top