Lisa_King_3
New Member
- Joined
- Jan 26, 2004
- Messages
- 39
hi people. i'm having some trouble with VB.
I have 5 columns in sheet 1: Date/Age/Sale Type/Total Sales/Week Number
I need a macro code that will search the 5th column: week number for a value e.g. 2. Once it has found that value, it copies the data from the other 4 cells in the row and transfers it to A1 in sheet 2. The column will have more than one entry for each week, so it needs to keep searching the column until all value 2's are found and copy their ascociated data.
I hope you understand me, and can help xxx
I have 5 columns in sheet 1: Date/Age/Sale Type/Total Sales/Week Number
I need a macro code that will search the 5th column: week number for a value e.g. 2. Once it has found that value, it copies the data from the other 4 cells in the row and transfers it to A1 in sheet 2. The column will have more than one entry for each week, so it needs to keep searching the column until all value 2's are found and copy their ascociated data.
I hope you understand me, and can help xxx