123 reputation
4
bio website n/a!
location Computadora
age 83
visits member for 2 years, 4 months
seen Oct 22 at 23:44

Here I am! The younger I get, the less I know. . .


Aug
14
comment Excel for Mac - unable to create my own macros
I've added my comment as an answer which you may accept to "close" the question. :)
Aug
14
answered Excel for Mac - unable to create my own macros
Aug
13
answered Focus last modified cell when opening Excel
Aug
8
comment Referencing a single row to multiple rows in Excel
Check out the answers provided for this question. One's a manual solution; the other is with VBA.
Aug
8
awarded  Teacher
Aug
8
comment Excel for Mac - unable to create my own macros
What is the value in the cell after you enter =hello()? Did you make sure to put the functions in a Module (not the Worksheet/Workbook)?
Aug
8
answered Excel 2010: Colour cells in a column based on values in another column
Aug
8
answered How do I highlight rows based on latest time stamp in Excel?
Aug
2
awarded  Editor
Aug
2
awarded  Organizer
Aug
2
revised fill values in excel according with dates
corrected spelling/grammar and improved readability, removed 1 tag, added 1
Aug
2
comment How do I add a value to a cell in Excel if it's an int?
Keep in mind that formatting this way, in general, may affect cell values in VBA. If I were to make a custom type like "derp"@, then my Range(Address).Value would look at the unformatted value. To get the formatted value, you would use Range(Address).Text.
Aug
2
suggested approved edit on fill values in excel according with dates
Aug
2
comment Sum up, then delete
How familiar are you with VBA? Have you tried using the macro recorder, then generalizing the problem? I would try the following (with the macro recorder): use a formula in a 3rd column to calculate the sum for each invoice #, copy the results and paste them back in the 3rd column as values only, then select the columns and use the Remove Duplicates option (under the Data tab) and choose to remove the duplicates in the 1st column (uncheck the others). You'll be left with unique invoice #s and their sums.
Aug
2
awarded  Autobiographer
Aug
2
answered importing data from one excel sheet to another?