Have a formula that "Barry" helped me with. It takes certain info from one cell and distributes it to another cell in the row. My question is: I need to take that formula and have it work for the other 99 rows below it. How do I change the "B2" to "B3" "B4" etc.? And then also, is there a way to take a spreadsheet that has been created from an export (from a software) and APPLY the additional row (with the formulas) to the sheet without having to open the sheet, copy from a completed one and pasting the new column into the new excel sheet. I hope I am making sense.
I will be working with new excel sheets every two days. I just need a quick way to pull that info and place into the new column for the entire sheet at one time.