Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Find all dates; copy next cell to new cell.

  1. #1
    New Member
    Join Date
    Jan 2002
    Location
    Western Australia
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Evening all,

    I have a sheet with alternating columns of dates and $ values; five of each; the first three columns of the sheet are static inputs; the alternating columns start after these.

    The date value is input manually to record the date the $ value had been claimed; the $ value remains static, only the dates are entered as needed.

    I need to:

    Find each date; know what claims were made for each date; copy the data (dates & $ values) to a new 'report' sheet for analysis.

    Any ideas?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sure.
    There are probably several ways to accomplish this.
    I only know one and am bored. Send me the work book and a sample of how you would like the summary to look.
    TsTom@HotMail.Com
    Tom

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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