User Profile

bob_sipes

Copper Contributor

Joined Jun 25, 2020

3 Posts3 LikesLikes received

View All Badges

User Widgets

Recent Discussions

Re: Copying formulas between spreadsheets without referencing the original spreadsheet
inCentea-Miguel_Lopes Brilliant, that did exactly what i wanted and needed. Thank you for sharing your time and knowledge.
Jun 26, 2020 Place Excel
63KViews
2likes
1Comment
Re: Copying formulas between spreadsheets without referencing the original spreadsheet
I was hoping not to copy and edit all 350 formulas.
Jun 25, 2020 Place Excel
61KViews
1like
2Comments
Copying formulas between spreadsheets without referencing the original spreadsheet
how do i copy a formula from 1 spreadsheet to another, and keep the formulas from referencing the original spreadsheet? I want the formulas to work in my new spreadsheet, instead of referencing the spreadsheet i copied them from. when i copy =SUM(Jan!U44) it turns into =SUM('[MORSUM 2017.xls]Jan'!U44) excel is adding the "morsum2017.xls" which is the source file name.
Solved
Jun 25, 2020 Place Excel
Formulas and Functions
77KViews
0likes
14Comments

Recent Blog Articles

No content to show