| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fit info into a no. of places (insert row, copy & paste) easily
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fit info into a no. of places (insert row, copy & paste) easily
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I COPY & PASTE A SMALL INFO FM AN XL TO THE CELL COMMENT | Excel Worksheet Functions | |||
| Copy and insert cell info macro help | Excel Discussion (Misc queries) | |||
| How to copy/paste info into the protected sheet | Excel Discussion (Misc queries) | |||
| I need to merge lots of info, w/o copy paste? | Excel Worksheet Functions | |||
| How to insert easily the text of a scientific formula | Excel Discussion (Misc queries) | |||
Linear Mode
