Re: [libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

Dne 3.2.2012 16:50, Andreas Säger napsal(a):
> Am 03.02.2012 16:05, Gordon Burgess-Parker wrote:
> > I have a spreadsheet that is used for monthly and annual collection of
> > data, with monthly tabs, Jan 2011, Feb 2011 etc.
> > Is there a way to rename 2011 to 2012 in bulk, or do I have to do each
> > one manually?
>
> Splitting up equally structured data across many sheets is *always* a 
> huge mistake. Don't do that.
> Simply put everything in one table and add a field for the month.
> There are dozends of features which allow you to get data and 
> calculations for any category of a single table.

Listen to that smart advice from Andreas.
And do it better by adding another field (column) for year and line_ID.

That line_ID I mean something that identifies the line content.
Let's say you have in each sheet report line labeled "Turnover", line 
labeled "Costs"
and line labeled "Number of employes".
Those line labels can be the line_ID but better is to add a numeric key 
because of sorting.

Then use the data-pilot to filter and select desired year and month.
The final report you can edit and format using the marvelous VLOOKUP 
function
- lookup in the data-pilot values belonging to line_IDs.

Resume:
- keep unformatted data in Sheet1 - this is your database

- have selected time period filtered in datapilot in Sheet2 - define 
once, change filter only

- format a nice presentation of v-looked-up values in Sheet3 - define 
once - it presents data of Sheet2


Regards,
Jiri

--

Ing. Jiří Hladůvka - REVIDA

http://www.revida.sk
mailto:mail@revida.sk


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted