Dear sandeep/Mr. excel,
Please find attached Sheet with Example.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Fri, Oct 21, 2011 at 11:13 AM,
Hi Sean
you can use it will all xls or all xlsx
On Fri, Oct 21, 2011 at 9:20 AM, Sean flanagan.se...@gmail.com wrote:
Hi sir, and thank you for your assistance.
I like your macro very much. Sadly, it does not bring joy. However,
it has helped me to discover that the problem is not with
Thanks sam, a simple formula works.
thanks again. Nemi
On Oct 20, 7:18 pm, Sam Mathai Chacko samde...@gmail.com wrote:
Formula =OFFSET(INDEX($H$1:$H$105,MATCH($A2,$H$1:$H$105,0)),$B2,$C2)
On Thu, Oct 20, 2011 at 4:13 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Don't think we
Sure Ayush,
Would make sure of it.
Thanks,
Anish
On Thu, Oct 20, 2011 at 10:48 PM, Ayush Jain jainayus...@gmail.com wrote:
Noorain, Imaraan, Anish, Sam, Jayandra and rest of the group,
Please do not post or support any query on breaking password of excel vba
file.
This is against the
Hi,
I want to update a table in SQL server from an excel file. Please
advise a VBA code.
Thanks
Akhilesh Airen
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://www.excelvbamacros.com/2011/10/sort-data-on-basis-of-font-color.html
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
--
Some important
Sorry Guys By mistake i send this link on this group
On Fri, Oct 21, 2011 at 1:19 PM, ashish koul koul.ash...@gmail.com wrote:
http://www.excelvbamacros.com/2011/10/sort-data-on-basis-of-font-color.html
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before
On Fri, Oct 21, 2011 at 1:38 PM, ashish koul koul.ash...@gmail.com wrote:
Sorry Guys By mistake i send this link on this group
On Fri, Oct 21, 2011 at 1:19 PM, ashish koul koul.ash...@gmail.comwrote:
http://www.excelvbamacros.com/2011/10/sort-data-on-basis-of-font-color.html
--
Try this
http://www.excelfox.com/forum/showthread.php?66-Execute-SQL-From-Excel-(VBA)
Regards,
Sam Mathai Chacko (GL)
On Oct 21, 12:43 pm, airen airen1...@gmail.com wrote:
Hi,
I want to update a table in SQL server from an excel file. Please
advise a VBA code.
Thanks
Akhilesh Airen
--
Hi friend, I use a lot this simple example of a loop until with an inputbox.
2011/10/21 NOORAIN ANSARI noorain.ans...@gmail.com
Dear sandeep/Mr. excel,
Please find attached Sheet with Example.
--
Thanks regards,
Noorain Ansari
Please protect the sheet, and use 'Allow Users To Edit Ranges' option.
Your format will remain, and users will not be able to edit, but you
will be able to add data.
Regards,
Sam Mathai Chacko (GL)
On Oct 21, 10:45 am, Ayush Jain jainayus...@gmail.com wrote:
Hello members,
Thanks for your
Here's a link too
http://excelhints.com/2008/10/21/protect-cell-formats/
Regards,
Sam
On Oct 21, 3:06 pm, GoldenLance samde...@gmail.com wrote:
Please protect the sheet, and use 'Allow Users To Edit Ranges' option.
Your format will remain, and users will not be able to edit, but you
will be
Esteemed Group,
I would like to know if there is a formula that would allow you to type ian
in a cell and have it look up and find Giant Wing in a list of unique
words. Please see the attached example.
Thank you very much for your help.
John
--
VLOOKUP(*H4*,E:E,1,0)
On Fri, Oct 21, 2011 at 4:49 PM, John A. Smith johnasmit...@gmail.comwrote:
Esteemed Group,
I would like to know if there is a formula that would allow you to type
ian in a cell and have it look up and find Giant Wing in a list of
unique words. Please see the
Thank you Ashish for your quick and very enlightening response.
John
On Fri, Oct 21, 2011 at 7:28 AM, ashish koul koul.ash...@gmail.com wrote:
VLOOKUP(*H4*,E:E,1,0)
On Fri, Oct 21, 2011 at 4:49 PM, John A. Smith johnasmit...@gmail.comwrote:
Esteemed Group,
I would like to know if there
Dear John,
Ashish's Solution is Fentastic.
Please see attached sheet with another options.
On Fri, Oct 21, 2011 at 4:49 PM, John A. Smith johnasmit...@gmail.comwrote:
Esteemed Group,
I would like to know if there is a formula that would allow you to type
ian in a cell and have it look up
Noorain,
Thank you, I love using offset and never tried the wild card approach. Two
excellent alternatives, thank you.
John
On Fri, Oct 21, 2011 at 7:42 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear John,
Ashish's Solution is Fentastic.
Please see attached sheet with another
THANK YOU VERY MUCH
On Oct 18, 8:11 am, Bé Trần Văn betnmtdongna...@gmail.com wrote:
2011/10/17 NOORAIN ANSARI noorain.ans...@gmail.com
Please share your worksheet with us.
On Mon, Oct 17, 2011 at 6:44 AM, ajjw123 ajjw...@gmail.com wrote:
can anybody help me with auto complete
format Unlock all cells user is allowed to accessformat your cellPROTECT the
sheet to allow values
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Ayush Jain
Sent: Friday, October 21, 2011 12:45 AM
To: excel-macros
Subject: $$Excel-Macros$$ Restrict cell format not values
Hello
May be best to post your code and even your file.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Sean
Sent: Thursday, October 20, 2011 3:38 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or
Ok, I figured out how to set it to a blank line by changing the first
value in the CHOOSE function to instead of A7. I would still
really like a plain text explanation of the formula for my own
education. I think I have a basic understanding of it, but I doubt I
could recreate this, or
Wow, that is really great. I have two further requests... can you
walk me through the formula used in column C so I can learn? I
haven't ever seen or used a few of those functions (lookup, as opposed
to vlookup or hlookup, or Choose).
Also, as I don't understand the logic yet, how can I modify
Sub extractstring()
On Error Resume Next
For Each c In Range(i1:i2)
f1 = InStr(c, )) + 1
f2 = InStr(c, Enrol)
c.offset(,1)=Mid(c, f1, f2 - f1)
Next
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: karan 1237
Sent: Friday, October 21, 2011 3:33 AM
To:
You can use the SQLJuicer sub-routine from Mechanic from Excel. Just change
the connection strings. For that, you can go to www.connectionstrings.com
Regards,
Sam Mathai Chacko (GL)
On Fri, Oct 21, 2011 at 1:13 PM, airen airen1...@gmail.com wrote:
Hi,
I want to update a table in SQL server
The problem with any of the approaches suggested (including mine) is that
one can copy a cell with a different format, and have it copied to the
unlocked cells. You could force the user NOT to copy a cell by probably
unchecking the select locked cells option, but that would still not be fool
Although vastly off topic, Excel 2010 is Excel 14. MS skipped one number 13,
probably because of all the beliefs associated with that number :D
Regards,
Sam Mathai Chacko (GL)
On Fri, Oct 21, 2011 at 6:26 PM, dguillett1 dguille...@gmail.com wrote:
May be best to post your code and even your
please send the example...
On Fri, Oct 21, 2011 at 1:56 PM, karan 1237 karan1...@gmail.com wrote:
Dear All,
Need your help to extract some specific text.
Exam.
Govt I Grade College, Pashachapur Tq Hukkeri Dist Belgaum (2007) A/S/C/
BBA. Enrol 139, Teacher 1, Principal-Dr S F Tangade.
I
if this is a fix. then use countif see the attachment
On Fri, Oct 21, 2011 at 8:51 PM, XLS S xlst...@gmail.com wrote:
please send the example...
On Fri, Oct 21, 2011 at 1:56 PM, karan 1237 karan1...@gmail.com wrote:
Dear All,
Need your help to extract some specific text.
Exam.
Govt I
Sub ExtractthruenrolSAS()
Dim ms As String
Dim c As Range
Dim f1 As Long
Dim f2 As Long
Dim lr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
On Error Resume Next
For Each c In Range(a2:a lr)
f1 = InStr(c, )) + 1
f2 = InStr(c, Enrol) + 5
c.Offset(, 1) = Mid(c, f1, f2 - f1)
Next
End Sub
Don
i think it will be better if you google all this information given by Dilip as
explaining everythign in detail is not possible so if u google all this you
will have better idea.
1. While, do while and do until are same hardly any difference.
2. for and for each is also same but for is used when
Hello Zeunasc;
I am not good in to explain something. Here is an attempt. Hope this would
help you.
A2 = Start Date, here 10/20/2011
A4 = End Date, here 10/25/2011
Basically 10/20/2011 is 40836 (40836 days after 1/1/1900)
10/25/2011 is 40841 (40841 days after 1/1/1900). If you change the
Hi
You can use the converter technology Office Converter or OMPM for office
2010.
Thanks
Regards
Abhishek
On Thu, Oct 20, 2011 at 10:21 PM, Brian brianfosterbl...@gmail.com wrote:
I have designed a number of macros in Excel 2003 and had no problems
when I upgraded to 2007. However I am
Hi Excel Experts,
We need urgent some data analyst, Please see below all description related to
job,
Interested candidate reply me with their Resume.
Experience:
2 - 4 Years
Location: Noida
Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA
Industry Type:
Hello,
I am very new to using vba in excel and i am facing this problem to
exporting specific excel cells into certain field in an access table.
I have around twenty tabs in a single spreadsheet, all containing same
format but different data.
here's the code:
Sub SelectSheets1()
Dim
Hello,
I am very new to using vba in excel and i am facing this problem to
exporting specific excel cells into certain field in an access table.
I have around twenty tabs in a single spreadsheet, all containing same
format but different data.
here's the code:
Sub SelectSheets1()
Dim
35 matches
Mail list logo