macro

  1. S

    Copy/Paste cell if checkbox selected

    I have a spreadsheet with form control checkboxes next to various cells. I would like a formula where if the checkbox is selected, then it copies a specific cell and pastes it into a range on the same sheet (I4:I15). There will be multiple checkboxes checked so I would need it to copy/paste...
  2. K

    Macro error

    Hello everyone I have a problem. I'm trying to run a macro but it doesn't work. When my co-worker runs it, it works perfectly. We both checked the settings in our computers and we have the same enable so I don't know what is the problem I would really appreciate if someone can guide me Best...
  3. W

    Moving Contents Within Cells To Another Place

    Hello folks, Based on the attached photo, at a click of a button, I would like to: 1. Copy the contents of A3 to C3 2. Paste in the next available, free cell. In this case, A12:C12 3. Clear contents of A3:C3 I'm struggling with getting the macro to paste at the bottom most, next available free...
  4. Q

    How to stop InputBox from looping after input?

    Hi there! I am using this macro to sort through a master inventory list and transfer a row if the inputted "Vendor" is found when the InputBox populates. However, after the input, the InputBox keeps popping up and infinitely looping. How do I make it so that once a vendor name is entered, the...
  5. G

    Macro to consolidate multiple worksheets into Master based on cell data?

    Hi all, I'm hoping I can get some advice as I'm not entirely sure where to start... I have a spreadsheet which is a master file of data for multiple "stores" (Store 1, Store 2, Store 3 etc) I use this master to track what stores have particular merchandising "plans" (some stores have the same...
  6. M

    Having trouble with latest date in vba code for a pivot table

    Having trouble with latest date code for pivot table vba code. Trying to streamline our process of entering equipment hours and I started getting into vba since it seems like it's the way to go, I found some code that should do this but I can't get it working in my particular instance. Listed...
  7. S

    VBA to copy block of cells - keeping correct cell reference

    Hi all, Super novice here trying to get something done for my wife and a non-profit she is part of. I hope someone can help save me some time as I have been at this for hours. I have a set of raw data on one page that is organized by row. (a2, a3, a4...) I have a separate page with name tags...
  8. G

    Insert string before delimiter

    Greetings Excel Community, I am attempting to insert or duplicate a string value within a naming convention without having to do input manually. Is there a formula or a macro code that might be able to complete this possibly? Via the example below, I am attempting to duplicate the ID value...
  9. E

    Macro to run anytime a ActiveX checkbox is used (no linked cells)

    Hello All! I have written the code below that does what I want it to do, but it is assigned to 1 ActiveX check box. I would like it to run anytime an ActiveX checkbox is used, but also only effect the one checkbox being activated. Any help or guidance is much appreciated!!! FYI there is over...
  10. S

    Macro to add quotes, commas, transpose and select the transposed rows

    Hi All, I am constantly on a daily basis having to prepare data for SQL in excel so was wondering if there is an automatic way to add quotes, commas, transpose and select the transposed rows which i could simply paste into SQL. Here's what I do: 1. I paste all my data in column B1 onwards 2...
  11. V

    filter data or any other option - don't want to copy formula in all cells

    Hi, we have the data in sheet1 and sheet2 and using index and match formula, its working fine but we don't want to drag and drop formula from C2:C4 and again we have used formula in D2:D4, there is any formula from which we can get desired result so that don't do drop down SHEET1 125024568765...
  12. S

    Open and print a section of word document as pdf

    I have a macro enabled workbook to produce cost estimates for customer proposals. I have built a macro in cost estimate workbook to create a customer specific proposal in word from a word template that uses mail merge fields to pull in the data from various cells in the cost estimate workbook...
  13. C

    Conditional Formatting Macro

    I am trying to apply the following conditional formatting to a macro. It is creating the formulas and applying them to the correct range, but it is only setting the format for the first formula. Any ideas? This is my code: Sub CondishFormatMulti() Dim MyRange As Range Set MyRange =...
  14. V

    Transpose from multiple column

    Hi, we want to transpose some data from multiple column, is there any option to do it Query Table CodeAmountQty123456789101234567891012345678910807808824793812109113165266101112118081131SD-DE-16853808125901132428661651 Result Table...
  15. V

    Split in row and auto insert row as per requirement

    Hi, we have the following sheet where we want to split in row wise instead of column wise, can we do this from macro or any formula, its a large database query sheet...
  16. S

    Macro: Search and then copy the result and paste into Excel

    Hello. Please help me if it is possible to do a macro. I have a list in Column A1-1000 and I need to search one by one from a website and then based on the result, I need to copy the result under the second table and paste it in my Excel file (maybe in another sheet). Here is the example...
  17. L

    VBA/Macro to add extra lines from a value

    Hello Everyone. I have a file which will contain a different amount of rows and values and i want to be able to click a button (macro) which will look at the numeric value in column L and depending on that value it will create and copy the whole row. Data before...
  18. A

    How can I exclude subfolders in a subfolder

    Hello! I am new here and I hope you can help me as I am a noob when in comes to macros. I have a macro that I want to create that can list down all the file name and the file path of each item inside a folder. I also want this macro to list the items inside a subfolder. Note that there is also...
  19. J

    VBA to compare rows in two different sheets, if match highlight cell

    Hello. New to this board. I found some code that compares two worksheets (sheet 2 with sheet 1) to determine if there are any differences in the rows. The code works perfect for highlighting the entire row. If there is a difference in the row on sheet 2, it is highlighted in red. Instead of...
  20. Chris_010101

    Simple VBA Code help

    Hello, My excel is a master document that pulls in data from different excel sheets in different departments, each of which are all updated daily. I need to save the "master" excel once a week into a different excel with all the values pasted. This creates a weekly snapshot of the data as it is...

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
Back
Top