Hi Amar,
please paste this Cell i8 and press Ctrl+Shift+Enter
Regards
Prince
On Tuesday, December 11, 2012 1:13:52 PM UTC+5:30, amar takale wrote:
>
> Hi All Champs
>
> I will Request all anyone suggest me unique value from same month (formula)
>
> Regards
> Amar
>
>
>
--
Join official Faceboo
maybe someone else can post a code for that, it doesn't take long. Start
from mine, improve it...
--
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,
Hi Ganesh
I have currently too little time until end of week to look at your query.
Just check that everything is on C: path drive and that a folder merge
exist on the same location.
Else, I'll have to look closer.
Regards
Pascal
--
Join official Facebook page of this forum @
https://www.fa
Hi Ashish,
Please find attached text files and excel sheet for your reference.
Please let me know if you have any clarifications.
Regards,
Ganesh
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thr
share some sample text files
On Tue, Nov 27, 2012 at 8:21 PM, Ganesh wrote:
> Hi Pascal,
>
> I am not get correct solution from this coding
>
> Please help !!!
>
>
> On Sat, Nov 24, 2012 at 8:11 PM, bpascal123 wrote:
>
>> Another shorter programming solution would have been to autofilter c
Hi Pascal,
I am not get correct solution from this coding
Please help !!!
On Sat, Nov 24, 2012 at 8:11 PM, bpascal123 wrote:
> Another shorter programming solution would have been to autofilter column
> B and copy visible cells into a table and do the same thing and
> let CopyDataToTxtFil
Another shorter programming solution would have been to autofilter column B
and copy visible cells into a table and do the same thing and
let CopyDataToTxtFile do the same thing. am I wrong?
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) U
Hi Ganesh
You can try that
Create a module and copy paste into it
Sub CopyMergeTxtFiles()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
.Calculation = xlCalculationManual
.EnableEvents = False
End With
Dim ws As Worksheet
Dim i As Long, j As Long
Dim lastr As
Hi Pascal,
Your understanding is exactly correct, Kindly help to us.
Thanks & Regards,
Ganesh
>
> On Sat, Nov 24, 2012 at 4:24 AM, bpascal123 wrote:
>
>> Merge1.txt = consist of 1.txt, 2.txt and 3.txt also the same order (1, 2
>> & 3) to copy paste in Merge1.txt file.
>>
>> consist of the con
Merge1.txt = consist of 1.txt, 2.txt and 3.txt also the same order (1, 2 &
3) to copy paste in Merge1.txt file.
consist of the content of 1.txt, 2.txt ... not just what's on the
spreadsheet.
Tell each step of the macro i.e:
1. Open or create a file from path "C:\Merge\Merge1.txt" for the first
Hi Ganesh
Merge1.txt will include 1.txt, 2.txt, 3.txt
Merge4.txt will include 5.6.7.8.txt files
Merge9.txt will include anything from 10.txt file to next Merge.txt ? Plz
confirm
The data in Merge.txt file will be like the content of 3.txt comes after
the content 2.txt and so on?
Pascal
--
Jo
ober 20, 2012 5:00 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Request for support for a looping macro
I wonder if it would speed it up if you set calculation to xlmanual?
Regards
David Grugeon
On 21 October 2012 03:23, Asa Rossoff wrote:
> Hi Diamond Dave,
ce
>
> .Offset(0, -1).Value = .Value
>
> .Columns(.Columns.Count).Clear
>
> Set NewRow = .Rows(1).EntireRow.Offset(3, 0)
>
> End With
>
> NewRow.Insert
>
> Set Position = NewRow.Cells(1)
>
> Position.Value = "variance"
>
> End Sub
>
>
>
> FURTH
uest and better respond.
Again thanks so very much looking at the request
Dave
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Don Guillett
Sent: Tuesday, October 02, 2012 3:49 PM
To: excel-macros@googlegroups.com
Cc: 'ashish koul'
Subject: $$E
Methinks you are making this much more difficult than necessary.
Either fully explain what you want with before/after example
If all else fails, send file to dguillett1 @gmail.com
On Tuesday, October 2, 2012 4:33:57 PM UTC-5, Diamond Dave wrote:
>
> Attached is a file which contains a Macro (S
Hi Jim,
Forgive me, if I've not understood it correctly but you can achieve
the same task using Find method. Press Ctrl+F and search the number.
Why you need a macro/custom formula ?
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft C
Hi there,
One suggestionOffice 2010 is available for free on microsoft
official website...
http://www.microsoft.com/office/2010/en/default.aspx
Thanks,
Ramesh
On Mar 3, 2:55 pm, sudhir kumar wrote:
> Hi Dear all,
>
> Can any one send me setup of MS office 2010.
> It was download from net b
You should download and install Office 2007 Compatibility Pack. It is free.
Here is the link to download :
http://www.microsoft.com/downloads/details.aspx?FamilyId=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
After installing this, you will be able to open file produced in office
2007.
Re
Hai,
Here is a method to solve your issue.
Please check with the below workbook and let me know if you have any
other query.
http://groups.google.com/group/excel-macros/web/Smart_LookUp.xls?hl=en
Happy New Year 2009.
Maddy
LIFE = IF(Rand()*100<50,"P
Hi
could Explain how you did??
On Sun, Dec 28, 2008 at 8:26 PM, Mr. Pardeshi Somnath wrote:
> Hi...
> Please Try Sheet Reply
> Is This fine?
>
>
>
> Somnath C Pardeshi
> +91 9221700131
>
>
>
> --
>
> Date: Sat, 27 Dec 2008 13:30:00 +0530
> From: kona...@gmai
HI DEAR,
I THINK THIS WILL BE EASILY SOLVED WITH USE OF PIVOT TABLE.
WHAT U SAY
REGARDS,
VIR
On 12/29/08, Tom Jeffries wrote:
>
> The attached workbook (GetJobs) shows a way to get the data you want. Use
> the Worksheet_Change event to launch a subroutine to retrieve the desired
> inform
*It is very easy, Use Pivot table.*
On Sat, Dec 27, 2008 at 1:30 PM, konark vyas wrote:
>
> Hi,
>>
>> I have a data range in sheet 1 and in sheet 2 i want to view some specific
>> information as attached. Please help me on this.
>>
>> Thanks in advance.
>>
>>
>>
>> Regards,
>>
>> Konark Vy
The attached workbook (GetJobs) shows a way to get the data you want. Use
the Worksheet_Change event to launch a subroutine to retrieve the desired
information. It is not very elegant but does appear to work. If you have
any questions let me know.
Tom
On Sat, Dec 27, 2008 at 3:00 AM, konark vya
Hi...
Please Try Sheet Reply
Is This fine?
Somnath C Pardeshi
+91 9221700131
Date: Sat, 27 Dec 2008 13:30:00 +0530From: kona...@gmail.comto:
excel-mac...@googlegroups.comsubject: $$Excel-Macros$$ request to hlp me on the
attached file query
Hi,
I have a data range in sheet 1
Dear Konark
I have understood your requirement. Please give me some time. I will
definately send you the solution.
Kind Regards
Kalpesh
On Sat, Dec 27, 2008 at 1:30 PM, konark vyas wrote:
> Hi,
>
> I have a data range in sheet 1 and in sheet 2 i want to view some specific
> information as att
Hi! Even I would like to have the pdf for Excel Macros...Can you
forward it to my acct. as well ..rahul.gandh...@gmail.com
On Dec 15, 4:29 pm, "Ankur Satija" wrote:
> Dear all
>
> Could u please mail that file (39_excelmacros.pdf) to me also?
>
> Ankur Satija
>
> On 12/15/08, Ahmedhonest wrote:
Dear all
Could u please mail that file (39_excelmacros.pdf) to me also?
Ankur Satija
On 12/15/08, Ahmedhonest wrote:
>
> Dear all,
>
> Plz forward me the book if one of you received from Swapnilsagar i.e
> 39_excelmacros.pdf
>
> Waiting for a prompt reply
> Thanks in advance
>
> --
> Ahmed Bawa
Hi,
For understanding purpose, lets assume we have B2 instead of B2:B13, fine.
The Text function formats the value (first parameter) according to the
format (the second parameter). So actually the first time we use text()
function, it actually tests if the cell (B2) has the value that matches the
f
HI Ajit.
I sincerely appreciate your solutions and your contribution to this group.
looking at your solution I want to know what does this formula means and how
it works
=SUM(IF(TEXT(B2:B13,"[EMAIL PROTECTED]/000\/00*
")=B2:B13,IF(ISERR(SEARCH("/",TEXT(B2:B13,"[EMAIL
PROTECTED]/000\/00*")))=FALSE
Pls find attached the file
Regards
Ajit
On Sat, Oct 18, 2008 at 2:08 PM, Ahmedhonest <[EMAIL PROTECTED]> wrote:
>
> Dear All,
>
> A warm Greetings to all. Please find the attach file to this mail and
> request you all Guys to provide me the solution and have patients in reading
> the file t
Dear Ahmed,
You can use a very simple "If" formula.
Consider the first admission."NSA/250/30. Just type the following in your
sheet - "=if(B2<>0,D2,0) and then copy the formula. Take the sum of this
column.
Regards,
Nikhil.
On Sat, Oct 18, 2008 at 2:08 PM, Ahmedhonest <[EMAIL PROTECTED]> wrot
Try this
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of Ahmedhonest
Sent: Saturday, October 18, 2008 11:38 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Request for Formula
Dear All,
A warm Greetings to all. Please find the attach file to th
You can use the headre and footer option in Page setup to do this.
(Page setup is in File menu)
let me know if you need further explanation.
On Sep 9, 10:26 am, ankur <[EMAIL PROTECTED]> wrote:
> dear members,
> i had my company logo ,which i want to paste on every page of excel
> when i take ou
33 matches
Mail list logo
