excel buffs please
taskey
Registered Posts: 1,800 Beyond epic contributor 🧙♂️
i have 2 spreadsheets and i need to copy the formula from one to another.
it is a choose formula which when a certain cell is changed it picks up info from another tab in that book. the problem is that when i copy the formula from the original spreadhseet, it puts the original file name etc into the formula. i dont want to link it, i just want to copy - how do i do this?
thanks
Tracy
it is a choose formula which when a certain cell is changed it picks up info from another tab in that book. the problem is that when i copy the formula from the original spreadhseet, it puts the original file name etc into the formula. i dont want to link it, i just want to copy - how do i do this?
thanks
Tracy
0
Comments
-
Click on the cell which has the formula
Then press F2 or click on the formula bar at the top which displays cell contents
Highlight the formula text and copy it
You can then paste that exact text wherever you want it0 -
b rill, thanks for the quick response - and it works )))
tracy0 -
Hello Taskey
Another way of doing this is to select the cell where the formula is, copy (using Ctrl C or the toolbar copy icon) and then Paste Special Formula (Alt, E, S and F) although this is a little longer than PGMs method.
One thing to be aware of when copying formula is if you have used absolute/relative/mixed referencing within your worksheet.
Hope this helps in the future.
JC~ An investment in knowledge always pays the best interest ~Benjamin Franklin0 -
Also,
If you have two spreadsheets;
-Input sheet where you input your figures and where all your formulae are
-Output sheet will show all the figures calculated from the input sheet and will update when you alter the input sheet.
You can also alter the layout of the output sheet, so it looks nice - good for sales boards, presentations etc.. so your input sheet is basically your rough workings and output is the good version.
So you copy and paste link (paste special then paste link in 2010)
Also you can remove Zero values by going to Tools > Options > Untick zero values
2010 - File > Options > Advanced > scroll a little bit til you find where to untick
It will update, but you should save both spreadsheets after inputting new data.
0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 87 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership