I have a large set of data with different formulas that I would like to add the following formula to:
*Sheet1!B2
Is there a quick way to do this without changing all the formulas one by one?
Thanks
I have a large set of data with different formulas that I would like to add the following formula to:
*Sheet1!B2
Is there a quick way to do this without changing all the formulas one by one?
Thanks
without more information you could copy your formula into find, then in replace add the section you are talking about and do replace all (after trying on one) for example.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
That's what I would normally do but I can't do here because there's a bunch of different formulas in those cells.
can you just reference that in a different column? Say you have your formulas in column A. Starting in Cell B1, you could enter, =A1*Sheet1!$b$2, and then fill it down to all formulas in col A. (Not sure if you wanted absolute reference to B2 or not).
A bit wasteful regards columns, but you could always create a few helper columns that would reference your existing cells/formulas, and then just tack the *Sheet1!B2 on that?
eg =C2*Sheet1!B2
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for your help guys. The solution of adding new columns with the new formulas seems to be the easiest options.
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks