hv u tried vlookup
=VLOOKUP(C6,Sheet1!C:E,3,0)
On Sat, Sep 21, 2013 at 6:22 PM, TIWARI wrote:
> dear expert,
> I am attaching a file data of invoice value of abc ltd to copy of another
> sheet in blank invoice coloum . Pls help me urgently.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex
Welcome friend
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of KAUSHIK SAVLA
Sent: Wednesday, September 04, 2013 2:40 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help on silly problem
Dear Kaushik,
No need to close numbers in double quotes.
just simply type numbers as numbers, like Type 1 instead of "1" or -1
instead of "-1"
On Wed, Sep 4, 2013 at 2:37 PM, KAUSHIK SAVLA wrote:
> Thanks Prafull and Noorain sir.
>
>
> On Wed, Sep 4, 2013 at 2:33 PM, Prafull Jadhav
> wrote:
>
Thanks Ravi!
On Wed, Sep 4, 2013 at 2:38 PM, Ravi Kumar wrote:
> Hi,
>
> ** **
>
> ** **
>
> Here is ur solution
>
> ** **
>
> Don’t use “1” when u put number in if condition always give numbers as it
> is. There is no need to give like “-1”, “1”. Simply right -1, 1.
>
> ** **
>
> *
Hi,
Here is ur solution
Don't use "1" when u put number in if condition always give numbers as it
is. There is no need to give like "-1", "1". Simply right -1, 1.
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf
Thanks Prafull and Noorain sir.
On Wed, Sep 4, 2013 at 2:33 PM, Prafull Jadhav wrote:
>
> Remove* "" * from formula ...for number value
>
>
> On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote:
>
>> Hi Team,
>>
>> Request you to kindly provide me solution to below silly problem I am
>> facing i
=IF(A2=9,N(1),IF(A2=10,N(1),IF(A2<=6,N(-1),IF(A2=N(7),"",IF(A2=N(8),"")
On Wed, Sep 4, 2013 at 2:37 PM, NOORAIN ANSARI wrote:
> Dear Savla,
>
> Please try it
>
> **
>
>
> On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote:
>
>> Hi Team,
>>
>> Request you to kindly provide me solution to bel
Dear Savla,
Please try it
**
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote:
> Hi Team,
>
> Request you to kindly provide me solution to below silly problem I am
> facing in excel.
>
> I am trying to get sum of data range B2 to B6 in cell B8. Answer which I
> am getting is not correct, se
Remove* "" * from formula ...for number value
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote:
> Hi Team,
>
> Request you to kindly provide me solution to below silly problem I am
> facing in excel.
>
> I am trying to get sum of data range B2 to B6 in cell B8. Answer which I
> am getting is
Hi Thameem,
Suppose you have the total for everyone of the 40 sheets on cell B100. The
following formula would sum every total of the 40 sheets you have.
I guess this is what you want.
=SUM(Plan2!B100;Plan3!B100;Plan4!B100)
Best regards.
OS
2013/8/12 ashish koul
> can u share the sample fil
Template for Manpower as assigning report.
On Thursday, 29 August 2013 15:55:12 UTC+5:30, XLS S wrote:
>
> what you want?..
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Thu, Aug 29, 2013 at 2:34 PM, Dhamo dharan
> > wrote:
>
>> Dear Friends
>>
>> kindly hep me to create a manpow
what you want?..
.
Enjoy
Team XLS
On Thu, Aug 29, 2013 at 2:34 PM, Dhamo dharan wrote:
> Dear Friends
>
> kindly hep me to create a manpower assigning report.
>
> E.g:
>
> *Project name *:xx
> *Input:*
> *Per day target*:according to project name its should target val
Thanks a ton !!!
On 8/20/13, De Premor wrote:
> paste this on userform1
>
> '
> Dim Target As Range
>
> Private Sub CommandButton1_Click()
> Target.Offset(1).Select
> Unload Me
> End Sub
>
> Private Sub TextBox1_Change()
> Target = TextBox1.Text
> End Sub
>
> Privat
paste this on userform1
'
Dim Target As Range
Private Sub CommandButton1_Click()
Target.Offset(1).Select
Unload Me
End Sub
Private Sub TextBox1_Change()
Target = TextBox1.Text
End Sub
Private Sub UserForm_Activate()
Set Target = Selection
TextBox1.Text = Tar
can u share the sample file ...
On Mon, Aug 12, 2013 at 1:05 PM, thameem wrote:
> Dear all,
>
> for example I have one excel with 40 sheets, in those sheets I have one
> total r sum... I need formuale or codes, to sum all total of 40 sheets in
> one sheet...
>
> --
> Are you =EXP(E:RT) or =NOT(
Respected Cute Awsome,
You can find cracks and activation keys for download.Just google for
windows 7 activation keys or download a cracked version and install.Then
you will not receive the message.
Regards,
Vijaykumar
On Sat, Jul 27, 2013 at 4:38 PM, Excel Learn wrote:
> ** **
>
> K do one th
K do one thing go to start button->type cmd ->write click over there and
select "run as administration" then type in command prompt "slmgr -rearm",
your windows will reactivate.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Cute Awesome
Sent: S
(a) This is not a Windows help forum.
(b) What you're asking supports piracy and is probably illegal.
On Sat, Jul 27, 2013 at 3:48 PM, Cute Awesome wrote:
> I am using windows 7 i am not using genuine software for the last 2 years
> now i have message on my scree that this copy of winos is not
Thanks Ravinder :)
On Mon, Jul 22, 2013 at 4:05 PM, ravinder negi wrote:
> PFA..
> --
> *From:* Dhaval Shah
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, July 22, 2013 3:46 PM
> *Subject:* $$Excel-Macros$$ Need help
>
> Friends
>
> i want to find out
Perfect, thank you so much for your help!! Saves me a lot of time.
On Wednesday, July 17, 2013 10:28:34 AM UTC-4, ashish wrote:
> check the attachment see if it helps
>
>
>
> On Wed, Jul 17, 2013 at 12:15 AM, >wrote:
>
>> excel 2003 and the last 4 would be the bottom
>>
>> On Tuesday, July 16, 20
excel 2003 and the last 4 would be the bottom
On Tuesday, July 16, 2013 9:36:13 AM UTC-4, ashish wrote:
> which version of excel are you using and last 4 do you mean from top or
> bottom of column ?
>
>
> On Tue, Jul 16, 2013 at 7:33 AM, > wrote:
>
>>
>>
>> Hello,
>>
>> I am using Excel 2003.
which version of excel are you using and last 4 do you mean from top or
bottom of column ?
On Tue, Jul 16, 2013 at 7:33 AM, wrote:
>
>
> Hello,
>
> I am using Excel 2003. I have attached a simple workbook which has two
> worksheets. One worksheet is titled "Scores" and the other is "Team Info".
Hi Vabz,
I'hve follow your insturction and I'hve got my answer but when I'hve unhide
the sheet, the data will not showing. please help and advise for the same.
Thanks,
Ashish kumar
On Monday, July 1, 2013 2:06:10 PM UTC+5:30, Vabz wrote:
>
> Hi
>
> You can hide all unwanted col & rows and prot
Hi
You can hide all unwanted col & rows and protect workbook so that user will
not be having access to that portion.
Thanks
On Mon, Jul 1, 2013 at 9:25 AM, Ashish Kumar wrote:
> Dear Seniors,
>
> I have a data from Colum A to Column D in excel sheet, I want show only
> this data in sheet & res
there is prob, i tried one formula {=A10=today()}, but its not getting
highlight, might be because of vlookup, example i added vlookup formula,
for "A10", based on A10 cell date, I need to highlight A1:A10
On Thu, Jun 27, 2013 at 4:04 PM, Divaker Pandey wrote:
> See in attached screen shot
>
>
thank you
On Fri, Jun 21, 2013 at 5:50 AM, Anoop K Sharma wrote:
> use conditional formatting.
>
>
> On Thu, Jun 20, 2013 at 2:02 PM, thameem wrote:
>
>> Dear Members,
>>
>> plz help me to get formuale for high-lighting selected cells
>> automatically, when value of one cell get 0 or 1 etc
>>
>
use conditional formatting.
On Thu, Jun 20, 2013 at 2:02 PM, thameem wrote:
> Dear Members,
>
> plz help me to get formuale for high-lighting selected cells
> automatically, when value of one cell get 0 or 1 etc
>
>
> regards
> Thameem.M
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
*Hi Team,*
thank you very much for helping me
Regards
On Wed, May 29, 2013 at 1:46 PM, priti verma wrote:
> Solution with formula.
> PFA
>
>
> On Wed, May 29, 2013 at 1:17 PM, vikas khen wrote:
>
>> Hi Team,
>>
>> I have one excel sheet in which i need to arrange the data in such a
>> manner
Solution with formula.
PFA
On Wed, May 29, 2013 at 1:17 PM, vikas khen wrote:
> Hi Team,
>
> I have one excel sheet in which i need to arrange the data in such a
> manner that all the data will come with the help of transpose option under
> the one by one. i had try this by many methods but in-
Try this.
On Wed, May 29, 2013 at 1:17 PM, vikas khen wrote:
> Hi Team,
>
> I have one excel sheet in which i need to arrange the data in such a
> manner that all the data will come with the help of transpose option under
> the one by one. i had try this by many methods but in-vain. Hence pleas
Dear Anil,
Please find the attached file.
One more help needed.
In the attached file there is three sheets.
First sheet is the data where i will update week on week. By the end of
month i have to prepare the report as in third sheet.
actually what i do.. i will collate the week on week data to
Noorain bhai,
Need it throgh Vba Coding.
On Tue, May 7, 2013 at 6:39 PM, NOORAIN ANSARI wrote:
> Dear Maksood,
>
> Pls see attachment hope it will help to you.
>
>
> On Tue, May 7, 2013 at 6:05 PM, maksood alam <786maks...@gmail.com> wrote:
>
>> Hi guys,
>>
>> I have to select two dates, start
Hi maksood,
you can use series function with column selection..and in step value put 7
and Stop value put end date
[image: Inline image 1]
On Tue, May 7, 2013 at 6:05 PM, maksood alam <786maks...@gmail.com> wrote:
> Hi guys,
>
> I have to select two dates, start date and end date. e.g. start d
Dear Maksood,
Pls see attachment hope it will help to you.
On Tue, May 7, 2013 at 6:05 PM, maksood alam <786maks...@gmail.com> wrote:
> Hi guys,
>
> I have to select two dates, start date and end date. e.g. start date is
> 31/dec/2012 and end date is 31/jan/2014, then it should start range from
Thanks Abhishek..
This is really very usefull..
Regards,
Rahim
On Fri, Apr 12, 2013 at 2:59 PM, Abhishek Jain wrote:
> Sorry the earlier file fetches all files from a folder.
>
> If you want to list only excel files or of any other type, this gives an
> excellent choice. This has many other fu
Does this help ?
On Fri, Apr 12, 2013 at 1:56 PM, wrote:
> I have worked on macros but not at a advanced level. Now i have been asked
> to do the following and need help
>
> 1. list down all excel files if a folder is selected by a user. i have
> created the browse button which takes me to bro
Thanks a lot for the same.
On Thu, Apr 11, 2013 at 7:31 PM, P.VIJAYKUMAR wrote:
> Dear Praful,
>
> There is plenty of difference between Data Validation and a drop down box
> from the developer tab.
> The list box in the data validation or data validation in general is used
> for validating an
Dear Praful,
There is plenty of difference between Data Validation and a drop down box
from the developer tab.
The list box in the data validation or data validation in general is used
for validating an entry which adheres to specified condition or not.For
example when a cell or range of cells a
Thanx!! to all of you
it has solved my query completely.
Regards,
Deepak
On Wed, Apr 3, 2013 at 10:58 AM, prafull jadhav wrote:
> Dear Anil,
>
> Ok..thanks .
>
> Can you clear one things here ..is there any different between validation
> and drop down box is taken from developer menu
>
> Regar
Dear Anil,
Ok..thanks .
Can you clear one things here ..is there any different between validation
and drop down box is taken from developer menu
Regards,
Prafull.
On Wed, Apr 3, 2013 at 10:48 AM, अनिल नारायण गवली
wrote:
> Dear Praful,
>
> Yes it is right. but even me didn't used any type of mac
Dear Praful,
Yes it is right. but even me didn't used any type of macro here . the
dropdown box is taken from developer menu.
Warm Regards,
Gawli Anil
On Wed, Apr 3, 2013 at 10:29 AM, prafull jadhav wrote:
> Dear Anil,
>
> I have created the same with help of validation and index formula by
>
Dear Deepak,
Pl see the attached sheet. Is it OK.
Warm Regards,
Gawli Anil
On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat wrote:
> Hi
>
> Kindly find attached ,
> i need a graph which change as i select the desired cell.
> suppose if i want to see sales then when i wil select "Sale" cell the
> g
Thanx Ashish!!
Regards,
Deepak
On Tue, Apr 2, 2013 at 7:24 PM, ashish koul wrote:
> Try the attachment . double click on cell f3-f5
>
> Regards
> Ashish
>
>
> On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat wrote:
>
>> Hi
>>
>> Kindly find attached ,
>> i need a graph which change as i select the
Try the attachment . double click on cell f3-f5
Regards
Ashish
On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat wrote:
> Hi
>
> Kindly find attached ,
> i need a graph which change as i select the desired cell.
> suppose if i want to see sales then when i wil select "Sale" cell the
> graph should s
First of all, .xlsx files are designed SPECIFICALLY to remove all modules when
the file is saved.
(Microsoft hoped to use this as a mechanism to reduce the spread of viruses)
Second, when you save the file, close and reopen it, (assuming .xlsm or .xlsb
format)
is the macro module still there?
I
Dear Pankaj,
Pl share a workbook with us.
Warm Regards,
Gawli Anil
On Tue, Jan 29, 2013 at 1:16 AM, David Grugeon wrote:
> I really don't understand what you want. Please attac a dashboard sheet
> like you want it with the relevant column headings and the data for at
> least 2 of the rows
>
>
Thanks for the help, Ashish. I'll play around with it and see if I can get
it to work for me.
Richard
>
--
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
I really don't understand what you want. Please attac a dashboard sheet
like you want it with the relevant column headings and the data for at
least 2 of the rows
On Tuesday, 29 January 2013, Pankaj Singh wrote:
> Dear All,
>
> Hope you will be well. here is attached the excel workbook Stock Co
Dear All,
Hope you will be well. here is attached the excel workbook Stock Count
Report.xls.in this work book has many sheet as by people name, i want to
developed dashboard by showing data by each people of his outlets and each
day as of brand wise and summary per people sheet name.
please
Hi Richard
just a suggestion - Why don't u consolidate/ merge all the input sheets to
single then create a simple pivot table for ur analysis
below macro will merge data from multiple sheets to single you might have
to do minor changes so that it meets your requirement
Sub merge1()
Dim i As Lon
Dear Senior,
Thanks for your reply & support. I'll keep this in my mind for better
future assistance.
Thanks
Ashish kumar
On Thursday, January 10, 2013 1:03:01 PM UTC+5:30, Ms-Exl-Learner wrote:
>
> Please make it in an excel workbook and send it to us for our better
> understanding of your
Dear Noorain Sir,
Thanks for your valuable support.
Thanks
Ashish Kumar
On Thursday, January 10, 2013 1:13:59 PM UTC+5:30, NOORAIN ANSARI wrote:
>
> Dear Ashish,
>
> You can try,,
>
>
> For date
> =date(year(a1),month(a1),day(a1)
> and press ctrl+shift+#
>
> For time
> =date(Hour(a1),minute(a1)
Dear Ashish,
You can try,,
For date
=date(year(a1),month(a1),day(a1)
and press ctrl+shift+#
For time
=date(Hour(a1),minute(a1),second(a1)
and press ctrl+shift+@
On Thu, Jan 10, 2013 at 1:01 PM, kumar.ashish861
wrote:
> Dear Seniors,
>
> Pls help to seperate date & time, if both are in 1 cell.
Please make it in an excel workbook and send it to us for our better
understanding of your data structure.
On 10-01-2013 1:01 PM, kumar.ashish861 wrote:
Dear Seniors,
Pls help to seperate date & time, if both are in 1 cell.
7/11/2012 13:51
Formula req..!
Thanks in advance
Ashish k
Hi, Thank you very much. This is simply superb. :-)
On 08/01/2013, Swapnil Palande wrote:
> Hi Mathan,
>
> Pls find attached excel for solution.
>
> Open the attached excel and press "Ctrl + q" to run macro.
>
> I have added extra 2 columns ("Pieces Remain" and "Total Length") for
> calculation
Hi Jocky,
I have been given to simple way solution. Please find the
attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta wrote:
> Hi Team,
>
> I have attached one excel sheet in wich i need to set the formula for the
> person for the entir
Hi Jocky,
Made changes in sheet removing validation to show up the values there. Find
attached the updated one.
On Fri, Jan 4, 2013 at 8:38 PM, Anoop K Sharma wrote:
> Hi Jocky,
>
> Formula's been written in validation rule which will restrict any entry
> other entry except 9:00:00 for Mon-Th
Hi Jocky,
Formula's been written in validation rule which will restrict any entry
other entry except 9:00:00 for Mon-Thu and 12:00:00 for Sat - Sun.
Try to write something there, you'll get error prompting to enter valid
values.
On Fri, Jan 4, 2013 at 7:11 PM, ashwani agnihotri <
ashwani.agniho
please see if this helps...
On Fri, Jan 4, 2013 at 6:43 PM, jocky Beta wrote:
> Hi Anoop,
>
> There is No formula in the attached sheet, :(
>
> On Fri, Jan 4, 2013 at 5:27 PM, Anoop K Sharma wrote:
>
>> Hi Jocky,
>>
>> Please find attached with solution.
>>
>> Regards,
>> Anoop
>> Sr. Developer
Hi Anoop,
There is No formula in the attached sheet, :(
On Fri, Jan 4, 2013 at 5:27 PM, Anoop K Sharma wrote:
> Hi Jocky,
>
> Please find attached with solution.
>
> Regards,
> Anoop
> Sr. Developer
>
>
> On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta wrote:
>
>> Hi Team,
>>
>> I have attached one
Hi Jocky,
Please find attached with solution.
Regards,
Anoop
Sr. Developer
On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta wrote:
> Hi Team,
>
> I have attached one excel sheet in wich i need to set the formula for the
> person for the entire week.i.e is if one person is working form Mon to Fri
>
THANKS A LOT
On Mon, Dec 10, 2012 at 11:59 AM, David Grugeon wrote:
> IF(A2,A2,B2)
>
> Regards
> David Grugeon
>
>
>
> On 10 December 2012 15:20, The Viper wrote:
>
>> other ways for shortening the formula
>> =IF(A2=FALSE,B2,A2)
>> or
>> =SUBSTITUTE(A2&B2,"FALSE","")
>>
>>
>> On Mon, Dec 10, 201
IF(A2,A2,B2)
Regards
David Grugeon
On 10 December 2012 15:20, The Viper wrote:
> other ways for shortening the formula
> =IF(A2=FALSE,B2,A2)
> or
> =SUBSTITUTE(A2&B2,"FALSE","")
>
>
> On Mon, Dec 10, 2012 at 10:28 AM, Anoop K Sharma
> wrote:
>
>> Hi Dhaval,
>>
>> PFA...
>>
>> Regards
other ways for shortening the formula
=IF(A2=FALSE,B2,A2)
or
=SUBSTITUTE(A2&B2,"FALSE","")
On Mon, Dec 10, 2012 at 10:28 AM, Anoop K Sharma wrote:
> Hi Dhaval,
>
> PFA...
>
> Regards,
> Anoop
> Sr. Developer
>
>
> On Mon, Dec 10, 2012 at 9:12 AM, Dhaval Shah wrote:
>
>>
>> --
>> Join of
Hi Dhaval,
PFA...
Regards,
Anoop
Sr. Developer
On Mon, Dec 10, 2012 at 9:12 AM, Dhaval Shah wrote:
>
> --
> 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
Before importing data use the following function
=clean(your expression)
On Fri, Nov 9, 2012 at 5:39 PM, Mangesh Vimay wrote:
> but how?
>
> Can you help me please.
>
> On 11/9/12, Anoop K Sharma wrote:
> > Use Clean function
> >
> >
> >
> > On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay
> > wr
but how?
Can you help me please.
On 11/9/12, Anoop K Sharma wrote:
> Use Clean function
>
>
>
> On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay
> wrote:
>
>> Hi Friends,
>>
>> I need your help.
>> I have Excel file containing some data. I have import this data to MS
>> Access 07 table by using Ap
Use Clean function
On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay wrote:
> Hi Friends,
>
> I need your help.
> I have Excel file containing some data. I have import this data to MS
> Access 07 table by using Append query.
> But when I access the table, it contains some un-wanted characters like
Is the 200 workbooks the ONLY files in the folder C:\EBACKUP ?
If so, you can place this macro in a "standard" module of your master workbook:
Sub CopyData()
Dim fso, Fldr, fl, fc, f
Dim Sht
Sht = "Option Letter"
Fldr = "C:\EBACKUP\"
Application.ScreenUpdating = False
Set
=DATE(D2,C2,B2)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Neeraj
Sent: 31 October 2012 11:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ need help
Dear Experts,
Kindly fi
thanks kuldeep
On Wed, Oct 31, 2012 at 12:00 PM, Kuldeep Singh wrote:
>
> Dear Neeraj,
>
> Try this one and drage to down.
>
> =DATE(D3,C3,B3)
>
> Regards,
> Kuldeep Singh
>
>
> On Wed, Oct 31, 2012 at 11:55 AM, Neeraj wrote:
>
>> Dear Experts,
>>
>> ** **
>>
>> Kindly find the attached shee
Pl find attached sheet for you info.
Excuse typo errors...
Regards,
Gawli Anil
On Wed, Oct 31, 2012 at 11:55 AM, Neeraj wrote:
> Dear Experts,
>
> ** **
>
> Kindly find the attached sheet and resolve the problem….
>
> --
> Join official facebook page of this forum @
> https://www.face
Dear Neeraj,
Try this one and drage to down.
=DATE(D3,C3,B3)
Regards,
Kuldeep Singh
On Wed, Oct 31, 2012 at 11:55 AM, Neeraj wrote:
> Dear Experts,
>
> ** **
>
> Kindly find the attached sheet and resolve the problem….
>
> --
> Join official facebook page of this forum @
> https://ww
http://accessvbaprogramming.wordpress.com/2012/09/18/type-sql-query-in-text-box-in-access-form-and-export-output-to-excel/
On Sun, Oct 28, 2012 at 3:12 PM, Mangesh Vimay wrote:
> Dear Friends,
>
> I am using MS Access 2007.
> I need VBA code to export the result of the any query written in text
attach the sample file
On Sat, Oct 27, 2012 at 10:41 PM, Rupendra Phatak wrote:
> Hi Friends,
>
> I am having data in a excel which contains records of maturity
> deposits/securities in different. sheets the only common field is
> Maturity Date in all sheets.
>
> Now what i need is to sort the
Please help.
On Oct 15, 2012 8:08 AM, "B.N.Chethan Kumar"
wrote:
> Dear Experts,
>
> Please help me with Macro. I need to assign a auditor for each Policy and
> create worksheet for each auditor in same workbook by copy the policy to it.
>
> Kindly refer the attached file. Based on policy ID (Col
-
> *From: *Amol Jadhav
> *Sender: *excel-macros@googlegroups.com
> *Date: *Thu, 11 Oct 2012 11:54:30 +0530
> *To: *
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Need Help related to XML with excel
>
> Yes, I am able import and expor
-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need Help related to XML with excel
Yes, I am able import and export it using devloper tab,
Is it posible using VBA??
Thanks
Amol
On Thu, Oct 11, 2012 at 11:42 AM, NOORAIN ANSARI
wrote:
> Dear Amol,
>
> You have try through Deve
Yes, I am able import and export it using devloper tab,
Is it posible using VBA??
Thanks
Amol
On Thu, Oct 11, 2012 at 11:42 AM, NOORAIN ANSARI
wrote:
> Dear Amol,
>
> You have try through Developer tab..
>
>
>
>
> On Thu, Oct 11, 2012 at 11:36 AM, Amol Jadhav wrote:
>
>> Hello experts,
>>
>
Dear Amol,
You have try through Developer tab..
On Thu, Oct 11, 2012 at 11:36 AM, Amol Jadhav wrote:
> Hello experts,
>
> I need help related to following things
>
> 1) How to import xml file in excel using VBA
> 2) how to export xml file using vba
>
>
> Regards,
> Amol J
>
> --
> Join offic
Dear Karthik,
In 2003 Version you can also use
*=SUMPRODUCT(--(B4:B14="Karthik")*($C$4:$C$14="Collected"))*
On Fri, Oct 5, 2012 at 8:23 PM, karthik N wrote:
> Hi Friends
>
> Need help
>
> How many cases are collected in karthik, pls send me a any formula
>
> *name* *status* karthik collected
=COUNTIFS(A2:A12,"Karthik",B2:B12,"Collected")
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of karthik N
Sent: 05 October 2012 8:23
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Ne
See the attached file, its siolved
Ashish
On Thu, Oct 4, 2012 at 7:14 PM, karthik N wrote:
> Hi Team,
>
> Please help in the attachment file
>
> Regards
> karthik.N
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members alre
Sub export_range_as_table()
' add a reference to the Word-library
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
'add refrence microsoft word
Dim wrdTable As Word.Table
Dim datacell
Set wrdApp = CreateObject("Word.Application")
Set wrdDoc = wrdApp.Documents.Add ' create a new document
Are you saying that you want to HIDE COLUMNS??? Please define your problem with
examples if possible.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Thursday, September 20, 2012 1:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Ma
And, I wonder why he insists.. Homework?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Wednesday, September 12, 2012 8:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three
e places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
________
From: Vabz
To: excel-macros@googlegroups.com
Sent: Wed, September 12, 2012 8:59:52 AM
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
hi.
hi..
what i feel is this solution is very complex !!
Rgds//Vabz
On Tuesday, September 11, 2012 7:09:23 AM UTC+5:30, Asa R. wrote:
>
> Hi Mangesh,
>
> I've read your other replies, and as to why you haven't received a formula
> method -- most people don't want to take the trouble on a volunteer
Homework done...
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Mangesh Vimay
Sent: Tuesday, September 11, 2012 4:56 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Its really Great Help
Its really Great Help Asa !!!
Thanks a ton !!!
On Tue, Sep 11, 2012 at 7:07 AM, Asa Rossoff wrote:
> Hi Mangesh,
>
> I've read your other replies, and as to why you haven't received a formula
> method -- most people don't want to take the trouble on a volunteer basis
> to provide a more comp
Hi Mangesh,
I've read your other replies, and as to why you haven't received a formula
method -- most people don't want to take the trouble on a volunteer basis to
provide a more complex or difficult solution to a given problem when simple
solutions exist. Also in business, the simplest solution
alf Of *Mangesh Vimay
> *Sent:* 10 September 2012 7:55
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Need help - To divide the string into
> three parts
>
> ** **
>
> Hi Guillett,
>
> ** **
>
> I would like to know all possi
As I said, I would simply use TTC
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Mangesh Vimay
Sent: Monday, September 10, 2012 9:24 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Hi
the
> file? Unless, of course, this is HOMEWORK
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Mangesh Vimay
> *Sent:* Monday, September 10, 2012 6:11 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Exce
: $$Excel-Macros$$ Need help - To divide the string into three parts
Yes u r right.
I did by using Text to Column option. Its works fine.
But I need it by using formula.
Thanks
On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar wrote:
Dear Mangesh,
you can use text to colum
Regard
Thanks ALL for the Great Help !!!
On Mon, Sep 10, 2012 at 5:25 PM, David Grugeon wrote:
> In B2 put =LEFT(A2,FIND(",",A2)-1)
> In C2 put =MID(A2,LEN(B2)+2,FIND(",",A2,LEN(B2)+2)-LEN(B2)-2)
> In d2 put =MID(A2,LEN(B2&C2)+3,99)
>
>
> On 10 September 2012 21:04, Mangesh Vimay wrote:
>
>> Hi Friend
In B2 put =LEFT(A2,FIND(",",A2)-1)
In C2 put =MID(A2,LEN(B2)+2,FIND(",",A2,LEN(B2)+2)-LEN(B2)-2)
In d2 put =MID(A2,LEN(B2&C2)+3,99)
On 10 September 2012 21:04, Mangesh Vimay wrote:
> Hi Friends,
>
> I need your help to divide the string into three parts.
> The description and sample is given bel
Hi Mangesh..
PFA.. Cheers
Rgds//Vabz
On Monday, September 10, 2012 4:41:13 PM UTC+5:30, Mangesh wrote:
>
> Yes u r right.
> I did by using Text to Column option. Its works fine.
> But I need it by using formula.
> Thanks
>
>
> On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar
>
> > wrote:
>
>> Dear
Yes u r right.
I did by using Text to Column option. Its works fine.
But I need it by using formula.
Thanks
On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar wrote:
> Dear Mangesh,
>
> you can use text to colum
>
> Regard
> Manoj
>
>
> On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay wrote:
>
>> Hi
Dear Mangesh,
you can use text to colum
Regard
Manoj
On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay wrote:
> Hi Friends,
>
> I need your help to divide the string into three parts.
> The description and sample is given below :
> [image: Inline image 1]
> Waiting for your response.
>
> Thank
201 - 300 of 704 matches
Mail list logo
