macro

  1. D

    VBA one cell returns date of last time another cell was edited

    Hello everybody, I currently have the following: Where column: I = quantity J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future J = add any number entered from the...
  2. D

    Excel 2016 VBA Unprotect error for single user

    Good Evening, I’m wondering if someone could cast an eye over some VBA code I am using in a workbook. The workbook isn’t marked as shared and is protected, it is stored on a network drive so users can access it. Users all use the same version of Excel 2016 (RemoteApp hosted on a Remote...
  3. D

    Formula in Excel to display email message with CC & email receiver

    Hello everybody, I am currently following this youtube video: (specifically look at around 07:30-08:30) in order to create an email link in my excel file that people can click on, have a pre-determined email message written and then fill out the blanks and send it out. However, while I tried...
  4. S

    Email range as a email to SMS

    Hello, I am looking to create a macro that selects a specific range (2 columns) and emails it to phone numbers (e.g. 5551112222@vtext.com). The range looks something like this: Apples 5% Oranges 4% Bananas 4% Tomatos 3% Other 50% The issue i'm running into is the fact that it needs...
  5. D

    Run-time error "53": File not found

    Hello everybody, I am currently having a problem with one of my files. I have made an order form where people can order goods from. They download my excel sheet and click on a submit macro which sends out the excel sheet in a PDF file through email. This works perfectly fine when I do it...
  6. G

    Auto Data paste in new cell

    Hi , I need a help , I've one sheet name "PDA" . I'm copying cell no . C6 to I6 then I paste that value in cell no C7to I7. Then again I'm Copying cell no C6 to I6 (when gets refresh and new data arrived) and then I'm paste data in cell no C8 TO I7. Then again I'm copying cell no C6 TO I6 and...
  7. R

    *URGENT* Merge Multiple Workbook into One and then combine

    Hello Everyone I have two workbook in one path and both have same headers. I have code to merge both the workbook into one but then i need to combine them into one worksheet. like copy data from one sheet to paste on another sheet last filed row Sub GetSheets() Dim Path as Integer Path =...
  8. D

    Conditionally format cells to red color if cell 4 rows to the left is not blank

    Hello everybody, I currently have the following list: I want to create a formula (probably through conditional formatting i'd imagine), that basically says: If the cell 4 turns to the left of any designated cell (A1) in row E is not = blank, color the cell in row E with a red...
  9. J

    VBA Copy and Paste Data from one workbook to another - specific columns

    Hi, I have a statement converted from pdf to excel. Unfortunately, the column headers above the data that I really need may lie on different rows, for e.g. row 17 or row 18. I have 3 columns I want to copy from the statement: Date (column B), Description (column C) and Amount (column D); then...
  10. J

    Convert PDF to Excel and Copy into existing excel sheet

    Hi, I want to convert a pdf file to excel and be able to transfer the data into another workbook using VBA. Based on research, converting pdf to excel can be done by first converting to Word document and then to excel. But I want to know if the excel conversion can be transferred into an...
  11. T

    Running graph-creating macro through multiple rows

    Hey, I dont and cant use VBA nor any other programming language at all but need this thing for my work, so sorry in advance for my phrasing; I created a macro simply through "record macro" button in excel. The pourpose of it is to create a simple graph out of one row of a table. Now I need...
  12. M

    Need help with macro

    Hello! I am trying to use the below macro to flag an error message when a date range exceeds 7 days. I have used the below which only applies to the first cell in the column. What must I do to apply it to the whole column, I have 350 rows. Just to let you know column K is a calculation of...
  13. K

    Find Synonyms for a word in MS Excel using VBA

    Dear VBA experts, i have set of words in column A, i need a excel VBA macro to get the meaning for each word in column A on corresponding B column. Please help me with a code. Thanks in advance ! Regards, Karthikha.
  14. A

    Extract Data from a Table with Macro/VBA

    Hi All, I Have a table and Macro code below. What I want to do is: -Copy all numbers to a worksheet named "TEST" (Helper worksheet) -Criteria are: 1. If Header of Column is "Total" - End VBA 2. Start with Range(E2) then if value is "-" or if Value of Cells(activerow, 2) = blank then select next...
  15. M

    copying images from one folder and pasting in another based on schedule in excel file

    Hi guys Hope you all well and safe from Covid. while in lockdown im hoping someone can assist me with this query. i had a macro created whereby image product code is listed in Column A, Column B lists the location of that particular image and Column C displays the location of where i want...
  16. R

    Excel VBA Subroutine Problem

    I have a macro that finds the last row in a spreadsheet and then moves down a column 1 row at a time to check if the current cell is empty. If it is, then it copies the value from the cell immediately above and then continues moving down. I have run this macro on the same worksheet on multiple...
  17. R

    VBA Comparing Name on schedule to vacation list

    I'm hoping someone on here can help we with what I'm trying to create in our Excel work schedule. In the Sheet "Availability" it lists all of the employee's in Column B. With the date listed in Row 2. In the Sheet "Assignments" is where we enter each employee's assignment for that day (Date is...
  18. V

    Figures Update - Macro

    Hi, We have a main spreadsheet that lists all bookings made by our team. I am trying to create a separate sheet that shows their figures just for the current month that updates as a new booking is added/removed. I have tried filtering within the macro in the main sheet and also then tried...
  19. R

    Move Excel File based on their file names

    Hello Everyone, I am working on one big project and need your small help in the same. I want to move excel files to folder based on their file names. below is the example - I have a folder path in A1 - B1 have date : 20-07-2020 - C1 have date : 15-07-2020 in path i have four files: 1...
  20. R

    insert all excel files name into excel from folder

    hello everyone i want to insert all excel file into exceel from specific path metioned in A1 target or destination cell would be B1

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top