Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index

I've read about doing stuff sorta like what I need to do now.  But I said to
myself that's too complicated for now, I come back to this when I need it.

Right I can't even come up with the right terminology to use in an effective
google search.

The first spreadsheet will function as a data entry form,

Sheet1 is to be protected and is a template for all data entry
Column A has names of fields
Column B is reserved for entry of the values
Column C is notes for the person doing the entry

When the users add data, they:

Select Sheet1 (tab at the bottom),
Select All (Ctrl+A),
Copy (Ctrl+C),
Create new Sheet (Green-Plus tab on bottom)
Paste (Ctrl+V)
Fill in Column B, Columns A and C should be protected

I need a second spread sheet for the folks doing the analysis
it refers to the spread sheet used for data entry
Column A is Column A from Sheet1
Column B is Column B from Sheet2
Column C is Column B from Sheet3
Column D is Column B from Sheet4
Column E is Column B from Sheet5

A button/macro for new sheet in the first spreadsheet would be nice.

The external data references are essential.

pointers to the relevant documentation and/or examples would be very

Drew Einhorn

"You can see a lot by just looking."
  --  Yogi Berra

Unsubscribe instructions: E-mail to
List archive:
*** All posts to this list are publicly archived for eternity ***


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.