Dear Laxman,
PFA.
On Wed, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote:
Dear Expert,
Want conditional lookup from sheet 1 those data which is active in column
A , plz the attached file
**
Thanks,
Regards
LAKSHMAN
--
Are you =EXP(E:RT) or
Respected Devanand,
I think you have exported the same from tally.In tally you have the option
to sort the details before exporting.You can do the same in excel
also.First sort the data according to the TIN NO.The select the data and
apply subtotal.In subtotal column select TIN NO and select the
Dear waseem,
Plz C the sheet2 where unit no.249 found but sheet1 not pickup that value
From: Waseem Saifi waseemsa...@gmail.com
To: excel-macros excel-macros@googlegroups.com
Sent: Wednesday, July 24, 2013 11:50 AM
Subject: Re: $$Excel-Macros$$ Want
You can try this code
Change Workbook name as per your Workbook name
wkbMoveto Is that workbook in which you want to past data
wkbMoveFrom is that workbook from which you want to copy data
Sub Copydata()
Dim wkbMoveto As Workbook
Dim wkbmoveFrom As Workbook
Dim wksMoveto As
Dear Laxman,
PFA.
On Wed, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD lakshman_...@yahoo.com
wrote:
Dear Expert,
Want conditional lookup from sheet 1 those data which is active in column A ,
plz the attached file
Thanks,
Regards
LAKSHMAN--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Hi,
Instead of Macro, you can use ASAP utlities to split various sheets in one
excel file.
Rgds,
Prabhakar
On Monday, July 22, 2013 4:52:05 PM UTC+5:30, ca_k...@yahoo.co.in wrote:
Dear Excel experts,
I want one macro which can spit varios sheets of one excel file to related
other
Sorry for previous incomplete mail,
Help me on this ,
i want all files name from folders.
Folder1 File1,file,2,
folderA file3,file4,file5
folderB file6,file7
folderCfile8
folder2file 9
folderD file10
Hi Priti,
Please see if it help
Public Sub selectfol()
On Error Resume Next
Set path1 = CreateObject(Shell.application).browseforfolder(0, Please
choose a folder, 0, openat)
pathm = path1.self.Path
UserForm1.TextBox1.Text = pathm \
mysourcepath = pathm \
Set myobject =
Thank for quick response But this code is not working fine .
Its giving Only first folder 's file name .
I mean I have lots of folder and and file in main folder.and folder
contain further folders and file and these folder also contains some
folder and files.
So i want all files name from all
Hi All,
I have attached my query regarding sum function query
I know this can be solved through pivot table, but I want the result in
formulaes.
Pls let me know if anyone can solve this?
/Suresh
--
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)
PFA
Dim Rng As Range, iRow As Integer
Sub GetFolder()
Dim fldr As FileDialog
Set Rng = ActiveCell
Set fldr = Application.FileDialog(msoFileDialogFolderPicker)
fldr.AllowMultiSelect = False
If fldr.Show = -1 Then Call ListIt(fldr.SelectedItems(1))
End Sub
Private Function
Hi
With the help of SUM IF, you can get the result.
For ref. PFA
On Wed, Jul 24, 2013 at 6:20 PM, suresh k brave.sur...@gmail.com wrote:
Hi All,
I have attached my query regarding sum function query
I know this can be solved through pivot table, but I want the result in
formulaes.
Pls
Thanks Dp,
But its giving only Nested foldersname.
I want files name.
Anyway i got idea from your Code
On Wed, Jul 24, 2013 at 7:22 AM, De Premor d...@premor.net wrote:
PFA
Dim Rng As Range, iRow As Integer
Sub GetFolder()
Dim fldr As FileDialog
Set Rng = ActiveCell
Set
I think you only need a foldername :D
Try to change ListIt Function with this rev
Private Function ListIt(SelectedPath As String, Optional tCol As Integer
= 0)
Dim FSO As Scripting.FileSystemObject, sFolder, sSubFolder, lPath,
sFile
On Error Resume Next
Set FSO = New
Hi DP
Perfect code
Thanks For Your Time and Efforts.
On Wed, Jul 24, 2013 at 7:53 AM, De Premor d...@premor.net wrote:
I think you only need a foldername :D
Try to change ListIt Function with this rev
Private Function ListIt(SelectedPath As String, Optional tCol As Integer =
0)
Hi, see (attached) if that's what you want
Em quarta-feira, 24 de julho de 2013 07h29min47s UTC-3, Pravin Gunjal
escreveu:
Hello,
I would like to translate this attached PDF texts (words) in to English to
work out on it. I tried my best but couldn't get the exact result. Can
Hi Group,
Need information on what is 9E+307 and when/where/how to use it.
Few example will be of very helpful to me with supporting links.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
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) !
Santoh,
9E+307 is the largest numeric value that can be represented in Excel.
.
Enjoy
Team XLS
On Thu, Jul 25, 2013 at 1:09 AM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hi Group,
Need information on what is 9E+307 and when/where/how to use it.
Few
- Forwarded Message -
From: Waseem Saifi waseemsa...@gmail.com
To: excel-macros excel-macros@googlegroups.com
Sent: Wednesday, July 24, 2013 11:50 AM
Subject: Re: $$Excel-Macros$$ Want conditional lookup
Dear Laxman,
PFA.
On Wed, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD
You can use Sumif
It's so simple !
it is simplest query I have ever found on this group.
Regards,
Waseem Saifi
On Wed, Jul 24, 2013 at 6:51 PM, Ravinder Kumar
ravinderbhardwa...@gmail.com wrote:
Hi
With the help of SUM IF, you can get the result.
For ref. PFA
On Wed, Jul 24, 2013 at
=SUMIF($A$4:$A$54,H4,$B$4:$B$54)
use this formula
From: suresh k brave.sur...@gmail.com
To: Excel group excel-macros@googlegroups.com
Sent: Wednesday, July 24, 2013 6:20 PM
Subject: $$Excel-Macros$$ Sum query
Hi All,
I have attached my query regarding
21 matches
Mail list logo
