recorded macro

I'm trying to take a recorded macro which results in absolute ranges and apply dynamic ranges to the code. In this case, I need to sum a dynamic range and then have the result appear two cells below the last row of the dynamic range. In this example, I would need to sum the totals of A1:A4 and...

Hi, I need some help in below code. I recorded the macro and this code generated. It should save file in same format at the end that part I deleted because it asked for xlsm format so I did to get the code. What I was doing in this code is basically. 1. Filter "Pending" "Mobile" Status in...

Hi, I have data that comes to me the same way everyday but it varies in length. I recorded a macro for 80 sets of data and then put in 50 sets the next day and it showed N/A's or numbers for the last 30 spaces since there was no data in them. How do I tweak the code to use it on an length of...

Hi, I created a recorded macro. What im doing is downloading a file from a database and have to update that file with the old data from prior download and extract the formats and formulas into the new download. My problem is when i did the recorded macro I copied the formula from the...

Hi I'm hoping someone can help me before I set my PC alight and send it hurtling to a fiery doom out one of our office windows. I've recorded a macro in which I unhide certain columns, copy and paste some information then hide those columns again. The problem is that when the macro is...

I had recorded a macro and the given range was ("P2:P3247"), however this number can vary from day to day, higher or lower. If the number is lower then it fills in the #N/A's, and if it goes over then I lose data for the remainder of the macro. I have extended it out to 5000 just to make sure...