macro

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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.
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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
  14. A

    Repeat Formula until it Returns zero [VBA]

    Hi. Is there a way to paste certain formula in column E until the formula returns a zero value? Column E don't have anything in it. So basically, I want to input a formula in E1, then input same formula in E2... and so forth.. until the formula return a zero value.
  15. D

    Code looping twice

    Hi friends, I am stuck in a VBA problem. actually, the code is printing the value twice in subsequent rows its working fine on my previous excel version 2007 but now I shifted to office 365 and its printing the values twice whenever the cell changes. Attached photo for clarification see timing...
  16. R

    Rename Multiple workbook without opening that.

    Hello Everyone I have some workbook in folder and i want to change their name without opening them. By some function i have picks their old name and added their new name in excel cell. example AA1 - \\ABC\Working File\2020-07-17.xlsx AB 1 - \\ABC\Working File\New_2020-07-17.xlsx and so one...
  17. R

    Create Folder in Path mentioned in Cell

    Hello Everyone I have a code to make new folder in path which is working as well. Sub Button1_Click() MkDir ("\\ABC\ragga\Desktop\Testing\Consolidated File") End Sub but i want that, path should be pick from the cell. Consolidated file would be folder name i want this...
  18. T

    Need Macro Created for pulling info of files inside a folder

    Hey have a workbook called "Office Invoice.xlsx" What i want is to open a folder i have and go through each file and pull data from certain cells and put them in on the Office invoice file. We add 500 or more invoices in an excel sheet on that file for each year, and it auto update when they...
  19. J

    Macro Help

    Hi all, I need help with an excel macro. I have only started to use macros and as a result have a very basic knowledge and understanding. I was wondering is it possible to create a macro that can be reused even when the raw data coming in changes the position of the cell that the macro was...
  20. E

    Macro to apply advanced pivot table filters based on cell value

    Hi Excel Geniuses, I have a pivot table that contains some location data called "Milepost". One column is Start Milepost and the other is End Milepost. I need to be able to be able to filter data that is greater than or equal to the Start Milepost AND less than or equal to the End Milepost...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top