Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to stop formuls from automatically changing
I have a file with mulitiple worksheets. The first worksheet is the summary
and pretty much just rolls up the info from all the other worksheets. My problem is, everymonth i enter new information into Row 6 / Column C in all of the supporting worksheets. What i want to happen is, the summary worksheet to grab the infomation from this cell and disregard the others. Whenever I insert a column into the supporting worksheets each month the formula on the summary page automatically cahnges. How do i stop it from changing? Here is the formula I am currently using =Electric!$C$7 When I had a new row it will automatically change to =Electric!$C$8 Please help.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop automatically copying an entry to the next column? | Excel Discussion (Misc queries) | |||
stop automatically changing fomula ... | Excel Worksheet Functions | |||
How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
stop automatically making email address | Excel Discussion (Misc queries) | |||
How do i stop the colors changing on my pivot chart when i refres. | Excel Discussion (Misc queries) |