Hi :) It sounds more like a database would do the trick. https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook Regards from Tom :)
On 9 June 2014 23:24, Philip Ward <[email protected]> wrote: > Hi Tom/all > > sorry for delay in getting back, and cheers for the info, ill take a look > tomoz night and the link, that much on the go at the moment... > > basically what im after is... > > A cleaning/HSE Check sheet, that gets printed out, and the staff fill it > out, ie tick the boxes, say whats gone of in that day etc. > > i have laid out a sheet, over 2 pages, and the only thing that i want to > basically do is print out 365 (or obviously a leap year 366) page document, > and automatically add a new date to the printed sheet for that. > > i didnt want to copy and paste the same thing 365 times, for 4 or 5 times, > as there are different parts of the business, ie Cafe/Bar/Icecream kiosk > etc, which all need their individual style/setup. > > i was looking for a quick way to copy the sheet, add a new sheet, paste > it, then do the same thing over and over again. On the second sheet i know > i can make a date = Previous sheet/Cell and +1 to it, and this would be the > one thats copied all the rest of the year, but thats about where my > knowledge on libre finishes (having brought most of what i knew from > excel), but have never done any macro's of this sorts before, well part > from gimp to re-size/touch up pictures, and even then found that i could > have done it quicker manually! > > i just would prefer not to copy and paste something a potential 1825 > times!! my control and V key probably woudlnt like me very much > > Cheers > Phil > > > On 8 June 2014 22:00, Tom Davies <[email protected]> wrote: > >> Hi :) >> Andrew Pitonyak's guide is pretty good and might be helpful >> >> https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers >> >> Really it is best to just ask the question here and let this team >> build-up the best answer by trying out different things. >> Good luck and regards fro m >> Tom :) >> >> >> >> >> On 8 June 2014 19:23, Philip Ward <[email protected]> wrote: >> >>> Hi Guys, >>> >>> Who is the best person to speak to about macro's in calc? >>> >>> cheers >>> Phil >>> >>> -- >>> To unsubscribe e-mail to: [email protected] >>> 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 >>> >> >> > -- To unsubscribe e-mail to: [email protected] 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
