1. X

    VBA: Reflection Desktop

    Hi Good People, Below code opens a session of reflection desktop and extract data from a particular screen. My problem is, I don't want to open another session, instead it should find the active session of reflection workspace then execute the code. However, I am nowhere near from that the...
  2. S

    Export Attachment from outlook to excel cells

    I've an issue to export attachments from outlook to excel cells. The attachment is not the filename, but the file itself. For example, if PDF file, it will extract the PDF file to the cells, not the filename or the details inside of PDF. I know how to save attachment to the folder but not on the...
  3. O

    Help counting text value in pivot table

    Hello, i have a question for a practice interview test which is On the ‘Workings’ sheet use formula and/or pivots to analyse this dataset to identify the percentage of students still retained and graduated at the end of the third year (by course) and the proportion of graduates that received a...
  4. V

    How do I change selected colors of this vba automatically?

    Hello everybody, I'm having trouble changing my Macro's colors when it automatically selects fields. Does anyone have any idea how I can solve this problem? Thanks for listening. This code VBA i'm use: Sub RemoveLeadingSpace() Dim Rng, WorkRng As Range On Error Resume Next xTitleId =...
  5. A

    Help applying Macro to the whole Column

    Instead of applying it into on cell what can i change to apply it to the whole column? Sub Return_nth_character() 'declare variables Dim ws As Worksheet Set ws = Worksheets("sheet4") 'extract the 3rd character from a string ws.Range("b1").EntireRow.Select = Mid(ws.Range("A1"), 3, 16) End Sub
  6. P

    VBA - Using cell value as a part of a range and dragging and dropping.

    Hi there, I am a bit of a newb when it comes to VBA. I've tried many different options and nothing worked. I cannot think of a way to get this to work. Would appreciate any help: Aim: I wish to paste a sum formula in Sheet1, Column R starting in Row 2. which sums the previous 4 columns (simple...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. K

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

  12. 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
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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