1. K

    VBA deletes row and it causes the lower rows to shift up

    this code works great and deletes empty rows and shifts things up sub test() with range("L12:L28") for i=.rows.count to 1 step -1 if isempty(.cells(i,1)) then .rows(i).delete shift:=xlup next end with end sub But the problem is that it also shifts anything below the L28 up and it ruins the...
  2. D

    Copy a value x from one workbook and paste it as yes/no if it is x in another workbook

    Using VBA macro, Is there a way to copy the value in a cell from one workbook that has, ex, value is "X" in cell A2 workbook1 sheet 1 and paste that value into another workbook, but the pasted value is a Yes/No in cell A2 in workbook2 sheet1 if that cell is the value X? Example shown below...
  3. D

    Middle man workbook to Copy paste values from one workbook to another

    Hello, I was wondering if there is a way to have three workbooks. Workbook1 has multiple sheets, example sheet1, sheet2, ect, with tables with cells containing questions and then the cell next to it where values can be typed into. Workbook3 has the a similar format but the cells that need...
  4. A

    How to populate cell contents based on ActiveX checkbox?

    Hi all, how would I populate a specific cell when a checkbox is checked? I tried the code below, but it doesnt change the cell value automatically. Any help would be appreciated. Private Sub CommandButton9_Click() If CheckBox1.Value = True Then Range("A109").Value = "ZJ2" ElseIf...
  5. K

    How to match same invoce no. & get data "FILE -1" TO "FILE -2" ...

  6. T

    VBA to make alot of copies of excel file

    Need help with a vba to make a lot of copies of a excel file i have. I have looked around and couldn't find anything really. Any help would be greatly appreciated
  7. O

    Date look-up and dynamic fill numbers.

    My workbook contains an 'inputs tab' where i will have 3 inputs: "date", "amount" and "number of months." In my 'output tab' i have row 1 filled with all the month end dates. I.e Jan 31, 2020, Feb 28, 2020....etc I want to have a dynamic formula in row 2 that will match the "date" from...
  8. G

    Excluding entire rows from macro based on one column

    So I have been beating my head against this for a couple of days now. If column R is blank, exclude or ignore that entire record from the code. The problem is, I can get it to work.... if I permentantly delete that row from the sheet. The entire code is very very long so I will only include the...
  9. P

    Preventing copy/move sheet INTO main workbook from outside workbook

    I'm using this Workbook's SaveSheet event to prevent users from adding a new sheet from within my main workbook file. OK, that's half the goal. But that event isn't triggered if user tries to copy/move a sheet from another WB into my main file. I've started looking at a workbook lock/protect...
  10. N

    Macro SUM values

    Check in Sheet 1 the sum of the field “Long” is equal “Long” in Sheet 2 for the same “code” where “Ap” is “0”. If this is not correct put in sheet 2 in column “Sum” the value “Not correct”. Sheet 1 <tbody> Code Long Ap 15-15 100 0 16-16 50 1 15-15 100 0 14-14 50 0...
  11. A

    Removing Duplicates In Excel Column.

    Hi, Everyone! I have column A, In which every cell has words including spaces in between. Every cell has leading and trailing spaces as well. I have denoted words with english alphabets A, B, C, D, E, F and G. I want to perform an operation on column A such that the duplicate words are removed...
  12. S

    Saving a file as an Excel file while looping in VBA

    I have written some code that uses the copy to new sheet function in excel a very format heavy tab. I then have written some code to save said tab and some other code to update some values in the original sheet and alter the country loop through it saving the file each time. Each bit of the...
  13. C

    Excel many to many

    How can I in Excel, resolve this question about this table: Invoice Number | Item | Product | Value 1001 | 1 | potatoes | 100 1001 | 2 | tomatoes | 150 1002 | 1 | potatoes | 100 1003 | 1 | water | 50 1004...
  14. S

    Add data from table to buttom of another table

    I have a sheet "Data" with an empty table "Table1" I need a macro that retrieves everything that is in the table, it can be from one to several rows, and inserts it at the bottom of another table "Table2" in the sheet "LockedData " and then converts "Table1" so it's an empty one row table again...
  15. P

    I need to combine two pivot tables into one. both are in same worksheet.

    I need to combine two pivot tables into one. both are in same worksheet. Any help?? Thank:confused::confused::confused::confused: You
  16. A

    stuck at vlookup function!!!!

    Sub lkup() Dim rng As String rng = Range("A1", Range("A1").End(xlToRight).End(xlDown)).Select Dim count As Integer count = Application.WorksheetFunction.Match("City", Sheets("carrierresponse_list").Rows(1), 0) MsgBox count Range("B2") = WorksheetFunction.VLookup(Range("A2").Value...
  17. M

    Excel ListBox overlap options

    In Excel, if the text in an column is longer than the width of the column and there is no text to the cell to the right, it will overlap into that cell on the display. Is there an option for a ListBox to work the same way. I am displaying an indented structure and intentionally want the column...
  18. R

    Simple Automating Mailmerge using Excel button

    Hi everyone. I have a spreadsheet that has a name, address, postal code and some figures that I need to put into a standard letter. It is just one record i.e. one person, and one set of prices that go into the letter (which is a quote). I'll call the spreadsheet "Costs" and the word document...
  19. D

    Apply different colour for the text inside the chart

    Hi, I'm unable to give different colour for the text inside the chart. When i tried its getting changed for all the text present inside the chart. The scenario here is my chart has 2 bars one is named "YES" and other one is "NO". I want the yes to be in colour Red and no to be in colour Green...
  20. T

    Conditional Formatting HTML Table in VBA - Excel to Outlook

    Hello! I have some VBA that generates an email that includes an HTML table, into which some values (defined as integer variables in the VBA) are put. I was wondering if there is a way to format the numbers to appear as (#) when they are negative. Here is the code as it is parsed into the HTML...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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