extracting information from a workbook and saving into a seperate workbook.

**jamest6** · 02-21-2014, 07:07 AM

Hi,

Im quite the novice when it comes to formulas in excel but here goes my explanation of my problem.........

ok so i have a workbook blank template for my colleagues to fill in, they fill in this blank template and save it under the serial number of the item they are creating. However a lot of errors exist when they input the serial number inside the workbook where the serial number is a duplicate of a former serial number.

Anyhow i was wondering is there any way when they input the serial number into the worksheet that i could get it to save in a separate workbook and then have conditional formatting to check those serial numbers in the workbook to see if they match??

any help would be great!!

cheers
james

**dgdgdg** · 02-21-2014, 08:35 AM

Upload an example as it is difficult to understand the issue you are having

**jamest6** · 02-21-2014, 08:40 AM

example.xlsx

ok so the attached document would be the document that my colleagues enter the serial number of a part into,

i would then like to take this serial number and place it into a separate excel document and save it sort of as a look up table

then conditionally format the attached excel workbook to turn red if a serial number is entered that is in that list if you understand what i mean.

cheers
james

**dgdgdg** · 02-21-2014, 05:27 PM

Hi James

I am not sure if I am barking up the wrong tree on what you may be trying to achieve.

Anyway I have created a simple macro which you activate by clicking the start button on sheet1

Instead of a separate workbook it is on sheet 2, the code can be amended for a separate workbook.

I have placed comments in the code alt + f11 for VBA editor

sheet2 will contain the serials but list will generate from nothing or you can copy the list into sheet2 column a.

This is only good if its for 1 single user at a time, however you should be able to enable sharing for multiple users.

This will only add the serial numbers to the list if they do not currently exist, if they do exist there will be a message and nothing will be added. try typing the same code in twice

Apologies if I have this wrong.

**jamest6** · 02-25-2014, 03:27 AM

nope dg that code looks great i am absolutely useless with code but your comment helped thanks for that, still having trouble activating a seperate workbook but ill take another look into that, thanks =)