I have a cell (A1) in worksheetA that I would like to have = (A1) and (E1) from worksheetB concatenated and then I want (A2) in workbookA to do the same with the next cell in column A worksheetB that has text.
Is this possible? i can get it to concatenate but i am not sure on how to autofill looking for the next text in a specific range or if it is even possible.
Please help
Is this possible? i can get it to concatenate but i am not sure on how to autofill looking for the next text in a specific range or if it is even possible.
Please help