| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting in a specific cell in multiple worksheets
Is there a function or macro that allows me to paste something in a specific
cell (eg: A4) in multiple worksheets in the same workbook? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pasting in a specific cell in multiple worksheets
Probably not, but if all the A4 cells should have the same entry, you can do
this another way. Select all the worksheets into which you want to paste the something specific, and just paste it. Then ungroup the worksheets; they will all have the same cell A4. "J@Y" wrote in message ... Is there a function or macro that allows me to paste something in a specific cell (eg: A4) in multiple worksheets in the same workbook? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pasting in a specific cell in multiple worksheets
So you mean I select all the worksheets using SHIFT select and press CTRL V
on one sheet? I tried that and the other sheets did not have the contents on A4. "Richard O. Neville" wrote: Probably not, but if all the A4 cells should have the same entry, you can do this another way. Select all the worksheets into which you want to paste the something specific, and just paste it. Then ungroup the worksheets; they will all have the same cell A4. "J@Y" wrote in message ... Is there a function or macro that allows me to paste something in a specific cell (eg: A4) in multiple worksheets in the same workbook? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pasting in a specific cell in multiple worksheets
Nevermind, it started working. Thanks
"Richard O. Neville" wrote: Probably not, but if all the A4 cells should have the same entry, you can do this another way. Select all the worksheets into which you want to paste the something specific, and just paste it. Then ungroup the worksheets; they will all have the same cell A4. "J@Y" wrote in message ... Is there a function or macro that allows me to paste something in a specific cell (eg: A4) in multiple worksheets in the same workbook? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retrieving a specific cell from multiple worksheets | Excel Worksheet Functions | |||
| 1 cell average across multiple worksheets | Excel Worksheet Functions | |||
| search multiple sheets for specific date, return data in cell to r | Excel Discussion (Misc queries) | |||
| How can I do a lookup to a specific cell on multiple worksheets? | Excel Worksheet Functions | |||
| How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions | |||
Linear Mode
