>

User Login

TipidPC.com is the largest online IT Community in the Philippines. Have something to sell or share? Sign up for an account now. It's absolutely free!

Forum Topic

excel macro programming

  • test
  • Boss ram, nagmessage ako sayo kaso parang di ata pumasok, nagpasalamat lang ulit ako sa naitulong mo sa spreadsheet na binuild mo, mejo nakuha ko naman ang code meron lang akong katanungan, dito pa sa product tracking e walang limit kahit dumami ang row kasi diba continues ang update ko dito.

    Final Tracking.
    http://www.mediafire.com/view/407ng2m58y1anpc/TV_Tracking_-_28_APRIL_15.xlsm

    saka pwede ko bang palitan yung customer ID ng room no. na lang bale don papasok lahat nung room na naissuehan ko ng tv at pati serial no e lalabas don na nasa ganitong room tong serial na na inissue ko. parang sa tingin ko mahirap pera lam ko walang impossible sayo. saka dito sa tracking na to inalis ko na lng yung column para sa size kasi di nagaappear sa report yung size kaya bale ginawa ko na lang e sinama sya sa brand pra automatic na gagawa ng bagong column sa report kada pasok ko ng ibang brand na me size. pagme libreng oras ka na lang sana mahelp mo ko dto at kung san ko ipapasok yung code na bago para don sa pagchange ko ng room na sa isang column jan ng customer ID. ako nga pla si einjelhart dati di ko na kasi maaccess yung account ko dati kya gumawa ako bago. salamat ulit
  • patulong naman po.

    I want to group items by a specific date rate(eg 1-9,10-15, 16-23, 24-30/31 of the month). Data is being entered as 01-May(walang year). Di ko makuha kung pano gawin sa IF. TIA
  • Batusai Send Message View User Items on May 27, 2015 04:41 PM

    Gamit ka ng pivot table, then group mo yong date sa column by days with equal interval.
    1-4
    5-8
    9-12

    4-1=3
    8-5=3
    12-9=3

    Interval is equal.
  • Isang method is alamin mo kung ano yung value ng date sa excel, example ay 01/01/1900 is 1 at 05/30/2015 is 42154.

    Di ko alam bat if gusto mo pero pwede mo mano manuhin yan, sample ay =if(x=1,1,if(x=2,1,if(x=3,1...)
    Tas sort mo ng by 1 kasi pasok yung 1-9 sa criteria ng 1, tas sa 2 para sa 10-15 and so on, kung medyo magulo may mas madali pa.

    Pwede mo iconditional formatting tas sort mo by kulay naman, tas meron pang isang madali.

    Pwede mo ifilter tas paste filtered fields sa ibang sheet.

    O kaya yung sabe ni boss ram na pivot.
  • djhurt Send Message View User Items on May 02, 2015 11:43 AM

    saka pwede ko bang palitan yung customer ID ng room no. na lang bale don papasok lahat nung room na naissuehan ko ng tv at pati serial no e lalabas don na nasa ganitong room tong serial na na inissue ko.

    Ito ginawa ko, para hindi complikado ang revision, madali lang mag retrieve ng info.
    Doon sa product sheet, I added a column called "Room no." after the column "Brand". So dito papasok kung anong room no. ang product based from its latest status na nasa sheet din na ito.
    When you run the macro called "UpdateProductStatus()" ma update din ang "Room no." column.

    So here is the code to update the Room no. in product sheet. Just add this code near the end of the macro, like the following.

    Sub UpdateProductStatus()
    ...
    ...
    ...

    ' Update the info of what room is the product located:
    ' Scan column 1 of product sheet
    For i = 2 To 65000
    If Sheets("product").Cells(i, 1).Value = Empty Then
    Exit For
    End If

    psn = Sheets("product").Cells(i, 1).Value 'product s/n

    ' Scan the log sheet
    For j = 2 To 65000
    If Sheets("log").Cells(j, 2).Value = psn Then
    Sheets("product").Cells(i, 6).Value = Sheets("log").Cells(j, 8).Value
    Exit For
    End If
    Next j
    Next i


    End Sub


    Itong info sa Room no. ay kinuha ko from "Issued to" column in log sheet. So make sure na sensible ang entries mo doon sa "Issued to" columns. May nakita akong Issued status pero blank yong "Issued To" entry.

    -- edited by ram2010 on May 30 2015, 09:43 AM

Who's Online

628 active users within the last minute, 359 members, 269 guests.
Our newest member is dirk09
Click here to see online members.

Browse Items

More »

Search TipidPC


New Want to Buys

Active Items for Sale

Active Want to Buys