Matching data from one sheet to another and pasting data (looping problem)

**caseylooper** · 06-22-2017, 11:42 AM

I am trying to do the following:

Look at column A on the 'Assign Lockers' sheet, which will have a list of locker numbers to be assigned. Column B will have the name of the person assigned to the locker.

When CommanButton3 is clicked, it should match column A on the 'Assign Lockers' sheet with column A on the 'Lockers' sheet, and paste the name form column b on the 'Assign Lockers' sheet in the corresponding column b on the 'Lockers' sheet.

What I have below works for the first locker, but is not continuing on to the rest, and I cannot figure out why.

Please Login or Register  to view this content.

**sintek** · 06-22-2017, 12:54 PM

Ideally.....Upload a sample of your file so that we can see the conditions.....
To attach a file, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.