<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
HI,<br />
Have a formula that &quot;Barry&quot; helped me with. &nbsp;It takes certain info from one cell and distributes it to another cell in the row. &nbsp;My question is: &nbsp;I need to take that formula and have it work for the other 99 rows below it. &nbsp;How do I change the &quot;B2&quot; to &quot;B3&quot; &quot;B4&quot; etc.? &nbsp;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. &nbsp;I hope I am making sense. <br />
<br />
I will be working with new excel sheets every two days. &nbsp;I just need a quick way to pull that info and place into the new column for the entire sheet at one time.
</div>
</div>


HI,
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.

How do I insert a formula to an existing spreadsheet (containing 100 rows) that extracts info from one cell and places it in another.

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.