[libreoffice-users] Advanced Spreadsheet

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
etc.

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
helpful.



-- 
Drew Einhorn

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

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***