+ Reply to Thread
Results 1 to 9 of 9

Excel script needed- (with reward)

  1. #1
    Registered User
    Join Date
    10-17-2011
    Location
    rome
    MS-Off Ver
    Excel 2003
    Posts
    14

    Excel script needed- (with reward)

    Hi guys, I'm cross-posting this because I need help, asap... ty for reading

    http://forumserver.twoplustwo.com/45...eward-1114090/

    First of all, I know people cares about money (OBV) so... I don't know how much this script will worth, let's say I'm gonna pay 50$ for now, but I'm willing to pay more.
    I asked on 2p2, about a script, you can find it here
    http://forumserver.twoplustwo.com/45...eward-1044984/
    I started from 100$ but in private, I gave him 200$ since he did a very good job, and I paid before the job was done.


    Now...

    See the image below in order to understand better...

    http://img33.imageshack.us/img33/6980/journallq.png

    I have this excel sheet (which is basically a journal).
    Each color represent an activity, and sometimes, inside a cell I write down some details about the activity.
    What I wanna do is:
    1. select an area
    2. script recognize what colors and how many cells are filled
    3. script sums the cell with same color into another sheet
    4. script paste and copy the written details into another sheet

    that's all...
    If some is interested plz PM me, and I will give you all the details.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Excel script needed- (with reward)

    I have code that sums by colour but to get a better idea of what is neede3d you need to attach a workbook not a picture
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    10-17-2011
    Location
    rome
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Excel script needed- (with reward)

    Sure buddy
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-17-2011
    Location
    rome
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Excel script needed- (with reward)

    bump.........

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Excel script needed- (with reward)

    Some colours have different text, what do you want then?

  6. #6
    Registered User
    Join Date
    10-17-2011
    Location
    rome
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Excel script needed- (with reward)

    -Select an area
    -Count the cells with the same color

    So I want to select an area and know how many cells are green, how many cells are orange etc.

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Excel script needed- (with reward)

    It's point 4 I'm not sure about

  8. #8
    Registered User
    Join Date
    10-17-2011
    Location
    rome
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Excel script needed- (with reward)

    Well, point 4 is the less important so don't care about it

  9. #9
    Registered User
    Join Date
    10-17-2011
    Location
    rome
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Excel script needed- (with reward)

    bump..........

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1