PDA

View Full Version : Writing to specific row using matching criteria from user form



icsjohn
03-25-2009, 12:47 PM
Hi all.

I have a user form that writes to the first empty row in a worksheet. However, I would like to write the information in the user form to a specific row based on a match between col A and B.

Col A contains the word Test 1 and col B is a date (3/1/09 thru 3/31/09)

Like this:

A B C D E
Test 1 3/1/09
Test 1 3/2/09
Test 1 3/3/09
Test 1 3/4/09
.
.
.
Test 1 3/31/09

Then another section begins:
A B C D E
Test 2 3/1/09
Test 2 3/2/09
Test 2 3/3/09
Test 2 3/4/09
.
.
.
Test 2 3/31/09
Col's C thru I contain the information from the user form ( Col A & B are not written to the sheet).

As an example, I'm trying to find the row based on the match between Test 1 and 3/2/09 and write the rest of the user form data to that row. I can't go to the last row, because there are different sections (about 30 in all, Test 1, Test 2, Test 3, etc).

I've tried everything I could think of to force the info to get written to the correct row, but to no avail. I've checked everywhere on the web, but couldn't find anything that explained how to accomplish this. VLookup, Match, etc. Any help would be appreciated.
Thanks.