Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Denmark, Iowa, USA
    Thanked 0 Times in 0 Posts

    Sharing info to other workboooks (Excel 2000)

    I made separate logs to keep track of the miles that my wife and I ride on our bicycle. I would like to have it automatically update the info in her bike log when she rides with me, instead of having to enter it separately. In my log, I use the identifier (T) in a column, to indicate when she rides our tandem with me. I am new to Excel and am having problems figuring this out.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts

    Re: Sharing info to other workboooks (Excel 2000)

    Macro could be written to search for a T and send them all. You could even check in the output to make sure the item did not exist. Need lats more details before we could do any coding. or just have you select a row to be transferred and the macro could copy this over.

    Another suggestion:
    I am NOT a big fan of having "Duplicate" data. Why don't you combine it into ONE worksheet with a column for who. This column would consist of something like "Person1", "Person2" or "Person1/Person2". This would allow using a datafilter to work with the "sublists" you could get just Person1's list, just person2's list ANY with person1 etc. You could even track MORE than 2 people with this list.

    A pivot table could summarize and even the datafilter could be combined with SUBTOTAL to get stats on the data that is visible AFTER the filter.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts