Den 18 april 2012 09:47 skrev Andreas Säger <[email protected]>: > Am 17.04.2012 19:35, Mike Phelan wrote: >> >> I am trying to automatically remove a number from a range of cells, if it >> appears in a different range. >> >> I am creating a spreadsheet where once a number appears in B4:G11 4 times, >> it >> changes color to Red.......got that part. >> >> Then I want to manually enter that number somewhere into J4:N21. once >> entered >> into J4:N21, i want that number to erase from B4:G11. >> >> ideally at that point i would also like all remaining numbers in B4:G11 to >> shift up, leaving no empty cells above cells with values in them (keeping >> them >> in the order entered within columns). >> >> >> >> > > Only a small set of features adds data to your spreadsheet and nothing in > Calc will ever remove any data automatically. You have to do that by hand or > by means of a macro program. > It seems to be another inventory task which should be done in a database > program of your choice. Later you may connect your database to this office > suite (this is what the Base component does) and use Calc or Writer as > "output medium" for pretty printing and further calculations.
I actually think it's possible with cell functions only, but I think it would be quite complicated. Too complicated for me, anyway. I did something else that I also thought was impossible first, but I solved it eventually. It was not easy (for me) though… My task was to create a list of things that is sorted automatically. The formulas were quite long and hard to read… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions 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
