macro code for adding a cell in left of original cell?

**gkeith** · 07-28-2010, 02:27 PM

Is there any macro code for automatically adding a cell with ID number on the left next to name by following the list on ID sheet. Look at my attached sample for more understanding. I need a way to assign each person's ID next to their name matching the listed on ID sheet with ID and name on it so I can develop a VBA macro to do what I need.

Thanks!

**blane245** · 07-28-2010, 03:53 PM

I you flipped the two columns on the ID sheet (name then ID), you could use the vlookup function to find the ID for each name.

**gkeith** · 07-29-2010, 12:45 PM

Originally Posted by blane245

I you flipped the two columns on the ID sheet (name then ID), you could use the vlookup function to find the ID for each name.

Can you explain step to step how to do this? I tried vlookup and I do not really understand how it works. Thanks.

**jaslake** · 07-28-2010, 03:55 PM

Hi gkeith

Do you want this done on both sheet1 and sheet2? Or are the two sheets merely two different examples? If you want it done on both sheets, is there a reason data starts on line 3 in sheet 1 and on line 2 in sheet 2?

John

**gkeith** · 07-29-2010, 12:37 PM

Yes, I want it to be done on both sheet 1 and 2 using the listed ID number for each person. Is there any way for this? Thanks.

**jaslake** · 07-29-2010, 12:40 PM

Hi gkeith

Yes, there is a way for this to be done. What about this question

is there a reason data starts on line 3 in sheet 1 and on line 2 in sheet 2?

Is that the way the data exists in your actual worksheets? Just curious.

John

**gkeith** · 07-29-2010, 12:47 PM

Originally Posted by jaslake

Hi gkeith

Yes, there is a way for this to be done. What about this question

Is that the way the data exists in your actual worksheets? Just curious.

John

It is employee's ID listed on third sheet. I want to add ID next to name on all 28 sheets without manually IDing them each. That would be forever with 100 employees on the actual excel worksheet. Thanks.

**jaslake** · 07-29-2010, 02:42 PM

Hi gkeith

You haven't answered my question.

You have three worksheets. In sheet 1, the data starts in row 3. In sheet 2, the data starts in row 2. I'm not concerned with where the data starts in ID worksheet.

You indicate you have 28 sheets in which to add the ID. Does the data start in the same row in all 28 sheets or does it vary from sheet to sheet?

If it varies from sheet to sheet, I need to be able to "find" a starting point. For example, one could "look for" the header "Name" and hopefully assume that the names start immediately below this header.

Let me know what I'm dealing with.

John