help - macros

  1. Jyggalag

    Iferror(Index&Match&Match) formula

    Hi all! I currently have a large worksheet that is similar to this: With the master data looking like this: I want to create a sort of IFERROR(IF(INDEX=0, ,MATCH and MATCH formula (with an iferror that returns "" (blank) if there's an error)) for every column with [] such as [DATE]. So...
  2. K

    Can anyone tell me why my file isn´t save with this code?

    Since I added the time format the code stopped working, is there any way to include the time in the file name? Code: Sub SaveAsPDF() Dim FilePath As String Select Case MachineName Case "A4", "A8.1", "A8.2", "A8.3", "A12.1", "A12.2", "A12.3", "A20.1", "A20.2" FilePath...
  3. K

    Convert file to pdf regardless of user

    I tried to create a procedure whose objective is to convert the excel spreadsheet to pdf and save it in the folder "D:\Users\(UserName)\Documents\Project\(MachineName)", this program will be used by several users on different computers , how can I make the PDF be saved in the documents...
  4. K

    Error trying to select sheet with public variable

    I am trying to make a code that makes the program write data in a specific excel spreadsheet according to the value of the variable "MachineName" declared as public What happens is that the program does not allow me to do it because an error is detected on line 96 The error: The code...
  5. K

    Print Forms with data

    I am in an internship in a company, I was offered a job in VBA that I am not able to do, the project's goal is to take a print of all forms of the application and export them to PDF with the data that I was inserting throughout the process and insert those forms in a folder whose name would be...
  6. P

    HELP!! cant figure this out (6 hours still going)

    ok to start off with ,, thank for taking the time here to read this ive litterally been learning vla for 24-48 hours and im stuck with a few things i wondering if i could pick your brains to help soo.. ive attached a spreadsheet where im wanting to add a new line after pasting to my database...
  7. T

    Macro sends all rows to other sheet instead of just the one which is being checked

    Greetings everyone, i would like to start out by saying that I have never used VBA and macros until today. Im trying to have a VBA which, when a cell value is changed, copies the entire row to another sheet. The code i am using now, however, all the rows to the next sheet. It was originally a...
  8. J

    Changing a Sumifs to a Sumproduct

    Hi, could someone please help me convert the sumifs formula in VBA, to a sumproducts please? Thank you. ActiveCell.FormulaR1C1 = _ "=SUMIFS('Closing Stock.xlsx'!C3,'Closing Stock.xlsx'!C1,RC[-4])"
  9. M

    Need Help Archiving Live Updates

    Hello members, As a lot of new members such as myself, I am quite green in my macros abilities. To cut to the chase... I have linked some live updates from the web in my excel spreadsheet. However, I would like to archive the data every 15 minutes and list it in each subsequent column. The...
  10. M

    VBA Knowledge Required - Automated Sheets Populated Into Templates

    Hi All, I am learning how excel more and more as my job requires me to and try to use it in my personal life where possible. I have created a budgeting workbook and would like to be able to click a button that will extract all the data in the "master calculator (null)" sheet and place it into...
  11. T

    I need help finding a SQ FT Formula

    Is there anyone out there that has found a basic SQ FT calculating formula, Ive read into some forums and I've came across this formula, =LEFT(D19,FIND("'",D19)-1)*SUBSTITUTE(RIGHT(D19,LEN(D19)-FIND("x ",D19)-1),"'","") , Im currently having to go into the formula and changing the cell It will...
  12. S

    Changing Window Within Workbook

    Within a Workbook, I have a window (Sheet2) that needs to be active for entering raw data and a window (Sheet1) that will be up on a monitor, showing live, manipulated data. In order to keep the current line item on the screen I have it run Application.Goto Target.EntireRow on Sheet1, which...
  13. 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...
  14. T

    Macro which prints my entire workbook (ie all 4 pages together)

    Hi All :) I'm in need of a macro which prints my entire workbook (that is all 4 pages together). I tried using the one below but it seems to print the pages separately .... any help on this would be greatly appreciated Sub PrintAll() Dim sh As Worksheet Dim wb As Workbook Set wb...
  15. A

    Personal Schedule and Summary Log

    I have been working on this personal schedule to plan out some technicians daily work plan for the next two weeks. I am having trouble after inputting some data and sorting it in chronological order by dates and to keep the dates matching with the tasks, equipment, assets, location, and notes...
  16. N

    VBA Code

    Hi All, I have 58 workbooks that I need to be put into one table on a separate workbook. All the workbooks have two sections i need to copy: A11:Y24/25 and A28:Y41/42 As they are all have the same headers, I would like to put them all into one table automatically Could any one help me...
  17. M

    "run-time error '-2147417848 (80010108)" - Selection.Insert Shift:=xlDown - Please Help!

    I have created a template for my work and the below Macro sometimes works, but sometimes crashes with the code "run-time error '-2147417848 (80010108)" When I go to debug, the highlighted section is Selection.Insert Shift:=xlDown - I cannot see an issue with this to be honest so any help would...
  18. R

    Need some help with VBA-Macro

    Hello, In the past I created a Recording Macro that will clear the screen when I use the clear button. I am making a new copy with a different version. I have a message box as well... But I am trying to copy and paste and change it to work on larger file... Is there an easier way or to do...
  19. P

    Macro to save copies of 2 sheets with current with current filter and attached to email

    Hi, I am having trouble with a macro to export two sheets and attached to an email. I have two tabs that I need to attach to an email to number of email address' (addresses' can be in cells A1,A2,A3 etc.). I can have the tab names to attach also in cells if needs be. Ideally I would the sheets...
  20. C

    Referencing Dim in VLOOKUP

    Hate to bump, but I'm stuck..... I posted Friday, but with 56 views, I'm the only post without a reply through Sunday, so I'll try to parse my inquiry. VLOOKUP Macro Workbook Reference Variable Range("J2").FormulaR1C1 = _ "=IFNA(VLOOKUP(RC[-5],[" & wkb3 & "]!C5:C9,5,0),"""")"...

Watch MrExcel Video

This Week's Hot Topics

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
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 "".
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