A little clarification please...

1. When you say "search the workbook", do you mean search on every worksheet
in the workbook except for the last worksheet? Or did you actually mean to
search on a single worksheet? If only a single worksheet, what is that
worksheet's name?

2. What range on the worksheet(s) is to be searched? A single column or row?
Multiple columns or rows? Which column(s) or row(s) are they?

3. The **only** thing you want placed in Column K on the last worksheet is a
number? Nothing else related to the found text is going to be put on that
worksheet... just a column of numbers???

4. What is the worksheet name of your "last page"?

--
Rick (MVP - Excel)


"AwesomeSean" wrote in message
...
Hello,
I am trying to come up some code to search a workbook for numbers and
then put them in a column on the last page but if the number already
exists,
do nothing. I need it to do this everytime I run the macro. Any ideas?

here is an example:

look for "day" if true then i want the number in column j on that page to
go
to the last page in column k, but if the number is already there then do
nothing. if it is not there then the next cell down.

Does this make any sense? I think I confused myself.

Any help is appreciated

Thank you