+ Reply to Thread
Results 1 to 1 of 1

Plz micro to organized store in and out sales and return

  1. #1
    Registered User
    Join Date
    03-14-2012
    Location
    Yemen
    MS-Off Ver
    Excel 2010
    Posts
    22

    Plz micro to organized store in and out sales and return

    IN THE EXAMPLE SHEET I NEED DO THIS
    I NEED VBA MICRO GIVE ME THE RESULT SHOW IN SHEETS
    I HAVE STORE AND I HAVE ACTUAL QTY IN STOR LIKE SHOW IN (STORE_List) SHEET
    - WHEN I RECEIVE GOODS FROM WAREHOUSE TO STORE I NEED TO BUT ITEM IN (Submit_STORE_Ins) SHEET I NEED MICRO TO SUM QTY AND ADD IT TO (STORE_LIST) IF THERE IS NEW ITEM ADD IT IN NEW ROW IN (STORE_LIST) AFTER DOING THIS DELETE ALL RECORD FROM (Submit_STORE_Ins) SHEET
    - WHEN I RETURN GOODS FROM STORE TO WAREHOUSE FROM (Submit_STORE_Outs) I NEED MICRO TO SUB ITEM QTY THAT I'M GOING TO RETURN IT FROM (STORE_LIST) AFTER DOING THIS DELETE ALL RECORD FROM (Submit_STORE_OUTS) SHEET.
    - AT THE END OF SELLING DAY I'M GOING TO COLLECT SELLING ITEM AND PUT IT ON (STORE_SALES) SHEET I NEED MICRO TO SUB ITEM QTY THAT I'M GOING TO SALE IT FROM (STORE_LIST) AFTER DOING THIS DELETE ALL RECORD FROM (STORE_SALES) SHEET.
    - AND I'M GOING TO COLLECT RETURN ITEMS AND PUT IT ON (STORE_RETURN) SHEET I NEED MICRO TO SUM ITEM QTY THAT I'M GOING TO RETURN IT FROM (STORE_LIST) AFTER DOING THIS DELETE ALL RECORD FROM (STORE_RETURN) SHEET.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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