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

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.
CynSzczAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamMicrosoft Excel ExpertCommented:
If you are referring to these two formulas

="A"&TEXT(MATCH(2^15,INDEX(SEARCH("A"&TEXT(ROW(INDIRECT("1:1000"))-1,"000"),B2),0))-1,"000")

="L"&TEXT(MATCH(2^15,INDEX(SEARCH("L"&TEXT(ROW(INDIRECT("1:1000"))-1,"000"),B2),0))-1,"000")

then you can see that B2 is a relative reference and once you copy the formula down, the B2 will automatically be B3 and B4 depending on how many rows you copy down.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Spreadsheets

From novice to tech pro — start learning today.