Creating a recap of from data in worksheet.

  • Thread starter Thread starter KimberlyC
  • Start date Start date
K

KimberlyC

Hi,

I have codes in column A5:A25 of a template workeheet.
Users enter these codes into this column and they change all the time..

Some codes might be repeated in the cells.

In cells E5:E25, I need to recap the codes that were used...and not
duplicate any codes that were entered.
For example:
the following codes might be entered in A5:A10

1235
2366
2366
1235
2022
2022

I would need the recap list in cells E5:E10 to look like:
1235
2366
1235
2022

This needs to update automatically as users enter codes into the template
file.
I'm not sure if a formla would work best or code.....
Any help is greatly appreciated..
Thanks in advance for your help...
Kimberly
 
A really good way to learn this is to search the archives for
duplicate
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting a formula with code in worksheet added 10
building a list in a col...based on another col 2
manipulate data before saving to table 3
Macro for checking data in a cell against another cell andcopying/pasting data 8
Ongoing Issue - I have tried to clarify so that you understand 7
Compare data, and if different, copy to another worksheet 2
Last Modified By in a cell by user 3
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top