$$Excel-Macros$$ Urgent required PL/SQL Developer - LA, CA
*Please respond to gurjant.si...@damcosoft.com Position: Oracle PL/SQL DeveloperLocation: LA, CADuration: 6+ Months* *Need local candidates* JD: Oracle PL/SQL (with APEX understanding) Lead Requirement: •Relevant 6+ experience in SQL, PLSQL, Informatica & Good Unix Scripting. •Experience in developing Functions, Procedures, Packages, Triggers and other DB Objects. •Excellent programming skills in SQL & PL/SQL, preferably Oracle Certified •Experience with Stored Procedures, Functions and Triggers to interface application with database system. •Experience with complete Software Development Life Cycle (SDLC). •Experience in ETL (Informatica) / Data Warehouse architecture and code •Understanding of developing applications using Oracle Apex 4.2 •Should able to understand Banking system/processes and data flow •Can work independently, lead and mentor the team Excellent communication, interpersonal, analytical skills and strong ability to perform as an individual Thanks and Regards, Gurjant Singh - (Gary) Technical Recruiter +1 212 389 9503 ext 208 E: gurjant.si...@damcosoft.com *NY Office: *112 W 34th St, 18th Floor, New York, NY 10120 *NJ Office: *894 Green Street, Suite B, Iselin, NJ 08830 Corporate: www.damcosoft.com *[image: Description: cid:image002.jpg@01CEDAE3.C3BE19D0]* *[image: Description: cid:image006.jpg@01CEDAE5.F56ED350]* *P** Please consider the planet before printing | Switch off as you go |**q**Recycle always |* *Your child deserves a better world* *CONFIDENTIALITY NOTICE:** This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Urgent required Java Developer - Seattle WA
*Please respond to gurjant.si...@damcosoft.com * *Position: Java DeveloperLocation: Seattle WA Duration: 6+ Months* JD: Most Imp---Exposure to GIT (Strongly advise to have) - Exposure to AWS Exposure in AWS and GIT would help. Please note: Must Have skills: - Core Java & Concepts - SOA & Web services (REST / SOAP) - Web concepts (JSP/Servlets) - ORM - Maven ‘Nice to have’ Skills, Abilities, Certification, etc. - Exposure to GIT (Strongly advise to have) - Exposure to AWS - Experience working in an Agile Scrum environment - Experience working with a distributed development and operations team Thanks and Regards, Gurjant Singh - (Gary) Technical Recruiter +1 212 389 9503 ext 208 E: gurjant.si...@damcosoft.com *NY Office: *112 W 34th St, 18th Floor, New York, NY 10120 *NJ Office: *894 Green Street, Suite B, Iselin, NJ 08830 Corporate: www.damcosoft.com *[image: Description: cid:image002.jpg@01CEDAE3.C3BE19D0]* *[image: Description: cid:image006.jpg@01CEDAE5.F56ED350]* *P** Please consider the planet before printing | Switch off as you go |**q**Recycle always |* *Your child deserves a better world* *CONFIDENTIALITY NOTICE:** This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Concat & lookup error
I forgot to add: saving both files in the same format (.xls, .xlsx, .xlsb) would accomplish the same result. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - > > From: veeru h >To: excel-macros@googlegroups.com >Sent: Wednesday, August 13, 2014 10:06 AM >Subject: Re: $$Excel-Macros$$ Concat & lookup error > > > >Thank you very much sir > > > > > > >On Wed, Aug 13, 2014 at 5:16 PM, Paul Schreiner wrote: > >When you "select table array from another file i.e MData Select A&B Column" >>You are selecting the entire column, which is defied along with the number of >>rows in the file. >>One file (in Excel97 Compatibility format .xls) can only deal with 65000 >>rows. >>the other file has over 1,000,000 rows. >> >>In your vlookup, specify the rows (some number beyond the maximum) like: >> >>=vlookup(j2,[MData.xlsx]Sheet1!$A$1:$B$65000,2,False) >> >>Paul >>- >>“Do all the good you can, >>By all the means you can, >>In all the ways you can, >>In all the places you can, >>At all the times you can, >>To all the people you can, >>As long as ever you can.” - John Wesley >>- >> >> >> From: veeru h >>>To: excel-macros@googlegroups.com >>>Sent: Wednesday, August 13, 2014 6:15 AM >>>Subject: $$Excel-Macros$$ Concat & lookup error >>> >>> >>> >>>Sir, >>>I created a Macro, for entry purpose >>>for Regular Work i recieve Reg Work File daily via email >>>& send it to cosern >>> >>> >>>sample data in attached file >>> >>>1) inserted 1 column after G Column & concatenate G & H Column in to I >>> its in Text then Converted to number. >>>2) again i insert another column after I Column i.e J >>>3) i put formula =vlookup(j2,select table array from another file i.e MData >>>Select A&B >>> >>> >>>Column,2,0) >>> >>> >>>but its showing error: Bcoz >>> >>> >>> RegWork file Column upto IV & Rows upto655536 >>>Mdata file Column upto XFD & Rows upto 1048576 >>> >>> >>>is any Solution ( without manual copy, & paste to other workbook) >>>convert file format to excel workbook(in Macro Button) >>> >>> >>> >>> >>>Regards: >>>Veeresh >>> >>> -- >>>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >>>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>https://www.facebook.com/discussexcel >>> >>>FORUM RULES >>> >>>1) Use concise, accurate thread titles. Poor thread titles, like Please >>>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >>>not get quick attention or may not be answered. >>>2) Don't post a question in the thread of another member. >>>3) Don't post questions regarding breaking or bypassing any security measure. >>>4) Acknowledge the responses you receive, good or bad. >>>5) Jobs posting is not allowed. >>>6) Sharing copyrighted material and their links is not allowed. >>> >>>NOTE : Don't ever post confidential data in a workbook. Forum owners and >>>members are not responsible for any loss. >>>--- >>>You received this message because you are subscribed to the Google Groups >>>"MS EXCEL AND VBA MACROS" group. >>>To unsubscribe from this group and stop receiving emails from it, send an >>>email to excel-macros+unsubscr...@googlegroups.com. >>>To post to this group, send email to excel-macros@googlegroups.com. >>>Visit this group at http://groups.google.com/group/excel-macros. >>>For more options, visit https://groups.google.com/d/optout. >>> >>> >>> >>-- >>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>https://www.facebook.com/discussexcel >> >>FORUM RULES >> >>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not >>get quick attention or may not be answered. >>2) Don't post a question in the thread of another member. >>3) Don't post questions regarding breaking or bypassing any security measure. >>4) Acknowledge the responses you receive, good or bad. >>5) Jobs posting is not allowed. >>6) Sharing copyrighted material and their links is not allowed. >> >>NOTE : Don't ever post confidential data in a workbook. Forum owners and >>members are not responsible for any loss. >>--- >>You received this message because you are subscribed to the Google Groups "MS >>EXCEL AND VBA MACROS" group. >>To unsubscribe from this group and stop receiving emails from it, send an >>email to excel-macros+unsubscr...@googlegroups.com. >>To post to this group, send email to excel-macros@googlegroups.com. >>Visit this group at http://groups.google.com/group/excel-macros. >>For more options, visit h
Re: $$Excel-Macros$$ Concat & lookup error
Thank you very much sir On Wed, Aug 13, 2014 at 5:16 PM, Paul Schreiner wrote: > When you "select table array from another file i.e MData Select A&B Column" > You are selecting the entire column, which is defied along with the number > of rows in the file. > One file (in Excel97 Compatibility format .xls) can only deal with 65000 > rows. > the other file has over 1,000,000 rows. > > In your vlookup, specify the rows (some number beyond the maximum) like: > > =vlookup(j2,[MData.xlsx]Sheet1!$A$1:$B$65000,2,False) > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* veeru h > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, August 13, 2014 6:15 AM > *Subject:* $$Excel-Macros$$ Concat & lookup error > > Sir, > I created a Macro, for entry purpose > for Regular Work i recieve Reg Work File daily via email > & send it to cosern > > sample data in attached file > > 1) inserted 1 column after G Column & concatenate G & H Column in to I >its in Text then Converted to number. > 2) again i insert another column after I Column i.e J > 3) i put formula =vlookup(j2,select table array from another file i.e > MData Select A&B > > Column,2,0) > > but its showing error: Bcoz > > RegWork file Column upto IV & Rows upto655536 > Mdata file Column upto XFD & Rows upto 1048576 > > is any Solution ( without manual copy, & paste to other workbook) > convert file format to excel workbook(in Macro Button) > > > Regards: > Veeresh > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > >-- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confid
Re: $$Excel-Macros$$ Values from INDIRECT not staying after file closes
It would take me an hour or more to put together an example that I HOPE would
look like yours before I could even begin to test it.
Then I'd have to hope it matches your conditions.
If it DIDN'T respond the same way, I wouldn't know if it was because it was MY
samples, or a problem with yours.
So,
Could you send me a sample set of files?
you don't have to send all 100.
alpha, beta and gamma (or George, Paul and Ringo) would suffice.
I realize the data may be sensitive, so you may have to "change the names to
protect the innocent".
But unless I can see what YOUR situation is, I'd only be testing my
INTERPRETATION of your situation...
know what I mean?
I'd be glad to take a look.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
>
> From: Chris
>To: excel-macros@googlegroups.com
>Sent: Tuesday, August 12, 2014 8:34 PM
>Subject: $$Excel-Macros$$ Values from INDIRECT not staying after file closes
>
>
>
>
>Hi,
>
>I have a rather strange problem: I have a master file with INDIRECT worksheet
>functions to three different files, alpha, beta and gamma (for simplicity's
>sake, the actual project has about 100 files). Without opening these three
>files, the cells with the INDIRECT calls in the master workbook obviously show
>a #REF error because the files they link to are not open. I use the following
>macro to open all three files in the folder "demofolder" and close them:
>
>Sub Open_All_Files()
>
>Dim wbOpen As Workbook
>Dim wbNew As Workbook
>Const strPath As String = "C:\Users\myuser\Desktop\demofolder\"
>Dim strExtension As String
>
>ChDir strPath
>strExtension = Dir("*.xlsx")
>
> Do While strExtension <> ""
> Set wbOpen = Workbooks.Open(strPath & strExtension)
>
> With wbOpen
> .Close SaveChanges:=False
> End With
>
> strExtension = Dir
> Loop
>
>End Sub
>
>The macro works fine, it opens and closes all three workbooks. However, and
>here's the issue, only the cells with the INDIRECT call to the very last
>workbook opened contain values now. Even though I opened two workbooks before,
>the INDIRECT worksheet functions still show #REF. And here's what's really
>bizarre - when I use the debugger and step through the code line by line until
>all three workbooks have been opened and closed, then all cells using INDIRECT
>contain values. I'm sure it's explainable - would love to know what causes
>this phenomenon. Also, would love to know how to fix it. I added a WAIT call
>prior to .Close because I thought that the workbook opens and then closes too
>fast but that didn't fix the issue.
>
>Thank you for all you help. Appreciate it a lot.
>Christoph
>
>
--
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>https://www.facebook.com/discussexcel
>
>FORUM RULES
>
>1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
>quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
>
>NOTE : Don't ever post confidential data in a workbook. Forum owners and
>members are not responsible for any loss.
>---
>You received this message because you are subscribed to the Google Groups "MS
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data i
Re: $$Excel-Macros$$ Concat & lookup error
When you "select table array from another file i.e MData Select A&B Column" You are selecting the entire column, which is defied along with the number of rows in the file. One file (in Excel97 Compatibility format .xls) can only deal with 65000 rows. the other file has over 1,000,000 rows. In your vlookup, specify the rows (some number beyond the maximum) like: =vlookup(j2,[MData.xlsx]Sheet1!$A$1:$B$65000,2,False) Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: veeru h >To: excel-macros@googlegroups.com >Sent: Wednesday, August 13, 2014 6:15 AM >Subject: $$Excel-Macros$$ Concat & lookup error > > > >Sir, >I created a Macro, for entry purpose >for Regular Work i recieve Reg Work File daily via email >& send it to cosern > > >sample data in attached file > >1) inserted 1 column after G Column & concatenate G & H Column in to I > its in Text then Converted to number. >2) again i insert another column after I Column i.e J >3) i put formula =vlookup(j2,select table array from another file i.e MData >Select A&B > > >Column,2,0) > > >but its showing error: Bcoz > > > RegWork file Column upto IV & Rows upto655536 >Mdata file Column upto XFD & Rows upto 1048576 > > >is any Solution ( without manual copy, & paste to other workbook) >convert file format to excel workbook(in Macro Button) > > > > >Regards: >Veeresh > > -- >Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES > >1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get >quick attention or may not be answered. >2) Don't post a question in the thread of another member. >3) Don't post questions regarding breaking or bypassing any security measure. >4) Acknowledge the responses you receive, good or bad. >5) Jobs posting is not allowed. >6) Sharing copyrighted material and their links is not allowed. > >NOTE : Don't ever post confidential data in a workbook. Forum owners and >members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To unsubscribe from this group and stop receiving emails from it, send an >email to excel-macros+unsubscr...@googlegroups.com. >To post to this group, send email to excel-macros@googlegroups.com. >Visit this group at http://groups.google.com/group/excel-macros. >For more options, visit https://groups.google.com/d/optout. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: VBA questions
thanks.. to Kapil Gupta and Pramod Singh for nice questions and answers. I have seen VBA Questions in Q4 transfer data in word but it will transfer word as excel.. is it possible to transfer as image. thanks and regards. Chintan On Sunday, August 3, 2014 11:51:07 PM UTC+5:30, kapil Gupta wrote: > > Hello, > > Please solve this VBA Question paper As soon as possible. Please > find the attached files and check. > > > Regards, > Kapil Gupta > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Concat & lookup error
Sir, I created a Macro, for entry purpose for Regular Work i recieve Reg Work File daily via email & send it to cosern sample data in attached file 1) inserted 1 column after G Column & concatenate G & H Column in to I its in Text then Converted to number. 2) again i insert another column after I Column i.e J 3) i put formula =vlookup(j2,select table array from another file i.e MData Select A&B Column,2,0) but its showing error: Bcoz RegWork file Column upto IV & Rows upto655536 Mdata file Column upto XFD & Rows upto 1048576 is any Solution ( without manual copy, & paste to other workbook) convert file format to excel workbook(in Macro Button) Regards: Veeresh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Reg Work.xls Description: MS-Excel spreadsheet MData.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Calculating working hours between 2 days with break time
hi can you share a sample data in excel sheet. Thanks On Wed, Aug 13, 2014 at 1:57 PM, son nguyen wrote: > Dear Expert. > > I faced on problem while calculating working hours between 2 time (maybe > there is diff. day).Detail as below : > > A1 : Begin time. > B1 : Finish time > C1: Begin time day : 8 AM > D1 : Finish time day : 4:30 PM > E1:Begin break time > F1:Finish break time > > How to use any formula within excel -2003 to get result. > > -- > Best Regards > Son > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Calculating working hours between 2 days with break time
Dear Expert. I faced on problem while calculating working hours between 2 time (maybe there is diff. day).Detail as below : A1 : Begin time. B1 : Finish time C1: Begin time day : 8 AM D1 : Finish time day : 4:30 PM E1:Begin break time F1:Finish break time How to use any formula within excel -2003 to get result. -- Best Regards Son -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: .xls to .vcf vard format
hiii i face this problem but i download excel to vcard converter like http://excel-to-vcard-converter.blogspot.in/ this convert all excel file to vcard and solve my problem On Sunday, October 7, 2012 9:24:44 PM UTC+5:30, V S Rawat g wrote: > > http://www.ehow.com/how_5708670_convert-excel-mailing-list-vcard.html > > the page suggests that we can directly save an xls file by choosing > vcard format (.vcf) by selecting that in File Type list in save as. > > But my 2013 doesn't show .vcf - vcard file type at all. > > What gives. ehow page misguiding. > > Anyway. How to convert xls file to .vcf file. > > Any batch convertor if there are 100s of xls files to convert thus? > > Thanks. > -- > Rawat > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
