backup formula

[sdc1234]

I have 1 person who has a new job title (cell d4) every week, Is there any way for excel to "store the data" in cell h7,
for example: D4 Jobtitle=Cashier that moves over to H7
same person D4 = bagger that moves over to H7 and now H7 says Cashier, bagger

 

[bryonwoods30]

yes you can make this work, you have to change excels "interations" by enabling it

On the Tools menu, click Options, and then click the Calculation tab.
Select the Iteration check box.
To set the maximum number of times Microsoft Excel will recalculate, type the number of iterations in the Maximum iterations box. The higher the number of iterations, the more time Excel needs to calculate a worksheet.
To set the maximum amount of change you will accept between calculation results, type the amount in the Maximum change box. The smaller the number, the more accurate the result and the more time Excel needs to calculate a worksheet.


in H7 use the formula =h7&","&d4

this is a circular reference and that is why you have to turn interations on. after doing this, you can continue to change d4 and it will keep adding to h7

 

[sdc1234]

great it worked is there any way to instead of having them populate across is having them populate in a dropdown menu perhaps

appreciate all ur help

 

[sdc1234]

ok now I have a ? reguarding earlier post.. If I had a job title and date,
then I had to add another one, instead if the formula =h7&","&d4

could I populate the job titles in d4 into a dropdown menu, that would eliminate some cells for me


thx

 

[sdc1234]

i wanna take the formula one step further =h7&","&d4
I what to push them over into a new column/row everytime a new job description is entered