Andrew Kedem
New Member
I'm preparing a spreadsheet populated with multiple invoices and multiple line items. I can't import with blank cells in "Item" column.
I'm looking for a formula needed to find cells with specific word," Totals ", (i.e. "#Totals#") and populating other cell in same row with word, "Total".
For all cells in Column A with " Totals " in cell, I want to have "Total" entered in same row, Column M, "Item" column.
In every row where the word "Totals" appears, with a space before and after the word, I need Column M to populate with the word, Total.
What formula and/or macro can I use to accomplish this? See sample file.
I'm looking for a formula needed to find cells with specific word," Totals ", (i.e. "#Totals#") and populating other cell in same row with word, "Total".
For all cells in Column A with " Totals " in cell, I want to have "Total" entered in same row, Column M, "Item" column.
In every row where the word "Totals" appears, with a space before and after the word, I need Column M to populate with the word, Total.
What formula and/or macro can I use to accomplish this? See sample file.