Fit info into a no. of places (insert row, copy & paste) easily

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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

Copy/Paste Doesn't Carry Formats 2
VBA - retrieve data on last create named range from previous inserted named range 0
Can a row containing protected & unprotected cells be copied? 8
Excel Unable to insert cut rows into Excel online anymore? 0
Save data from Notebook: copying to the USB stick using Linux and the command line 0
Copy Paste sections of data 12
Copying text with more than one line 1
How to insert lines into a workbook without changing references? 1

Back
Top