You can use a macro to do it, but Id need to know a little more
information... are the numbers in the exact same place in all the tabs, or
are you just copying one line from one tab and pasting it to all the other
tabs... lmk

" wrote:

I have a workbook with about 7 tabs. I need to insert a line with data in a
number of places in each tab. Is there a way I can do that (sort of a find
and replace)? To do it the hard way, I have inserted a line, copy and pasted
the line that I need to insert. It takes a while to do that because I have
to paste the information in about 9 places on each tab.

Can anyone give me some advice?