hulika

Author Topic: MS Excel users thread  (Read 29587 times)

Offline trxter41

  • Philmusicus Addictus
  • *****
Re: MS Excel users thread
« Reply #25 on: May 21, 2011, 06:53:33 AM »
i havent found anything of substance on codeproject.org. how about using this one: https://chrome.google.com/webstore/detail/deckhobdafgddaglbaokimbcjjdikago

i'll download this at home and check out the sample code for VBA: http://wiki.imacros.net/Sample_Code
« Last Edit: May 21, 2011, 06:56:56 AM by trxter41 »

Offline mandarin

  • Veteran Member
  • ****
Re: MS Excel users thread
« Reply #26 on: May 25, 2011, 01:55:16 AM »
i havent found anything of substance on codeproject.org. how about using this one: https://chrome.google.com/webstore/detail/deckhobdafgddaglbaokimbcjjdikago

i'll download this at home and check out the sample code for VBA: http://wiki.imacros.net/Sample_Code

looks promising.. check out the forum links for discussions on how to use the tool :)

best of luck

Offline electronictokwa

  • Philmusicus Addictus
  • *****
Re: MS Excel users thread
« Reply #27 on: June 08, 2011, 11:57:05 PM »
May nakasubok na ba kumuha ng data from an excel file to SQL?

Offline rommelism

  • Senior Member
  • ***
Re: MS Excel users thread
« Reply #28 on: June 15, 2011, 06:49:33 AM »
Try this website:

http://www.free-training-tutorial.com/charts-graphs.html

It will give you step by step video guide for basic application of Ms Excel.
« Last Edit: June 15, 2011, 06:53:10 AM by rommelism »

Offline mandarin

  • Veteran Member
  • ****
Re: MS Excel users thread
« Reply #29 on: June 15, 2011, 09:15:23 PM »
May nakasubok na ba kumuha ng data from an excel file to SQL?

when you say SQL do you mean ms sql? merong data extraction wizard doon

assuming na properly formatted yung data ng excel, dapat walang issue to extract.

please be more specific so we can further discuss

regards


Offline electronictokwa

  • Philmusicus Addictus
  • *****
Re: MS Excel users thread
« Reply #30 on: December 28, 2011, 10:31:32 PM »
May marunong ba mag link ng MS Access database at Excel dito? Bale depende sa input sa excel, may kukuning list sa Access.

Offline kyle travers

  • Forum Fanatic
  • ****
Re: MS Excel users thread
« Reply #31 on: December 29, 2011, 10:33:31 PM »
eto gusto ko matutunan, pero everytime na try ko na pag araalan eh ayoko na agad, ehehehe

Offline electronictokwa

  • Philmusicus Addictus
  • *****
Re: MS Excel users thread
« Reply #32 on: December 29, 2011, 10:35:25 PM »
eto gusto ko matutunan, pero everytime na try ko na pag araalan eh ayoko na agad, ehehehe

Simple lang kasi mga alam kong tools na nagawa ko sa Excel. May ginagawa kasi kaming project sa Excel na medyo mahirap ahehe.

Offline cayester

  • Veteran Member
  • ****
Re: MS Excel users thread
« Reply #33 on: December 30, 2011, 11:18:34 PM »
masarap mag excel  :) mag vba, mag MS Access napakadali ng buhay  :-D
Reds for the blood of all living things in the world. Gold is for all of the treasures in the world that people cherish. Green is for the earth that people walk on.

Offline electronictokwa

  • Philmusicus Addictus
  • *****
Re: MS Excel users thread
« Reply #34 on: December 31, 2011, 12:55:33 AM »
masarap mag excel  :) mag vba, mag MS Access napakadali ng buhay  :-D

Ahehehe puede nio po ako tulungan sa Access?

Offline cayester

  • Veteran Member
  • ****
Re: MS Excel users thread
« Reply #35 on: December 31, 2011, 02:15:08 AM »
Ahehehe puede nio po ako tulungan sa Access?

go sir.. regarding what? pm pm  :-D
Reds for the blood of all living things in the world. Gold is for all of the treasures in the world that people cherish. Green is for the earth that people walk on.

Offline electronictokwa

  • Philmusicus Addictus
  • *****
Re: MS Excel users thread
« Reply #36 on: December 31, 2011, 05:05:11 AM »
go sir.. regarding what? pm pm  :-D

PM Sent!

Offline spadettie

  • Philmusicus Addictus
  • *****
Re: MS Excel users thread
« Reply #37 on: January 02, 2012, 09:18:18 PM »
workforce analyst din ako... excel din kakampi ko sa trabaho... :D
caye!!

Offline electronictokwa

  • Philmusicus Addictus
  • *****
Re: MS Excel users thread
« Reply #38 on: January 03, 2012, 12:26:34 AM »
workforce analyst din ako... excel din kakampi ko sa trabaho... :D
caye!!

