Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
4th Repost with no answer, Urgent reply needed!
Russ, anything is possible, but this is hard to do and would take a lot of
work and debugging. So there is no quick and easy answer unless by luck someone had exactly the same need. If I were designing this, I don't think I'd make it a "real time" copy unless I had to. Rather, I'd give the user a button or something that says in effect "I'm done, build the lists". Then I'd have the macro clear the existing lists and rebuild them all from the master. I'd probably just work down the master list and figure out where each record should go. Another way would be to incorporate Data, Filter, Advanced Filter. Of course, if you just want to see lists of one item then use Data, Filter, Auto Filter and pick the asset type you want. This does a filter "in place". Advanced Filter creates a list elsewhere. -- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
URGENT HELP NEEDED | Excel Discussion (Misc queries) | |||
Help Needed Urgent | Excel Discussion (Misc queries) | |||
Urgent reply would be a great help | Excel Worksheet Functions | |||
repost: Min/Max help needed with a SumProduct | Excel Worksheet Functions | |||
Repost: XL2000 Template Wizard - help needed to update database | Excel Programming |