Typing over a formula

L

LB_MJPA

New Member
Joined
Jul 22, 2010
Messages
1
i have an excel grid with 3 tabs. Its a travel doc: Staff, Air, hotel. My associate put formulas in the first tab in order to tie all 3 tabs so I wouldn't have to enter people's info all 3 times. But as soon as i go to type in their info, it loses the formula. How do i type over a formula and have the formula apply?
sample; =+air!C3
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Sort by date Sort by votes
A cell can only contain a value or a formula but not both
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Help with Sumifs formula involving dates
Replies
5
Views
249
Joe4
Joe4
W
  • Question Question
Formula help!
Replies
8
Views
174
Joe4
Joe4
Skrej
  • Question Question
Random page margin spilling over
Replies
4
Views
317
Skrej
Skrej
G
  • Solved
Typing out Excel formula in Excel Macro
Replies
1
Views
153
Macropod
Macropod
S
  • Question Question
Vlookuping matching values with hidden rounding errors
Replies
5
Views
743
awoohaw
awoohaw

Forum statistics

Threads
1,226,693
Messages
6,192,471
Members
453,726
Latest member
JoeH57

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top