| View previous topic :: View next topic |
| Author |
Message |
ArethaBrown
Newbie
Joined: 27 Oct 2011
Posts: 1
Location: Bucharest
|
 Posted: Sat Jan 21, 2012 10:12 pm Post subject: How do you enter information over multiple sheets? |
 |
|
How do you enter information over multiple sheets in OpenOffice calc and different cells automatically?
I know you can do this in seperate sheets in the same cells by holding down the control key and selecting the sheets. But is there a way to automatically do it or write a formula to have what ever I type in in sheet 1 in cell a-1 such as the name "john" to show up on sheet 2 in cell b-3 and sheet 3 cell on c-4? for example? Thanks!
_________________
“It doesn’t matter how slowly you go-so long as you do not stop.”-Confucius |
|
| Back to top |
|
 |
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1851
Location: Sydney, Australia
|
| Posted: Sat Jan 21, 2012 10:24 pm Post subject: |
|
|
If Sheet1.A1 will only ever be empty or text you can use this formula in any other cell in that spreadsheet document...
If Sheet1.A1 could be blank, text or number...
| Code: | | =IF(Sheet1.A1="";"";Sheet1.A1) |
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
|
