Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2016, 03:43 AM
Guloluseus Guloluseus is offline Overwriting values in formula controlled column Windows 7 64bit Overwriting values in formula controlled column Office 2010 32bit
Competent Performer
Overwriting values in formula controlled column
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default Overwriting values in formula controlled column

I have a text column within my project that inserts text depending on the resource group.
Is it possible to overwrite this at all? For example, for the resource group "A", the text string by default is "QWE". Is there a way to set up the formula so that this can be overtyped, or is it now fixed?

thanks in advance
Reply With Quote
  #2  
Old 12-28-2016, 11:49 AM
JulieS JulieS is offline Overwriting values in formula controlled column Windows 7 64bit Overwriting values in formula controlled column Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Sorry - columns are either calculated or not. You cannot type in columns that are calculated.
Reply With Quote
  #3  
Old 12-29-2016, 07:44 AM
Guloluseus Guloluseus is offline Overwriting values in formula controlled column Windows 7 64bit Overwriting values in formula controlled column Office 2010 32bit
Competent Performer
Overwriting values in formula controlled column
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

as I expected- it was a forlorn hope

We are looking at changing the layout in VB so that we can use a value in the column in another column (i.e. copy the value over as an input as opposed to a formula). So far it works as an excel copy and paste, then copying the values back- our resident VB expert is still on a learning curve, although i am gradually catching up!
Reply With Quote
  #4  
Old 01-09-2017, 05:58 PM
JulieS JulieS is offline Overwriting values in formula controlled column Windows 7 64bit Overwriting values in formula controlled column Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Good luck :-)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy non zero values to new column Guloluseus Excel 3 01-10-2016 08:48 AM
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
Formula/function to return column names for matching values GiJoe81 Excel 1 06-27-2015 12:13 AM
Overwriting values in formula controlled column Three Columns - Controlled ! abrogard Word 1 05-06-2012 10:01 AM
Fields controlled by List box values farfromapro Word 0 02-11-2009 02:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft