relative

Hey Everyone, I previously posted a request to help me automate play list creation from a filtered list here. In my first post, I asked for way too much help and my second post, I posted way too much code. Never got a reply, so I'm going to keep it simple this time. I need to know how to...

Hey again, I'm writing a macro and I put in an autofilter because I want to delete every line with a "Q" Rank (I assign it a Q given certain requirements) So when I put autofilter I have it just show Q and then I want to delete everything below the autofilter line (where the autofilter boxes...

Here is my dilemma: I am given data that looks like this: I need to make it look like this: This is one of about 25 sheets in one excel file, and I will be receiving about 5 different files a week, so a macro is necessary to save time. I tried to create a macro just by recording, and it was...

Hello, I work with a spreadsheet on a daily basis in order to update daily inventory numbers for my firm. The way one sheet is set up is as follows: September 9 Actual Inventory: X (C5) Amount on GL: Y (D5) Difference: X-Y ( E5) September 8 Actual Inventory: X (G5) Amount on GL: Y (H5)...

I'm a VBA newb, and although I've searched and searched, I can not find an answer to what seems like a simple question. I have added buttons to several cells and clicking that button runs a counter macro. Clicking on the button in cell c5 runs the following macro which I found online: Sub...

Here is my deal: I understand how VLOOKUP works, however the cell from which my VLOOKUP formula is drawing the answer (the 2nd column of the table), contains a formula. OK, so the VLOOKUP brings in the correct formula to the cell designated and everything is fine. However, the formula brought...