Hi - I am not good at Excel but a bit of a Word guru. I have been asked to automate a worksheet so that when an invoice is paid (see column K) a date is input - what needs to happen is once a date is input into column K, the row would move to a new worksheet. Attached example has those rows highlighted pale orange. I am hoping someone can help. Where I found myself really stuck was the information will get added to as new invoices are generated, and then once paid, will need to move to the bottom of the new sheet. I attach workbook. Attached Files Copy of Register of Letters of Demand.xlsm ..read more

I am using the following to open the print dialog box, and what I would like to do is to disable both the 'Print range' options and the 'Print what' options in the dialog box. Specifically I would like the 'Print range' to be set to 'All' only and the 'Print what' to be set to 'Active sheet(s)' only, which is (currently) what they default to when running the macro. I do however want the user to be able to select the printer and to adjust the properties of the printer. Application.Dialogs(xlDialogPrint).Show Also, Preview selected in the print dialog box shows only the first page of the multi ..read more

Hi Excel fans, Any1 wanna help me out? I keep ending up with a macro thats acting up :( I'm looking for a simple macro that gives me this result: 100-10% = 90 So Cell A1=100 Cell B1= 10 Cell C1 = answer of " =(A1*(1-B1)) (B1 should be in %) This works in a macro but only if the cursor is located in C1 - where the macro is executed. BUT what if i would run this same macro independent of its location ??? (so i would always calculate with the cells left 1 + left 2 from it current position) Looks simple but i can't get it to work properly. Anyone ??? thanks in advance ! Ben ..read more

Hi to all, I need your Help. I created a command button on my excel file and i want to save the active sheet as pdf on desktop when i click on it. Thank you. Attached Files TEST.xlsm‎ (29.1 KB) Download ..read more

I have been trying to lock out rounded bars that I am drawing on a worksheet in VBA ... I simplistically (and wrongly) thought that the ".locked = True" in the code below might but nope. This might be a simple 'not possible' question but ... is there a way I can lock an inserted rectangle in VBA so that the user cannot manually select it (or at least cant drag it about or resize it)? For context, the bars are drawn based on two cells being populated with times with a worksheet event drawing it when both numbers are not blank. There are multiple bars drawn (named after the rows) but they are n ..read more

The attached data is what our Tracking System exports for items that have to be washed for a second time. I have been asked to see whether we can compile a report from this data in a relatively simple way. I want to be able to extract the following data: Accountable Operator Date Raised Time Raised Description (See lines H20 - H28) Description (See line E11) where there is no line similar to Row 19 I imagine it will have something to do with whenever the Log Number changes, or something of that ilk, so was wondering if someone was able to point me in the right direction Attached Files Pac ..read more

I am creating a data collection area on Sheet1 for users to select a drop down value in cell D4 using data validation list. The next cell they enter data on is cell D6 and I have another data validation list using the field values from pivot table filtered on the value they chose in cell D4. I currently have the below code on Sheet1 to automatically change the filter on a "PropN" pivot table on the PivotTables sheet when a value changes in cell D4 on Sheet1. This code works great! The problem I am having is I would also like to create some kind of loop that would allow me to change the filter ..read more

Hi all, :) I'm new to vba and I would like to have vba that is merging all *.png files from folder to pdf. I got them all at location c:\temp. the biggest struggle is page brake since is cutting all images and I need 2 horizontally per pdf page. Can somone help me with it? File size is 977x601. My current code is : "Sub AddPngFilesToNewSheet() Dim path As String Dim ws As Worksheet Dim picTop As Double Dim i As Integer ' Define the path for PNG files path = "C:\temp" ' Change the folder path as needed ' Create a new worksheet Set ws = ThisWorkbook.Worksheets.Add ' Initialize top position ..read more

Hi! I am very new to vba, and have now stumbled upon a problem I can't figure out myself. So I thought it best to get some expert help here! I have 5 macros that are a part of a larger macro. When I run them one at the time they work perfectly, but when calling them all in one macro they don't. The problem arises at the end when the macro is supposed to copy an R-value from a table. It seems to be skipping this step, and then complain that there is nothing to copy. I have tried adding an "Application.Wait" for 10 sec after this step in the code, but it did not help at all. Does anyone know h ..read more

Hi all, I have a sheet that has a vlookup that references a date cell in the same sheet. The table array is on a different sheet. My macro opens the sheet, refreshes the sheet then closes it. I have other vlookups that reference words or numbers and they all work correctly. The date vlookup only works if I manually open the sheet with the table array. Formula =VLOOKUP(@$AF$55:$AF$60,'5.csv'!$A:$E,5,0) Macro Sub example() Workbooks.Open FileName:="W:\AllUsers\Boris J\Test\5.csv" Workbooks.Open FileName:="W:\AllUsers\Boris J\Test\2.csv" Workbooks.Open FileName:="W:\AllUsers\Boris J\Test\4 ..read more