copy paste rows

Hi, I have been trying to set up a VBA code that helps me move rows with the word Sam in column A to the bottom of the sheet (the number of rows with this word changes everyday). I have managed to set up a code that copies the data but it always pastes it in the same row (i.e. row 540) even if...

Dear Excel Experts, I've been trying the whole day and kinda give up on this. Am trying to do this automatically. Copy header from first worksheet to all other worksheets. But come to no avail. Below are my series of coding I've tried:- Do While i <= Worksheets.Count...

Hi all, I've found things similar and I keep having problems mapping them to my exact situation. I'm trying to create a "summary page". I have a bunch of different sheets, and in those sheets column J is a drop down box. So if column J doesn't equal "approved" and it isn't blank, I want to copy...

I'm trying to copy the entire rows from a spreadsheet called "RAW" to another blank Spreadsheet named "FMX DUIC" The rows that I'm trying to copy are based on the value in the Cell in column "A" (Currently I have three criteria but I may add more in the future). The code appears to have an...

Hi everyone, new to the forums here and failry green working with VBA in Excel (no formal training). I'm trying to do what I think should be fairly simple but after all my searching, I can't find exactly what I need. Here's what I'm working with: - I have data with formulas in row 3 of...