t, 1), Cells(Rows.Count, 1)).End(xlUp).Row + 1 col_ws1 = ActiveSheet.Range(Cells(1, Columns.Count), Cells(1, Columns.Count)).End(xlToLeft).Column Else row_ws1 = 1 col_ws1 = 1 End If ws1.Range(Cells(row_ws1, 1), Cells(row_ws1 + row_no - 1, col_no)) = arr_
a On Tue, Jan 26, 2016 at 8:52 PM, Sandeep Chhajer <chhajersand...@gmail.com> wrote: Hi,Any way to solv
.From: Sandeep Chhajer Sent: Sunday 24 January 2016 18:07To: Excel MacrosReply To: excel-macros@googlegroups.comSubject: $$Excel-Macros$$ Merge multiple WorkbookHi Excel guru,I have found macros for merging
Hi Excel guru,
I have found macros for merging multiple workbook (kept in a single folder)
into a single worksheet.
But my requirement is a step ahead...can that macro to be changed to copy
only specified column from every wrokbook (Sheet1). Like it will search in
all the workbooks (sheet1 row no
Hi,You can use VLOOKUP. For more how to use VLOOKUP check..Microsoft office help.Sandeep.
sion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Saturday, December 27, 2014 11:48:23 AM UTC+5:30, sandeep chhajer wrote:
>
> Dear Excel Gurus,
>
> Please check the print screen attached herewith. I am getting a sheet
> called
Thanks Vaibhav. Will check and revert back to you.
On 2 June 2014 13:50, Vaibhav Joshi wrote:
> Hey
>
> Chek this..
>
> Modified mine earlier posted template to suits you.
>
> Mail will be send using outlook..
>
> Cheers!!
>
>
>
>
> On Mon, Jun 2,
Dear Excel Gurus,
I want to make emailing procedure to my client automated.
I have a excel sheet as below
Name of the CompanyConcerned person PAN email ID
ABC LTDMurli JoshiAKJCC0305D
mu...@abc.com
XYZ P LTD
ot;SHBrowseForFolderA" (lpBrowseInfo As BrowseInfo) _
> As Long
>
> Public Type BrowseInfo
> hOwner As Long
> pIDLRoot As Long
> pszDisplayName As String
> lpszTitle As String
> ulFlags As Long
> lpfn As Long
> lParam As Long
> iImage
Dear Excel Gurus,
I have got this Macro from this forum for* adding worksheets from different
work book kept in a folder,* but now when i am trying this code I am
getting compiling error message" can not define a public user defined type
with an object module.
Please help.
Thanks in advance.
Op
Dear Excel Gurus,
I have a peculiar problem. When I import data in excel from Tally it shows
me number as shown below
Balance
Debit
Credit
Balance
Aditya Birla Memorial Hospital
3049.00
3049.00
Aditya Enterprises
99521.00
101086.00
1565.00 Cr
Airways Co
hope it fulfill your requirement
.
Enjoy
Team XLS
On Sat, Oct 5, 2013 at 3:14 PM, Sandeep Chhajer mailto:chhajersand...@gmail.com> > wrote:
PFA the original file. Hope it will work.
On 5 October 2013 13:00, ashish koul mailto:koul.ash...@gmail.com> &g
Data, Data.End(xlDown)).Offset(, 4)
> For Each Rng In Data
> Rng.Offset(, 2) = Rng * IIf(InStr(1, Rng.NumberFormat, "Cr") > 0,
> -1, 1)
> Next
> End Sub
>
>
> Pada 05/10/2013 14:23, Sandeep Chhajer menulis:
>
> Dear Excel Gurus,
>
&
l-macros@googlegroups.com
>> *Date: *Sat, 5 Oct 2013 12:55:31 +0530
>> *To: *excel-macros
>> *ReplyTo: * excel-macros@googlegroups.com
>> *Subject: *Re: $$Excel-Macros$$ Identifying Excel number format
>>
>> can u share the orginal file
>>
>>
>> O
Dear Excel Gurus,
I have facing a peculiar problem related to number format.
When I export any ledger from tally I got result as bellow
Aditya Birla Memorial Hospital 3049.00 3049.00Aditya Enterprises
99521.00 101086.00 *1565.00 Cr* Airways Corporation 39363.80 Dr *39363.80
Dr* Airway
Please find the attached file.
Thank you
Regards
Sandeep Kumar Chhajer.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of VBA VABZ
Sent: 04 June 2013 10:44
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Want to add every third
excel dashboard and its potential while
presenting reports. Can any one send me some tutorials for the beginners
like me.
Thanking you in advance.
Sandeep Chhajer.
Sent on my BlackBerryR from Vodafone
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
: WANT TO GET BOX MARGIN IN EVERY SHEET
Hi
I dont know customisation for footer, however you can create Image of data
you want & Insert in footer..
Cheerz..
Rgds//Vabs
On Saturday, September 15, 2012 7:27:45 PM UTC+5:30, sandeep chhajer wrote:
Dear all,
I want to get box t
Dear all,
I want to get box to be printed in every sheet.
Now with "repeat rows" I can get only upper margin. I want it to be same for
lower margin to enclose the whole script in a box for a page. Please help.
Thank you
Regards
Sandeep Kumar Chhajer.
--
Join official facebo
Dear Excel Guru,
I have a protected sheet where some cells are unprotected.
i want a macro which can make all unprotected cells to zero value.
Thanking you in advance.
--
Regards,
Sandeep Kumar Chhajer.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thre
Please find.
On 18 May 2012 15:34, Sandeep Chhajer wrote:
> Dear Excel Guru,
>
> Please find the attheche file.
>
> No of Student FSLE FSB FSC FSPA Total My Ans should be 25
> 13 40 10 88 Result requiredEXP Amount FSLE FSB FSC FSPA
> Printin
Dear Excel Guru,
Please find the attheche file.
No of Student FSLE FSB FSC FSPA Total My Ans should be 25 13
40 10 88 Result requiredEXP Amount FSLE FSB FSC FSPA
Printing 23,456 Yes Yes Yes Yes 6,664
3,465
10,662 2,665 Fees
mp; i + 1).Select
> Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
> i = i + 1
> End If
> Else
> Exit For
> End If
> Next i
> End Sub
>
>
>
> On Wednesday, March 21, 2012 9:40:37 PM UTC+5:30, sandeep chhajer wrote:
&g
Thanks krish its working great.
Sandeep
On 29 December 2011 19:22, Kris wrote:
> Hi,
>
> Put this code in the 'Particular sheet' module. Right click on sheet name
> > view code and paste the code there.
>
> Also I set the range D2 where you enter the name of the product. adjust
> this range in
lerts = True
> Application.ScreenUpdating = True
> End Sub
>
> On Thu, Nov 3, 2011 at 1:06 PM, wrote:
>
>> **
>> My files are saved in .xls format. But I am working in .xlxs.
>>
>>
>> Sandeep Chhajer.
>> Sent on my BlackBerryŽ from Vodafone
>
l
>>
>> On Wed, Nov 2, 2011 at 2:08 PM, wrote:
>>
>>> Dear all,
>>>
>>> I have many work book in a single folder. I need a macro which if I run
>>> will copy the 1st sheet of every workbook in a single workbook (though as
>>> separate
Dear Noorain,
I have gone through your attachment and find it of a graet help. I hope you
wont mind to guide us in a *step by step* *action to be done* for your all
four examples.
Thanking you in advance.
On 25 July 2011 23:14, NOORAIN ANSARI wrote:
> Dear Neil,
>
> Please see attached sheet
dear excel guru,
thanks for the reply and sorry for late reply.
the macro only searches excel files containing the specified word but
not pdf or doc file.I do need the same for pdf and doc file.
thanks in advance.
On 08/06/2011, ashish koul wrote:
> try this
>
> rename sheet to rename files
>
For contact person ur formula should be
=VLOOKUP($F$2,DATA!$B:$G,3,0)
And so on.
i.e instead of A it shoul start from B.as unique value is in col. B.
Hope it will haelp u.
On 17 January 2011 12:16, jocky Beta wrote:
>
> Hi,
>
> I made a Excel sheet with help of V lookup using the Data validat
30 matches
Mail list logo
