2017-09-17 11:00:01 +0100 | ha commentato una risposta | Calc, Copy a certain value from one sheet to another For the spirit code... Does the line "oCursor.gotoOffset( 0, 179 )" indicate where to start doing the lookup? |

2017-09-14 20:36:14 +0100 | ha commentato una risposta | Calc, Copy a certain value from one sheet to another Thank you so much for your time and help. It seems to work perfectly :D still need to add the Spirit set, which I am bus |

2017-09-14 20:20:08 +0100 | ha commentato una risposta | Calc, Copy a certain value from one sheet to another Thank you so much for your time and help. It seems to work perfectly :D still need to add the Spirit set, which I am bus |

2017-09-14 20:20:08 +0100 | received badge | ● Commentatore |

2017-09-13 02:34:10 +0100 | ha commentato una risposta | Calc, Copy a certain value from one sheet to another @librebel found one error. for the "needed" macro, after I added the "spirit of rebellion" set underneath the Awakenings |

2017-09-13 00:05:45 +0100 | ha commentato una risposta | Calc, Copy a certain value from one sheet to another oh, that was just as an example file. in row 2 I added a header I merged cells A to K and added "Awakenings" going to do |

2017-09-12 23:15:32 +0100 | ha commentato una risposta | Calc, Copy a certain value from one sheet to another Wow... this is awesome, thank you very much... I really appreciate the help. you asked "For the "Needed Cards": (should |

2017-09-12 18:42:37 +0100 | ha commentato una risposta | Calc, Copy a certain value from one sheet to another Maybe we could discuss this over a PM or email? not sure how or where to do that on this site though... |

2017-09-12 18:37:22 +0100 | ha commentato una risposta | Calc, Copy a certain value from one sheet to another Once that is all done, I will need to add another 2 buttons performing a very similar function to the previous 2, but ou |

2017-09-12 18:33:25 +0100 | ha commentato una risposta | Calc, Copy a certain value from one sheet to another Once that is all done, I would like another button (or could even use the same button, just thought another button would |

2017-09-12 18:31:20 +0100 | ha commentato una risposta | Calc, Copy a certain value from one sheet to another I need the button only to check from A3:K176 (im not sure where the top code is reading from and to) how does it know to |

2017-09-12 18:23:56 +0100 | ha commentato una risposta | Calc, Copy a certain value from one sheet to another Basically, I want to have my whole collection on the main sheet (as it is now) then a button outputting what i have for |

2017-09-12 18:23:04 +0100 | ha commentato una risposta | Calc, Copy a certain value from one sheet to another AWESOME!!!! Thank you, thank you, thank you!! its working :D Ok, I'm trying to understand the code and have somewhat of |

2017-09-09 00:26:44 +0100 | ha modificato una domanda | Calc, Copy a certain value from one sheet to another Calc, Copy a certain value from one sheet to another My spreadsheet knowledge is really tiny, the last time i did advanc |

2017-09-09 00:24:35 +0100 | ha modificato una domanda | Calc, Copy a certain value from one sheet to another Calc, Copy a certain value from one sheet to another My spreadsheet knowledge is really tiny, the last time i did advanc |

2017-07-29 17:32:02 +0100 | received badge | ● Domande famose (source) |

2017-07-28 01:32:13 +0100 | received badge | ● Entusiasta |

2017-07-27 23:24:41 +0100 | received badge | ● Revisore (source) |

2017-07-27 23:24:41 +0100 | ha modificato una domanda | Calc, Copy a certain value from one sheet to another Calc, Copy a certain value from one sheet to another My spreadsheet knowledge is really tiny, the last time i did advanc |

2017-07-27 22:21:57 +0100 | ha accettato una risposta | Calc, Copy a certain value from one sheet to another My spreadsheet knowledge is really tiny, the last time i did advanced functions was in primary school. I am trying to make a spreadsheet for a Card game to make sorting my collection easier. So far I need it to show after a certain value if I have any to trade. so I found a =MAX(0,A14-B14) function (where the first column is the number I have and the second is the max amount I need) which will show me how many of that card I have to trade. I have another row with a IF function showing if that card is complete returning a "yes" or a "no" (=IF (A14>=B12, "yes", "no")) Now, I would like one more function. I need to be able to take the ROW of the card I have for trade and put it in a new sheet, based on if the collection is complete AND the number I have for trade is greater than 0, removing any spaces between rows. I have seen something like this done using an advanced visual basic parameter, but im sure that this could be done using normal spreadsheet functionality. Can anyone help me out? as a bonus, I would also like to take cards that are not complete and put those in a new sheet. https://ask.libreoffice.org/upfiles/1... In the attached File you can see what i have so far... it reads count vs max and outputs a yes or no if complete, then tells me how many I have extra for trade. I want to now do a check on if it is complete and I have trades (so if row J shows "yes" AND the For Trade number equal to or higher than 1 in row K) I want it to then take that row and put it in a new sheet. thanks ## !!UPDATE!!Ok, I have decided to try do this using a macro button that runs a Libre office basic script, problem is that all i can find are scripts for Open office basic and excel and I am not sure how to convert them to Librebasic. Tried asking on the Stackoverflow page, but the one answer I get is of a guy just basically saying "yup... that wont work..." without any constructive help. This is what i have so far... I keep getting a Syntax errors anyone familiar with Librebasic? |

2017-07-27 22:21:57 +0100 | received badge | ● Studioso (source) |

2017-07-27 22:21:44 +0100 | ha modificato una risposta | Calc, Copy a certain value from one sheet to another I have gotten most of the functionality working now... except the copy to other sheets. so I would like to get that wor |

2017-07-26 00:00:06 +0100 | ha risposto a una domanda | Calc, Copy a certain value from one sheet to another I have gotten most of the functionality working now... except the copy to other sheets. so I would like to get that wor |

2017-07-25 23:54:06 +0100 | received badge | ● Domanda notevole (source) |

2017-07-24 16:49:38 +0100 | received badge | ● Studente (source) |

2017-07-24 12:20:32 +0100 | received badge | ● Domanda gettonata (source) |

2017-07-23 22:31:38 +0100 | ha posto una domanda | Calc, Copy a certain value from one sheet to another |

Content on this site is licensed under a Creative Commons Attribuzione Condividi allo stesso modo 3.0 license.