Not sure if General or Here, but can Xcel do this?

[MJavner]

I am not sure where to post this question, but here goes. If I have a total in Column B, is there a way to get a pop up list in that cell, so you can choose different categories and allocate a set amount of that total to each category. I can manually enter them all in each category, but I have maybe 30 categories and sometimes I am searching to the end of my sheet for the one I need. Does this make sense? Hoping there is a time-saving option here. Thanks!

[charles]

HI,


Perhaps a workbook would help the members to see what your working with.

[MJavner]

Hope this helps to understand what I am asking. In the highlighted column for total is there a way to, upon entering the total in the cell, have a vertical pop up where I can plug in all the allocated amounts per category for that specific total. Rather than, say the total was $1000. $500 is Repairs & Maint, and $200 Sales Tax, and $300 is Charitable. Rather than scrolling through all horizontally and entering, a small vertical box to appear so I can type it in and it will populate the appropriate columns after I hit "enter" or something?

[charles]

Hi,

Thanks for the file. However, it has links which I can not see. Can you create a file and enter the values. And too note where you want the the data to go. I'm not a formula person so I do not know if this can be done via formula. But, it may be able to be done using code.

[NoSparks]

Yes, Excel can do this.

[NoSparks]

Guess that was a waste of time.
Good luck with your next question.