Posts by guilherme • 39 points
3 posts
-
0
votes1
answer16582
viewsQ: Merge duplicate names into one line
I have this spreadsheet: I have in the spreadsheet the client ELISMAR CARLOS RODRIGUES DA MATA, who made 3 purchases, two on the date 10/08/2014 and one on the date 20/08/2014. What I need is to…
-
2
votes1
answer962
viewsQ: Choose a file in a folder and save it as text automatically
I want to make a VBA code that opens a specific spreadsheet and save it as tabulated text. I am with this code formulated Sub gerararquivotxt() Dim intChoice As Integer Dim strPath As string…
-
0
votes1
answer3804
viewsQ: How to change a cell based on the value of another cell?
Problem: Import data does not come with zeroes on the left I imported data from a text file, but even configuring to import in TEXT format, the cells of a column that in the file was 08 are imported…