>

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

  • O kaya ganto para dependent sa column a saka inde na mahaba:

    sa column a2 pababa, input mo kung ilan units, blank or 0 pataas, tas sa c2 naman yung price per piece tas sa b2 pababa eto lagay mo:

    =if(a2=0,0,a2*c2)

    a b c
    1 unit price
    2 1 10 10
    3 2 20 10
    4 3 30 10

    di ako marunong maglagay ng pix pero sana maintindihan mo tas di pa magkamukha yung sa text box sa magiging post, haha.

    -- edited by skabuts on Jul 08 2015, 08:20 AM
  • vlookup gamitin mo. Maintain mo muna sa isang sheet lahat Unit and Price mo. then gamitin mo yun as look up mo.
  • Good day , sino sa inyo ang nakaka encounter ng hang dito at laging not responding yung sheet , kasi ako lagi na lng kada mag sasave ako ng data. Mataas naman yung specification ng PC ko , baka merong nakakaalam ng resolution dyan.

    External Image


    External Image


    -- edited by centurysordie on Jul 08 2015, 09:47 AM

    -- edited by centurysordie on Jul 08 2015, 09:50 AM
  • @jamazi

    What do you mean by macro sir?

    Meron akong list of inventory then meron akong template ng computation.

    2 Data yung i-enter ko para ma-validate.

    For example:

    Invetory:

    Model |Class|Price|length|width
    2007 | 1 | P1 | 1 | 2
    2007 | 2 | P2 | 2 | 3

    Then eto yung sa Sample Computation:

    Model | Class | Price | Length | Width
    2007 | 1 | P1 | 1 | 2

    Bali yung 2 datas(Model and Class) yung need ko i enter. Then pag enter saka lalabas yung value nya sa price, length and width.

    -- edited by jeff_3429 on Jul 08 2015, 02:29 PM
  • centurysordie Send Message View User Items on July 08, 2015 09:46 AM
    Good day , sino sa inyo ang nakaka encounter ng hang dito at laging not responding yung sheet , kasi ako lagi na lng kada mag sasave ako ng data. Mataas naman yung specification ng PC ko , baka merong nakakaalam ng resolution dyan.

    I experienced it on one excel file (from other user) that I tried to open in my PC.
    Looking on that file there are a lot of links, and formulas.

    So what kind of file did you open?
  • jeff_3429 Send Message View User Items on July 08, 2015 02:11 PM


    Here is an example using vlookup.
    On your sheet2, create a unique column that contains your model and class. Combine it with Model-Class.

    External Image



    Then on your sheet1 you will lookup the Model and class from sheet2. You just input Model and class.

    External Image


    The fomula in D2 is
    =VLOOKUP(($A2&"-"&$B2),Sheet2!$A$2:$F$16,5,0)

    and E2 is
    =VLOOKUP(($A2&"-"&$B2),Sheet2!$A$2:$F$16,6,0)


    Creating a macro would be easier if your data is like in sheet2 from the example above and there is no need to combine Model-Class.

    -- edited by ram2010 on Jul 09 2015, 08:34 AM
  • @ram2010

    Meron akong four sheet na merong data na manually input , then meron akong isang isang sheet na nagcoconsolidate ng data nung apat na sheet using index match , and meron akong another sheet na nagcoconsolidate ng mga pending works using dynamic list na naka link din sa ibang excel , after ko na ginawa yung sheet na yun, lagi ng naghahang yung excel ko lalo na pag nagsasave.
  • centurysordie Send Message View User Items on July 09, 2015 08:59 AM - USER IS ONLINE

    and meron akong another sheet na nagcoconsolidate ng mga pending works using dynamic list na naka link din sa ibang excel

    This one is probably the main cause of the problem.

    One solution is to remove the link and just copy the data of other excel file into your workbook.
    Kapagka na copy na, pwede na siguro mag create ng link within your excel file.
  • @ram2010

    Sir do you mean , mas maganda if nasa isang workbook lang lahat ng excel files ko ? tama ba ? kailangan ko i consolidate lahat into 1 excel file and mag add na lang ako ng mga sheets ?
  • @ram2010

    Saka ask ko na din , if maglalagay bako ng ssd sa pc ko masosolved yung problem?
  • centurysordie Send Message View User Items on July 09, 2015 11:18 AM
    @ram2010

    Sir do you mean , mas maganda if nasa isang workbook lang lahat ng excel files ko ? tama ba ? kailangan ko i consolidate lahat into 1 excel file and mag add na lang ako ng mga sheets ?

    Depende rin ito kung ilang sheets ang e add mo. But you need to experiment. If possible avoid the links
  • centurysordie Send Message View User Items on July 09, 2015 11:19 AM
    @ram2010

    Saka ask ko na din , if maglalagay bako ng ssd sa pc ko masosolved yung problem?

    I am not sure, but I think this has to do with excel and your workbook, perhaps it is performing some calculations before saving.

    Have a look here on excel specs and limits, baka may na exceed ka na, na limits dito sa workbook mo.

    Excel-specifications-and-limits.
    <click here for link>
  • @ram2010

    Thanks for the help sir , try ko magsimula sa umpisa ulit para ma minimize yung links pero i think hindi ko siya maavoid , thanks ng marami sa tulong.
  • Guys tanong ko lang gano katagal nyo inaral yung basic ng VBA ?
  • centurysordie Send Message View User Items on July 10, 2015 09:15 AM - USER IS ONLINE
    Guys tanong ko lang gano katagal nyo inaral yung basic ng VBA ?

    Dati yong bihira pa ang internet, matagal din siguro mga 2 weeks. At kailangan ang maraming exercises.

    Ngayon sandali na lang, marami ka nang makikitang examples na similar sa gusto mo.
    But it all started in using excel.
  • Dati yong bihira pa ang internet, matagal din siguro mga 2 weeks. At kailangan ang maraming exercises.

    Ngayon sandali na lang, marami ka nang makikitang examples na similar sa gusto mo.
    But it all started in using excel.


    Thanks for the info , may onting knowledge naman ako sa excel , try ko lang i explore tong vba mukhang kakailanganin ko kasi :)
  • Question sirs baka may makatulong. May access database ako, pano gawing source yun ng Excel? Bale gagawa ako ng user form na may filter ng dates. Tapos based dun sa dates entered, yun lang yung maeexport from Access/ Thanks!
  • sir ram, thank ulit sa mga tulong mo! sa uulitin :)
  • migsvill Send Message View User Items on July 22, 2015 12:31 PM
    Question sirs baka may makatulong. May access database ako, pano gawing source yun ng Excel? Bale gagawa ako ng user form na may filter ng dates. Tapos based dun sa dates entered, yun lang yung maeexport from Access/ Thanks!

    Export data to excel from access.
    <click here for link>
  • Visit <click here for link>
  • Mga Bossing ask lang po sana Paano gawin sa excel to?
    Macro code or simple formula will do.
    Help please. Ito po need ko mapalabas
    if nag input po ako sa isang cell A1 or textbox ng amount na
    1200 lalabas po sana sa cell B1 or isang textbox is 7.5.
    Need po help... Thanks po sa makakatulong.

    1-1,000.00 5.00
    1,000.01- 1,500.00 7.50
    1,500.01 - 2,000.00 10.00
    2,000.01 - 2,500.00 12.50
    2,500.01 - 3,000.00 15.00
    3,000.01 - 3,500.00 17.50
    3,500.01 - 4,000.00 20.00
    4,000.01 - 4,500.00 22.50
    4,500.01 - 5,000.00 25.00
    5,000.01 - 5,500.00 27.50

    -- edited by Zendrix on Aug 14 2015, 01:53 PM
  • @Zendrix

    Like this one po?
    External Image


    Vlookup reference on the right side :D

    -- edited by channelsurfer on Aug 14 2015, 02:34 PM
  • @channelsurfer

    Thanks sir... hehehehe di ko rin tinigilan kanina yan. nakuha ko rin using lookup formula lang.. almost same din tayo sa vlookup mo. thanks bro.

Who's Online

660 active users within the last minute, 319 members, 341 guests.
Our newest member is code2610
Click here to see online members.

Browse Items

More »

Search TipidPC


New Want to Buys

Active Items for Sale

Active Want to Buys