1. D

    Copy Duplicate and Remove/Update Original Text

    For each row where there is text in column E, copy the entire row and insert it below the original row. Then remove the text in column E from the row that was copied.
  2. novabond

    VBA to add/change loaded ´Picture´ of an Image within a UserForm

    Hello. I need to create a UserForm template, which includes 5 images, these images will eventually have pdf pictures loaded. I will then need to creating about 30+ UserForms from this template, i can do this manually by importing the template and renaming it, and I know i can then go into each...
  3. R

    Letter Log Reminder MsgBox not updating

    Hi! new issue came up, previous issue is resolved. However, the Msgbox only display the current data in the cell. if new data is entered in the worksheet, it will still show the previous msg. like for example as shown below. The msgbox will show that reminds your that the letter number 00001...
  4. B

    How to overwrite the currently used add-in with a newer version of itself

    Hi everyone, I got most of my question in place, the add-in checks if there is a newer version and will get that newer version from the server if needed. The only thing I am struggling now is to replace the older add-in with the newer add-in while the names of both add-ins stay the same. So at...
  5. M

    File not working after update

    Hi guys, I prepared a small program that all my staff has been using for years, but since the last update of MS Excel, one by one, they are not able to access the file anymore. The message we get is "Excel Couldn't start last time safe mode could help you troubleshoot the problem ...." Both...
  6. Chris_010101

    Excel Data>Sort Issue

    Hello Wondering if an Excel expert can help. I'm wondering if this might be due to an update but i'm not entirely sure. I have a workbook at work which is used to track absence. There is a master data sheet which is refreshed with a system report every day, so on the absence sheet, all the...
  7. H

    VBA UserForm Search/Update Help

    I'm in the process of making a training tracker for multiple office sections. I was able to create a data entry form that will send an individual's information to the sheet for their respective section. However, the only solution I could think of to easily update old information without making a...
  8. F

    Macro not updated

    I noticed that if code is changed slightly, when run in Excel the macro does not run as per updated code. Example is for message box. If text is changed, it won't update in Excel a lot of the time. Sometimes it does though. Is there a setting somewhere to account for this? MsgBox "– This...
  9. E

    VBA comment cells according to its value, based on conditions

    Hi guys, this is my first time posting on the forum to seek for advises... I learned VBA all from google plus record macro I am facing a problem which for every month, I have to update an excel based on another excel, and there r really a lot of rows thus consuming a lot of time on this task...
  10. R

    Excel - Update ActiveX OptionButton automatically after value change in cell

    Hi all, I have countless option buttons in a sheet that are always grouped in pairs of two. The option buttons simply pass a value multiplied by the factor from A1 to another cell. Everything works like this... However, when I change the factor in A1, the corresponding value in E231 is not...
  11. M

    VBA to update SQL table

    Hi All I am new to Excel /VBA and have been asked to create a excel workbook that takes data from a SQL table and the user then updates the spreadsheet and then clicks a button to update the table. I seem to be unable to get the update to work and to me its a very simple task! (Or Should be)...
  12. J


    Hello there, whats the best wAy to do this. For example i have a list of 4000 students. The details include I gathered from them where name, email address, courses and their certificate numbers) Is it possible to pull their data using vlookup, Then from the retrieve infos. (Name, email...
  13. C

    User form not update correctly

    I almost done with my userform and when i try to update the first row, it doesn't update correctly instead it will use the data 1st row (No8) and update it in the 11th row (No18). Refer image for references. But when i try to update the other row, it works perfectly, only the 1st row is the...
  14. S

    Update Values of Cells in a worksheet based on Cell values from another worksheet?

    I have two worksheets named "Sheet1" and "Template" I want a few cells (Rate column in a table) to update their values based on the values of a column in Sheet1 (Company Name column) For instance when I select SAGT company from the dropdown menu, I want the Rates in the Template worksheet change...
  15. S

    Userforms automation

    Hi, Hopefully someone on here is able to help, i am not familiar with VBA . i have a leave spreadsheet with 12 tabs for that calculates staff leave, their name in column B and the date in row 2. This workbook is read only for staff and only editable for managers. what i would ideally like is a...
  16. P

    How to make a graph that change according to current date ?

    I would like to create a simple graph that changes according to the current date. So I have two values that are added in a "Total" cell, lets say for example : B4 = 75 and B5 = 50, so the the "Total" cell would be 125. And the graph I want would show the time evolution of this "Total" value, but...
  17. G

    VBA Error 91: Object variable or With block variable not set

    Hi I have been trying to search for a solution for days to no avail. Basically below code should take a specific value (C2) from ThisWorkbook and find if it exists in Sample Db (Column D), if it doesn't exist, it will populate a range of data (Column A to AI) from ThisWorkbook to Sample Db, if...
  18. L

    VBA to update one sheet from data stored in another workbook

    Hello there! How are you? I hope you can help me. I'm new in VBA and I have an issue I can't resolve. I'll try to explain what I need. I have Workbook A and Workbook B. Data in Workbook A is updated by clicking a button. It takes information from another Workbook B that is generated by an...
  19. T

    Update cells in a table using the text in column A as the reference to find the correct row

    Hi everyone, I have a worksheet called DATA TABLE which has some 30+ columns. Located in column A is the specific site name. I have another worksheet called DATA AMEND which I am able to populate specific cells with information from DATA TABLE. I wish to then alter any of the cells in DATA...
  20. J

    Updating existing records in closed workbook VBA from current open workbook

    Hello, Any help appreciated. I tried finding an existing thread on it but could not find one close enough. Long story short, I have two excel files. One is called "Item Impact and Cause" and stores a list of 4 columns which are (1) Item Number, (2) Root Cause, (3) Recovery Week, and (4)...

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