User Profile

Collapse

Profile Sidebar

Collapse
dull1234
dull1234
Last Activity: Jul 17 '10, 02:33 AM
Joined: Feb 3 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • dull1234
    started a topic A good algorithm for this specific problem
    in Access

    A good algorithm for this specific problem

    Hi all
    I am having a question about Excel VBA
    Hope that this is the right place to ask

    Now i am having 2 giant spreadsheets, one has about 2000 entries, another one has about 1000 entries. The 1000 entries one contain information that i want to match it with the 2000 entries one

    So, i came up with the code that for every entry in the 2000-entry file, i check with every entry in the 1000-entry file, see...
    See more | Go to post
    • dull1234
      started a topic Matching data in an Excel file
      in Access

      Matching data in an Excel file

      Hello everyone
      I ran into a problem with Excel that i hope you can help me

      The thing i have to do is as following:

      In a spreadsheet (attached file), in Sheet 1, i have a column represents the Name, and a column represents a Company Code,
      and another column represent the Number Code
      In sheet 2, i have a column represents the Name Tag, a column represents a Company Code, and another column represent...
      See more | Go to post
      • dull1234
        replied to Creating a overall data summary by VBA
        in Visual Basic
        yes, that is what i mean. Because there may be different situations where different products have different sub-products. so if the set is different i would have to change the code manually. Hope you can help. Really appreciated.
        See more | Go to post

          Leave a comment:

        • dull1234
          replied to Creating a overall data summary by VBA
          in Visual Basic
          Thank you so much!! work like a charm!! i have a quick question for you, hope you can help me. Would it be possible to write a code that work for an updated version (for example, what if suddenly i have product A1, A2, A3 instead of just A). I realize for the code given above, i have to go and change the code manually. Is there anyway to write a code that will accomodate for that ?? thanks in advance!!...
          See more | Go to post

            Leave a comment:

          • dull1234
            started a topic Creating a overall data summary by VBA
            in Visual Basic

            Creating a overall data summary by VBA

            Hi everyone
            I am having a problem that i have to solve

            The attached Excel file have a list of purchase made in 10 days
            With 3 products A, B, C. And each product have 4 types:
            1. 50 (for every product A , B or C that has type < 100)
            2. 100 (for every product A , B or C that has type >= 100 and < 175)
            3. 200 (for every product A , B or C that has type >= 175 and < 250)
            4. 300 (for...
            See more | Go to post
            No activity results to display
            Show More
            Working...