Forum Topic

excel macro programming

  • Post deleted #12328767
  • mga sir, baka meron kyong magandang inventory system para sa pagtrack ng mga container sa water station. parang pwede isearch yung code ng container then hahanapin nya kung kaninong client's na napahiram. salamat po sa makakatulong
  • ^in excel sheet ba ito? kung meron ka ng format pm msa akin, let's see...
  • Patulong sa excel file. Panu po transfrom yung table sa excel file as below

    *********** original table *******************

    Column A Column B
    A 2
    A 3
    B 5
    C 6
    C 7

    ************** Transform to below ****************************

    Column A Column B Column C
    A 2 3
    B 5
    C 6 7

    Bale yung mga numbers nasa Column B and Column C. Di lang maayus pagkakaadjust ng tipidpc.
    thanks.
  • @pixelspics
    formula is working except that u only need to filter Col A removing "FALSE" to show the correct output.

    Steps:
    Orig table should be in Sheet1 and output in Sheet2. Copy paste the below formula in Sheet2.
    A1:=IF(Sheet1!A1=Sheet1!A2,Sheet1!A1)
    B1:=IF(A2=FALSE,Sheet1!B1)
    C1:=IF(Sheet1!A1=Sheet1!A2,Sheet1!B2,"")
    then select A1 to C1 then copy drag till which row has data on Sheet1.
    Filter A1 removing "FALSE" on the List... and wallah! you have the same output. Gud luck!
  • @dodick
    thanks po
  • boss @ram2010 me msg po ako sainyo. pacheck naman salamat.
  • sir dodick me message ako sainyo pwede po pacheck. salamat
  • ngreply nko sa pm, pro ulitin ko nrn dto. kya sya di nagdidisplay gawa ng format ng cell na minention mo at nkalock din ata. best way is mgcopy ka nlng sa ibang cel then paste mo pra marestore ung normal format at mgdisplay sya. then use formula pra matic na plagi ung Sum Total nya.
  • Salamat pre, actually nafigure it out ko nadin na kaya pla di sya nakikita eh nakawhite color yung font. naayos ko nadin, ang issue na lang e yung mejo matagal yung pagupdate pagnirun yung macros.

    -- edited by djhurt on Nov 04 2021, 06:36 PM
  • hello @djhurt

    meron akong inventory storage management excel sheet, madali lang syang baguhin, kung gusto mo ng sample message mo lang ako dito sa tipidpc para I share ko sa iyo yong file tru email.


    ---cheers
    crenson