Hello all!
I have a spreadsheet where I need to research data. I have to copy and paste from various different cells from another application into Excel and it's VERY tedious (and puts me to sleep). So, I'm hoping to adapt another macro so that I can just paste the entire page from the other application (without picking out the pieces that I need) and have the macro weed through it and put the data into new columns, organized properly.
I'm attaching a workbook. Sheet 1 is, of course, what I start out with; Sheet 2 is what I WANT to end up with; Sheet 3 is what the coding below does and, if I remove the piece of code in red, that gives me Sheet 4. I need to be able to get P-T and AA-AB to be filled in where they are blank.
I've been working on this for just about 6 hrs and I'm mad at it now, so I'm hoping to get some assistance. It seems like there should be a way to copy P2:T2 and fill down through P8:T8 and copy AA2:AB2 and fill down through AA8:AB8, etc., down throught the destination columns, but I sure can't find the correct syntax to do it.
I'll REALLY appreciate any help! And if you see a way to do this whole job easier/more efficiently than the coding I have so far, I'm happy to alter the whole dang thing, LOL!
Thank you!
Jenny
Bookmarks