| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can cells be copies automatically to Sheet 2 and Sheet 3
I batch informaion, normally using the same information from Sheet 1 on Sheet
2 & 3. I was wondering without cutting and pasting, is it anyway it could automatically be done? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Can cells be copies automatically to Sheet 2 and Sheet 3
One way:
In Sheet2: J5: =Sheet1!A1 In article , Curious wrote: I batch informaion, normally using the same information from Sheet 1 on Sheet 2 & 3. I was wondering without cutting and pasting, is it anyway it could automatically be done? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Can cells be copies automatically to Sheet 2 and Sheet 3
One way is to select all three sheets and enter the data in one . voila!
Another would be a macro to copy/paste or transfer only values, as desired. Another would be a formula in sheet 2 and 3 -- Don Guillett SalesAid Software "Curious" wrote in message ... I batch informaion, normally using the same information from Sheet 1 on Sheet 2 & 3. I was wondering without cutting and pasting, is it anyway it could automatically be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get cells on a sheet to automatically fit data? | Excel Worksheet Functions | |||
| How do I set up an Excel sheet to automatically print 3 copies? | Excel Discussion (Misc queries) | |||
| create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
| How to Creat multiple copies of sheet | Excel Discussion (Misc queries) | |||
| can entered data in sheet 1 be automatically pasted in sheet 2 | Excel Discussion (Misc queries) | |||
Linear Mode
