a On Tue, Jan 26, 2016 at 8:52 PM, Sandeep Chhajer <chhajersand...@gmail.com> wrote: Hi,Any way to solv
ws.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_ws Next objF
.From: Sandeep Chhajer <chhajersand...@gmail.com>Sent: Sunday 24 January 2016 18:07To: Excel MacrosReply To: excel-macros@googlegroups.comSubject: $$Excel-Macros$$ Merge multiple WorkbookHi Excel
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
Hi,You can use VLOOKUP. For more how to use VLOOKUP check..Microsoft office help.Sandeep.
.
Regards,
Mandeep Baluja
LearningZmyPassion
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
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
Thanks Vaibhav. Will check and revert back to you.
On 2 June 2014 13:50, Vaibhav Joshi v...@vabs.in wrote:
Hey
Chek this..
Modified mine earlier posted template to suits you.
Mail will be send using outlook..
Cheers!!
On Mon, Jun 2, 2014 at 12:54 PM, Sandeep Chhajer chhajersand
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.
Type BrowseInfo
hOwner As Long
pIDLRoot As Long
pszDisplayName As String
lpszTitle As String
ulFlags As Long
lpfn As Long
lParam As Long
iImage As Long
End Type
Em terça-feira, 15 de outubro de 2013 06h12min23s UTC-3, sandeep chhajer
escreveu:
Dear
hope it fulfill your requirement
.
Enjoy
Team XLS
On Sat, Oct 5, 2013 at 3:14 PM, Sandeep Chhajer chhajersand...@gmail.com
mailto:chhajersand...@gmail.com wrote:
PFA the original file. Hope it will work.
On 5 October 2013 13:00, ashish koul koul.ash...@gmail.com
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
(, 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,
I have facing a peculiar problem related to number format.
When I export any ledger from
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*
-macrosexcel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ Identifying Excel number format
can u share the orginal file
On Sat, Oct 5, 2013 at 12:53 PM, Sandeep Chhajer
chhajersand...@gmail.com wrote:
Dear Excel Gurus,
I have facing
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
have came to know about 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
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
: 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
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
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
Please find.
On 18 May 2012 15:34, Sandeep Chhajer chhajersand...@gmail.com 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
Printing
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:
Dear all,
Please find my attachment ( I know asking question in this way is a
violation of our forum rule but sorry I don't have data card to copy
Thanks krish its working great.
Sandeep
On 29 December 2011 19:22, Kris krishnak...@gmail.com 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
in .xlxs.
Sandeep Chhajer.
Sent on my BlackBerryŽ from Vodafone
--
*From: *ashish koul koul.ash...@gmail.com
*Sender: *excel-macros@googlegroups.com
*Date: *Thu, 3 Nov 2011 13:04:02 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: *excel-macros@googlegroups.com
).
Like if I have 2 workbook viz WB1 and WB2 then I want the 1st worksheet
of WB1 as 1st worksheet in a new workbook (say WB3) and again 1st worksheet
of WB2 as 2nd worksheet of WB3.
Thanks in advance.
Sandeep Chhajer.
Sent on my BlackBerryŽ from Vodafone
--
FORUM RULES (925+ members already
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 noorain.ans...@gmail.com wrote:
Dear Neil,
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 koul.ash...@gmail.com wrote:
try this
rename
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 jocky6...@gmail.com wrote:
Hi,
I made a Excel sheet with help of V lookup using
30 matches
Mail list logo