Ayun oh!!! Baka may sample excel files ka pang schedule sir!!! PM naman!  :)

Offline heyman

  • Philmusicus Addictus
  • *****
Re: MS Excel users thread
« Reply #39 on: January 18, 2012, 03:28:45 PM »
di ako marunong ng macro... ano ba to? may mga record record pa sa help di ko rin naman maintindihan. sana may makatulong in laymans term
yada yada yada.....

Offline cayester

  • Veteran Member
  • ****
Re: MS Excel users thread
« Reply #40 on: January 18, 2012, 09:36:52 PM »
di ako marunong ng macro... ano ba to? may mga record record pa sa help di ko rin naman maintindihan. sana may makatulong in laymans term

what do you need hlp with sir? :)
Reds for the blood of all living things in the world. Gold is for all of the treasures in the world that people cherish. Green is for the earth that people walk on.

Offline electronictokwa

  • Philmusicus Addictus
  • *****
Re: MS Excel users thread
« Reply #41 on: January 18, 2012, 09:41:47 PM »
di ako marunong ng macro... ano ba to? may mga record record pa sa help di ko rin naman maintindihan. sana may makatulong in laymans term

Anu ba project mo sir?

@Caye! Di ko pa natatapos yung Access dbase ahehehe sobrang busy eh.

Offline heyman

  • Philmusicus Addictus
  • *****
Re: MS Excel users thread
« Reply #42 on: January 18, 2012, 09:49:27 PM »
Anu ba project mo sir?

@Caye! Di ko pa natatapos yung Access dbase ahehehe sobrang busy eh.

i work sa isang engineering desgn firm gusto ko gumawa ng spreadsheet na kapag isang button lang iclick mo e automatic lalabas na sagot. alam ko may ganun but sabi kelangan imacro kaso problem d namn ako marunong nun.
yada yada yada.....

Offline electronictokwa

  • Philmusicus Addictus
  • *****
Re: MS Excel users thread
« Reply #43 on: January 18, 2012, 10:16:30 PM »
i work sa isang engineering desgn firm gusto ko gumawa ng spreadsheet na kapag isang button lang iclick mo e automatic lalabas na sagot. alam ko may ganun but sabi kelangan imacro kaso problem d namn ako marunong nun.

Depende kasi sa data input sir eh kung anu ang gusto mo na ilalabas na sagot. May sample file ka ba?

Offline cayester

  • Veteran Member
  • ****
Re: MS Excel users thread
« Reply #44 on: January 18, 2012, 10:44:31 PM »
Anu ba project mo sir?

@Caye! Di ko pa natatapos yung Access dbase ahehehe sobrang busy eh.

hey ok lang yan no rush...may bopols akong ginawa...gumagawa ako ng new file for performance report...after 1 wk of cleaning the data.... ayun nag crash ang pc wala akong na save  :-o
Reds for the blood of all living things in the world. Gold is for all of the treasures in the world that people cherish. Green is for the earth that people walk on.

Offline electronictokwa

  • Philmusicus Addictus
  • *****
Re: MS Excel users thread
« Reply #45 on: January 19, 2012, 02:48:55 AM »
hey ok lang yan no rush...may bopols akong ginawa...gumagawa ako ng new file for performance report...after 1 wk of cleaning the data.... ayun nag crash ang pc wala akong na save  :-o

Waaaaaaah!  :eek:

Offline influence

  • Philmusicus Noobitus
  • *
Re: MS Excel users thread
« Reply #46 on: January 19, 2012, 12:31:19 PM »
workforce analyst din ako... excel din kakampi ko sa trabaho... :D
caye!!

yun oh, si dett oh! hehe! katuwang talaga nating mga workforce ang excel.
kulang nalang kahit paglabas natin ng office nakikita parin natin yung grid lines e.

Offline perfect_chemistry02

  • Senior Member
  • ***
Re: MS Excel users thread
« Reply #47 on: February 16, 2012, 07:38:10 PM »
Dito sa school, we use excel for stuctural computations.  :) and we take exams open laptops :-o
"Winner winner chicken dinner"

Successful transactions: sir digs_boom, sir jeff, sir diver, sir fruitsoda, sir strawb3rrycake, zoomg2.1u seller, zoom gfx-4 seller.

Offline Shred_22

  • Philmusicus Addictus
  • *****
Re: MS Excel users thread
« Reply #48 on: January 21, 2015, 05:35:23 PM »
pa up lang.. baka matulungan nyo ko nafrustrate na ko eh hahaha


Offline mandarin

  • Veteran Member
  • ****
Re: MS Excel users thread
« Reply #49 on: February 01, 2015, 01:04:34 AM »
pa up lang.. baka matulungan nyo ko nafrustrate na ko eh hahaha




I am assuming that the 2nd parameter (agents) is a named range -- please post the exact range (including the worksheet name)

One more thing, in vlookup you always use the leftmost column as the "matching" column

hope this helps