recorded

Hi all, I'm trying to develop a absence tracker; I managed to cover most of the requirement apart from one that I need your help with. Workbook contains dates in row 12 and each individual absence is recorded in rows below as 1, 0.5 (day) etc. We are measuring absence on rolling 12 months basic...

I'm wondering if someone could provide some guidance my way on how to set up a range determination for PivotTable filters. In the code below that I recorded, I found that the macro recorded everything that I didn't want to select from the list (basically, everything less than 7). Is there a...

Hi there, I am looking for some help regarding identifying differences between a recorded amount of hours and the recorded duration (Start/end Time). In the following table Duration is calculated using "=B2-A2+(A2>L2). Row 1 would not need highlighting as duration is less than 60 minutes over...

I have a macro to refresh a pivot table on sheet "dashboard" I get a run time error reference is'nt valid the following code is highlighted ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh I then recorded a macro and manually refreshed the data and had no error However when...

I have a recorded macro that basically takes a selected row, cut's it, then moves it to a different sheet and inserts it at line 2, then re-formats the data to just the values and then returns to the original sheet and deletes the now empty line. I have recorded this macro several times but...

I have recorded my first macro on my data. My data is 1000 rows. Everything works fine. When I recorded my macro I pasted my 1000 rows then double clicked on my formulas so that they copied down to calculate the 100 rows. My problem is: Today's data is 1500 rows long and my macro has...

Hello fellow excel guru's, i have just managed to create a macro where once i select the 'button' where i have set the macro up to, there are two data sheets pasted into my workbook from another. The issue i am facing is that the macro works if the other workbook is open, but as soon as i...