+ Reply to Thread
Results 1 to 16 of 16

HELP to make a Kinda of a Sheet comparison

  1. #1
    Registered User
    Join Date
    03-02-2017
    Location
    Dominican Republic
    MS-Off Ver
    MS Office 2010
    Posts
    9

    Exclamation HELP to make a Kinda of a Sheet comparison

    Hi,

    I have an old inventory program on my business and the reports that generate are limited, I'm trying to re-order the items i've sell since january 2017 but I don't want to order stuff that I already have, but the program doesn't make that kind of stuff, so the only thing I can generate is my current inventory and the items I've sell since january separetly, and I was wondering If I could do in Excel a sheet that takes both reports and organize it on their rightful items and make two columns one that says selled, and other current inventory so I can see what how much I should order of an Item. This is difficult AF for me, I tried and tried and nothing, hope for some help

    right now I'm ordering items looking at them one by one, and that way takes a lot of time for me
    if you need kind of an example of what I'm talking about just tell me

    sorry for my english!

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: HELP to make a Kinda of a Sheet comparison

    You English is good enough . We will need to see what each report looks like. Please attach a sample of each with sensitive data changed. Then we can help you better.

    To Attach a File:

    1. Scroll down to the window below your post Additional Options
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    03-02-2017
    Location
    Dominican Republic
    MS-Off Ver
    MS Office 2010
    Posts
    9

    Re: HELP to make a Kinda of a Sheet comparison

    I also attached an excel file with the example of what I mean!
    Attached Files Attached Files

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: HELP to make a Kinda of a Sheet comparison

    This spreadsheet took some extra work because of how the data in the text file is organized.

    On the control panel sheet enter the following data.

    Cell B2 enter in the path name to the directory or folder that contains the data to import.

    Cell B3 enter the name of the text file that contains the current data. Please note, that if the file has a date stamp you may be able to compute this name. For example, the file might be called Current 20170302.txt. ="Current "&TEXT(TODAY()-1,"yyyymmdd")&".txt" would compute the name of the file for yesterday.

    Cell B4 enter the name of the text file that contains the selled data.

    Make sure to include the .txt extension.

    Click on the Make Report Button. The program will check to make sure that the source files exist and imports them. The program then creates the report on the Report sheet.

    The other sheets that are shaded in brown can be hidden if you wish.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-02-2017
    Location
    Dominican Republic
    MS-Off Ver
    MS Office 2010
    Posts
    9

    Re: HELP to make a Kinda of a Sheet comparison

    Let's see how it goes! I'll give you feedback about it

  6. #6
    Registered User
    Join Date
    03-02-2017
    Location
    Dominican Republic
    MS-Off Ver
    MS Office 2010
    Posts
    9

    Re: HELP to make a Kinda of a Sheet comparison

    To generate the report, is it necesary that the source files are in .txt?
    could it process in excel format?

  7. #7
    Registered User
    Join Date
    03-02-2017
    Location
    Dominican Republic
    MS-Off Ver
    MS Office 2010
    Posts
    9

    Re: HELP to make a Kinda of a Sheet comparison

    It is not working. check it out

    p.d. the zip folder contains a .txt that is too big for uploading

  8. #8
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: HELP to make a Kinda of a Sheet comparison

    It might be better if they were in Excel format Attach samples and I will alter the code.

  9. #9
    Registered User
    Join Date
    03-02-2017
    Location
    Dominican Republic
    MS-Off Ver
    MS Office 2010
    Posts
    9

    Re: HELP to make a Kinda of a Sheet comparison

    here are the files!
    Attached Files Attached Files

  10. #10
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: HELP to make a Kinda of a Sheet comparison

    Here is the revised report. Click on Import Data, then click on Make Report. You have 519 items in the report. That's a lot of items. You may want to use the report table as the source for a pivot table or put other filters on it such as where you have zero inventory.

    The code is written in English, but you can change the descriptions in cells A2:A4 to Spanish, and it will not affect the program. You can also change the column headers in Cell C1 and D1 on the Report Sheet. If you want to change the sheet names:
    - You can change the Control Panel name and the Report Sheet Name without any issue.
    - If you want to change the Selled Data and Current Data Sheets, open the VB Editor (Alt-F11) and double click on the module ModMain. Change the assignments for MySheet.
    Please Login or Register  to view this content.


    Good luck with the project.
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    03-02-2017
    Location
    Dominican Republic
    MS-Off Ver
    MS Office 2010
    Posts
    9

    Re: HELP to make a Kinda of a Sheet comparison

    Damn is working great!

    But, I would also like to see the items that doesn't have the selled info even if in the selled column has to appear in zero, because I have items that have the same references or numbers but come in different brands, so even if I don't have an item on a specific brand I probably have it in another then I don't really need to re-order that other item which appears in zero, It will organize it by name and it will appear in the sequence on top of each other the ones I haven't even selled,

    I'm really sorry if am being too demanding, if you can't do anything else I will understand.

  12. #12
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: HELP to make a Kinda of a Sheet comparison

    You want to see a list of all items: Selled items even if there is no inventory and inventory items, even if the item is not on the selled list. Is this correct?

  13. #13
    Registered User
    Join Date
    03-02-2017
    Location
    Dominican Republic
    MS-Off Ver
    MS Office 2010
    Posts
    9

    Re: HELP to make a Kinda of a Sheet comparison

    Instead of only showing the items I've selled, I also want it to show me the rest of the items that are on the inventory data even if they are not on the selled info it could appear as zero (0) items selled

  14. #14
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: HELP to make a Kinda of a Sheet comparison

    I think this is what you want.
    Attached Files Attached Files

  15. #15
    Registered User
    Join Date
    03-02-2017
    Location
    Dominican Republic
    MS-Off Ver
    MS Office 2010
    Posts
    9

    Re: HELP to make a Kinda of a Sheet comparison

    That's it!!!

    thank you man!!!!

  16. #16
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: HELP to make a Kinda of a Sheet comparison

    You are welcome. Please mark the thread as solved when you have checked it out.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Trying to make the spreadsheet compare the text in two cells for a comparison
    By zamirkaya in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-05-2016, 03:18 AM
  2. Need to make a report useful for comparison to others
    By JustJimAZ in forum Excel General
    Replies: 2
    Last Post: 05-26-2016, 02:06 PM
  3. [SOLVED] Filter the original sheet based on comparison and paste the results onto a new sheet
    By aviatecar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2014, 12:45 PM
  4. Excel 2013 : Time sheet kinda thing :P
    By cresh0r in forum Excel General
    Replies: 9
    Last Post: 01-04-2014, 09:01 AM
  5. Two excel sheet comparison and show the result in a new sheet
    By Chito in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-30-2012, 06:31 AM
  6. make comparison
    By daytime in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2009, 05:25 PM
  7. [SOLVED] Formula for time sheet kinda??
    By coxii in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-06-2009, 11:41 AM

Tags for this Thread

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