Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Hope it helps
Singapore|20|College student
Need help in VBA (Word & Excel) urgently!?
For those that are familiar with VBA, I am looking to create a macro that transfers data from WORD to EXCEL.
However, can MACRO handle these tasks or is it just better to sieve these information personally (im looking at 200 over word pages)
MICROSOFT WORD MACRO:
(1) How do I find a string of word and return a value associated with a word?
E.g. Number of Chickens: 17
Number of Eggs: 13
Farm: Arizona
(I need 2 variables, CHICKEN & FARM)
(2) I need to fill up a tables with 2 variables, CHICKEN & FARM. However, the FARM(X) must correspond
to a correct value of CHICKEN(Y). Which MACRO function should I use and define?
E.g.
X1= Arizona, Y1= 17
X2= New York, Y2=15
EXCEL
(3) After porting those 2 variables into excel, I need to compare with another sheet with variables X and Y.
In this case, Sheet 2 is missing New york.
How do I ask excel to run a macro to loop every cell to check whether New York is in Sheet 2?
E.g.
Sheet 1 (data from WORD document)
Cell A1= Arizona, cell B1=17
Cell A2= New york, cell B2=15
Sheet 2 (my own reference sheet)
Cell A1= Arizona, cell B1=17
Cell A2= Texas, cell B1=34
(4) How do I run another macro to CHECK whether A1=Arizona AGREES with B1=17 VALUE in both
sheets?
Thanks in advance!!
3 AnswersSoftware3 years agoHelp with AhyiPin ID(KSSN)?
Trying to play a korean game... i found a KSSN list and names to register for Ahyipin... but there is the message that say my ahyipin ID is invalid or something... what do i do? I tried many combination of words,numbers of 8-20 charc but still unable to create account .. this is the message i received : http://gifti.me/image/oyG
2 AnswersVideo & Online Games7 years agoWho is this Korean STAR?
I came across this picture... and saved it without remembering who she is... I want to know her name!! http://gifti.me/image/Y3w
Thanks!
1 AnswerCelebrities7 years agoBallerina Spin With double Sub-machineguns?
So... out of the blue, I have this crazy idea. Can anyone try to film spinning while firing 2 SMGs with high speed camera? I bet it will be cool
1 AnswerOther - Games & Recreation7 years agoPC Games like final fantasy XV?
Have you guys seen the latest final fantasy XV trailer coming to XBOX one or PS4? Action pack and epic. I was wondering if there are any similar games(genre: fighting,sword,ect) already on PC? Thanks in advance
1 AnswerVideo & Online Games8 years agodoes voltage increase if one appliance stop working in a parallel circuit?
There is two heaters arranged in parallel in the circuit and supplied by 240V A.C supply. Note that the circuit does not use transformer so power will be loss over long distances when supplying energy to the heaters.
So my question is : does voltage increase or decrease? (it cannot remain same due to power loss)
3 AnswersEngineering8 years agoLeague Of Legends CHAMPIONS?
What are the viable champions for ADC and Top lane in S3-S4?
2 AnswersVideo & Online Games8 years agoWhat gives bar magnet its magnetic property ( a north pole) ?
Has it got to do with the magnetic orientation of electrons ?
2 AnswersPhysics8 years agoLogarithm Contradiction?
Suppose a function, ln((T-20)/-38)) where (t-20) is negative,
By logarithm rule, we can express this function as ln(T-20)-ln(-38). However, we know that ln of a negative number is undefined. So is there any special rule of why we cant express it like that or is it just pure contradiction
2 AnswersMathematics8 years agoReq: Sakurasou no Pet na Kanojo Light Novel?
Hey there! I am wondering if there are any English translation of the LN of sakurasou for volumes 7 ~9 available...
It would be kind if you can give me the link of the website or file to download it... In any case here is my email: kyoshire@gmail.com . I would greatly appreciate if anyone can help me ^^
1 AnswerComics & Animation8 years agoHow to find the endpoint of a titration?
Suppose i need to neutralize sodium hydroxide and nitric acid in the equation
NaOH+HNO3->NaNo3+H2o
the concentration of sodium hydroxide was 0.1mol/dm^3 and the concentration of nitric acid was 7.88g/dm^3. I am to titrate 25.0cm^3 of acid with an unknown volume of the base using screened methyl orange indicator to find the end point
Is there any formula to calculate the end point of the reaction and to find the unknown volume of base?
Btw it was a real experiment i did but had inaccurate volume of the base so i was wondering if there is a method to find a more accurate answer. i found that 30.9cm^3 of NaOH was needed but the actual ans was 31.5cm^3..
1 AnswerChemistry8 years agoChanging a non linear graph to a linear graph?
Consider a situation where you have to compare the period of a pendulum(T) against its length(l) If a graph is plotted, we will obtain a curve(parabola)(l increases,T decreasingly increase) If you plot (T^2) against l, you will obtain a straight line graph, which lead us to conclude that T^2 is directly proportionate to l. My question is , when do you need to square a variable to make a curve to a linear graph and why do you get a linear graph ?
2 AnswersMathematics8 years agoLet P(x) be a polynomial of degree 2010.Suppose P(n)=n/(1+n) for all n = 0,1,2...,2010. Find P(2012)?
what the..
1 AnswerMathematics9 years agowhat are the products of reaction between (CH3NH3)+(aq) and HCl(aq)?
and what is the gas produce when (CH3NH3)+(aq) is added to ammonium chloride?
2 AnswersChemistry9 years agoWhy does some ionic substance have higher melting point than other?
Also, does difference in electronegativity of atoms in ionic substance affect its melting/boiling point?
1 AnswerChemistry9 years agoI came across this equation that i do not understand(chemistry)?
I am a 7th grader,and came across this equation.
Example of anions:
CO32-,CL-,I-,NO3-,SO4-2,OH-
may i know what is this equation and what is anions about?
2 AnswersChemistry1 decade agoDuring osmosis,a higher concentration to a lower concentration gradient occurs.But bathing,why do we lose H20?
When we lose water it causes to shrink but the bath tub contains a higher concentration gradient then to our cell why do we lose water then?
2 AnswersBiology1 decade ago