Thanks a lot. Have a good day.
Well, I don't know what can I do. I'm still learning about this code. Sorry if I waste your time.
I use Firebird 2.5 to connect it. All the archives are hidden.
Hi. Sorry for waste ur time. I uploaded all the VBA codes used in this ADD-IN.
I have some questions, I don't know if I can post this here or move to another forum.
Well, I have an Add-In developed by a partner who was fired, so he made this add-in in 32bits Excel, so It doesn't work in 64bits Excel. It's a kind of accounting sheet.
Anyone knows how can move/import/export/modify this Macro? Also I use Firebird 2.5 to connect a Database. I changed 32bits Firebird to 64bits Firebird and nothing happened.
Thanks a lot by the way.
Thanks a lot guys.
I have an specific date and another "range of dates" where I'm trying to find data and put it in the other sheet.
I used VLOOKUP but didn't work.
I'll share an example and how would see the data.
Thank you for help.
Thanks for the advice and I'll try the formula.
Have a good day.
Hello from Mexico.
Because I'm reading a lot of bills, then I paste them and finally check how many bills client have. I didn't think something about formula, I just think, well I'm making with VBA, it'll work if I continues with VBA.
- R1 = 3
- R2 = 3
- R3 = 3
- Do While Worksheets("Client's List").Range("C" & R1) > ""
- If Worksheets("Client's List").Range("C" & R1) = Worksheets("Client's Bills").Range("B" & R2) Then
- ID= Worksheets("Client's List").Range("B" & R2)
- Worksheets("Client's Bills").Range("D" & R3) = ID
- ID = ""
- R3 = R3 + 1
- R1 = R1 + 1
- R2 = 2
- End If
- R2 = R2 + 1
This is my 1st code.
If in "Client's List" doesn't exist the name, it doesn't matter, put then "I need the ID", I don't know if that a correct question.
Hello everybody. I'm newbie on the hood.
I have a Clients list and Client's ID list.
Then, I have another list who'll insert client's bill and client's name and finally check my client's ID and insert in another sheet, but if i don't have client's name or client's ID, insert into that cell "I need the ID".
I'll share it. It's an example.