Fai la tua domanda

Snake3y3s's profile - attività

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

Option Compatible
Sub SWD_AwakeningsTrade
    Dim i, LastRow
    LastRow = Sheets("Card_List").Range("A" & Rows.Count).End(xlUp).Row
    Sheets("Awakenings For trade").range("A2:I500").clearContents
    For i=2 to LastRow
        If Sheets("Card_List").Cells(i,"K").Value = "(>1)" Then
            Sheets("Card_List").Cells(i, "K").EntireRow.Copy
            Destination:=Sheets("Awakenings For trade").Range("A" & Rows.Count.end(xlUp)
        End if
    next i
End Sub

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

Calc, Copy a certain value from one sheet to another My spreadsheet knowledge is really tiny, the last time i did advanc