Identify, copy range and consolidate information

[mblwood]

I have been working with Excel and VBA for 8 months and am having trouble with looking through data, copying rows and consolidating the rows.
I have a file for brush pick-up with two tabs, “week-1” and “pick-up”.
Week-1 has a list of data which is identified with a 1 thru 5 depending on which day of the week brush is picked up on. These numbers (1 thru 5) are random and have gaps.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
My objective is to look through column “E” on sheet “week-1” and find all the rows with a number 1 and copy the range “F” thru “O” from each row to the “pick-up” sheet beginning with “D13”
Than do the same thing for number 2 and paste starting with “D73” and so on.
<o> </o>
I have an example file and two jpegs but do not know how to include them.
<o> </o>
Thank you in advance for all your help.

 

[mblwood]

Thanks for your patience as I continue to learn.
http://www.box.net/shared/d0yjcv6zu6

 

[mblwood]

Thanks for your patience while I learn.
http://www.box.net/shared/d0yjcv6zu6

 

[hiker95]

mblwood,

I opend one of the first workbooks you had posted on Box.Net. And, I saved it under a different naming convention that I use, with all my notes and preliminary macro coding.

The last workbook you posted to Box.Net had mostly protected cells in all worksheets.

After I opened your new workbook, I opend the workbook I was doing my coding in. Guess what happened. The workbook I was doing all my coding in became protected somehow. I have not been able to remove the protection. And, I can not get to the preliminary macro code and my notes.

So, I closed all running programs, and checked for any virus. I re-booted, and I still can not get into the workbook with my notes, etc., so I deleted that working workbook.

I will not be able to assist you with this project any further.


Click on then Post Reply button, the just enter the word BUMP, and click on the Submit Reply button, and someone else will assist you.

 

[mblwood]

v. 3 of file with security removed
http://www.box.net/shared/if00t8ngp2