$$Excel-Macros$$ Find and delete rows containing a certain word

2009-12-15 Thread Amy
Can anyone help me write a macro that will help me find all rows containing the word "coke" and delete all of the rows entirely? I'm having trouble trying to record something like this. In the end about 8,200 rows will be deleted. Thanks! -- ---

$$Excel-Macros$$ Selecting Range for Pivot Table

2009-07-13 Thread amy
Hello - My first ever attempt at posting - anywhere. I hope I'm doing this correctly. How do I set the range (SourceData) when I run pivot table code so that the command will dynamically define the range. I need to run this macro on files with different number of rows (always the same number of

$$Excel-Macros$$ Add Loop to Existing Macro

2009-06-15 Thread Amy
I have the Macro below and I think I need to add a loop to it. I want the Macro to take a worksheet of 206 rows and for it to copy each row and then insert say 3 identical lines between each row that contains the same information from the cells above it. I need to perform a task weekly and so the