My brother has three separate customer lists by state and would like to keep
them that way but he would like to combine them in one file. I moved all of
the lists to one file and placed each state in its own tab. I now have a
combined tab and can copy and paste them into one without any problems.
However, my brother doesn't know alot about Excel and when he gets a new
customer he wants it added to both the state tab and the combined tab. I was
going to write a macro to copy and paste the data but I don't know the best
way to do this. Any ideas?