Posts by R.Galamba • 177 points
11 posts
-
0
votes0
answers110
viewsQ: Copy Excel Data to Drive
Good morning, need to select data from a file Excel copy, open a file in Google Drive and paste the data. Sub ActualizarDrive() 'Selecionar Ficheiro Windows("Lojas_Pendentes_CCTV.xlsx").Activate…
-
1
votes0
answers85
viewsQ: Open Google Drive document and apply filters
Hello, I started using Google Drive to make it easier to share documents between different departments of the company but I don’t know how to create "Macros". I wish I had a file MENU where the…
-
1
votes2
answers1621
viewsA: How to use Excel’s "PROCH" function to fetch values from the bottom up?
@Elienay taking the table you present and always having the value above Cod.Prod uses the following formula in the cell G44. =+DESLOCAMENTO(B48;-1;CORRESP(F44;C48;0);1;1) EDITION As you can see the…
-
2
votes1
answer78
viewsA: Listing Codes from a Particular Vendor in Excel
Boas @lukkicode, see if this solution fits what you want. Table Dynamics…
-
0
votes1
answer578
viewsA: Unregistered class - Imagelist
From what I’ve researched, they say it’s necessary to record Msstkprp.dll file. See some tips on this link http://www.visualbasicsource.net/KnowledgeBase/q188331.txt…
-
1
votes2
answers3166
viewsA: VBA - Read a file. TXT and manipulate its lines
As I still cannot comment, I leave a suggestion that I think can help you. Columns("B:B").Select Selection.Replace What:="PROP", Replacement:=Range("H1").Value, LookAt:=xlPart, _…
-
3
votes1
answer98
viewsQ: Data validation
I am creating a database file and I have a data validation where the model matches its brand. I did a list type data validation from the table: With the following formula::…
-
1
votes4
answers13312
viewsA: Find first value greater than a certain number in Excel
I think this formula meets your need. I created an auxiliary calculus cell so that the search is done correctly. Auxiliary formula =SE(+INT(X2)-X2<-0,5;ARRED.PARA.CIMA(X2;0);X2) Search formula…
-
2
votes1
answer1221
viewsA: Automatic classification with tiebreaker criteria
Good, I think that solves your problem.…
-
0
votes1
answer669
viewsQ: Create search box on google Docs
Good, I have this VBA code and needed to build a Javascript for Google Docs that do the same thing. It is possible to convert VBA to Javascript? Thank you. Private Sub CommandButton1_Click() Dim F1…
-
1
votes1
answer620
viewsQ: Code VBA button
Good, I created a file (database query) in which each number corresponds to a PDF (link). I tried to create a USERFORM to search the PDF through the number and so far it is working. I’d like to…