Varuni has attended:
Excel VBA Intro Intermediate course
Advanced list facility (Excel or VBA)
Hi,
I have included some list filters in an excel document (using advanced filters) to restrict what can be typed into my file. However the file is huge despite only having filters and no data.
Is there an alternate way - perhaps by VBA - to include this option of lists.
Using VBA, the ideal is that the person can use drop down boxes to pick customers etc and this populates a row - they should then be able to update other boxes in the same row manually.
Obviously when they go to the next row, they should have the same pop up box....but now amending the new row.
Is this possible?
Thanks!
RE: Advanced list facility (Excel or VBA)
Hello Varuni
okay thanks for your post which we have reviewed with interest.
The outcomes you are trying to achieve are possible however beyond the scope of this forum.
This sort of work can be addressed by one of us spending at least a day with you. This would be consultancy and thus billable. If you would like to investigate this further please contact us directly to discuss.
kind regards
Jacob