Open sheet 1 by 1 with the help of macro use file dilaog method to get the
names of the files and save it in xls Extension.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Monday, December 22,
Dear Mandeep Baluja, I want this file dialog method to be added in below
mentioned code. I tried it with hit trial but could not succeed. Please
add this command at suitable position with related parameters in below
code. Thanks
On Monday, December 22, 2014 12:32:54 PM UTC+3, Mandeep Baluja
Check VBA's most useful built in functions
http://excelautomate.blogspot.in/2013/11/vbas-most-useful-built-in-functions.html
On Thursday, 7 November 2013 11:13:59 UTC+5:30, rutuja patekar wrote:
I am taking data from one workbook and finding the same data in different
workbook.
I am using
Hi
Thanks for the reply now I got it.
Regards
Rajesh
On 10/31/13, Rajan sharma rajansharma9...@gmail.com wrote:
Hi, CSE stands for Control + Shift + Enter ( Enter in same time after
entering the formula)
With warm regards,
Rajan Sharma
On Thu, Oct 31, 2013 at 10:20 AM, kasper
Hi
Thanks for the formula, but the formula is not working for me. What is
with cse
Rgards
Rajesh
On Wednesday, October 30, 2013 5:08:00 PM UTC+5:30, kasper wrote:
Hi Experts
Please refer the attached document and tell me how can I get the min
and max values of each month from the given
Hi, CSE stands for Control + Shift + Enter ( Enter in same time after
entering the formula)
With warm regards,
Rajan Sharma
On Thu, Oct 31, 2013 at 10:20 AM, kasper rajeshkainikk...@gmail.com wrote:
Hi
Thanks for the formula, but the formula is not working for me. What is
with cse
PLEASE SHARE YOUR WORKBOOK
On Wednesday, March 27, 2013 2:03:30 PM UTC+5:30, Sundarvelan wrote:
Dear Friends,
Please help me in using the cell address in offset.
=IF((IF('TNCMCHIS_CALC-2'!$R8=1,'TNCMCHIS_CALC-2'!$A8,OFFSET('TNCMCHIS_CALC-2'!$R8,0,-17,1,1)))=$A6,OFFSET(
Selection.FormulaArray = =RC[-4]:R[ z ]C[-4]RC[-3]:R[ z
]C[-3]RC[-2]:R[ z ]C[-2]
On Jun 19, 4:29 pm, hanumant shinde arsfan2...@yahoo.co.in wrote:
Hi Friends,
I really need urgent help. i want to deliver smthing by tomorrow and i stuck
here.
Selection.FormulaArray =
Hi. Mahesh,
OFFSET is either an Excel function or a VBA method. I’ll explain the Excel
function first.
It is simplest to give some examples :
=OFFSET(B2,1,0) is equal to : B3 (shifting one row downwards)
=OFFSET(B2,-1,0) is equal to : B1 (shifting one row upwards)
=OFFSET(B2,0,2)
hi dileep
can u explain m with the example by attaching the excel sheet ...so that i
can understand in a better way if u dont mind
On Fri, Jun 19, 2009 at 12:47 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Vinay,
$ sign is used to make the cell references as absolute (locked), means
Hi Vinay,
Please find the workbook attached with the explanation. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Fri, Jun 19, 2009 at 3:16 PM, vinay keni kenivi...@gmail.com wrote:
hi dileep
thanks aa lot dilip
On Fri, Jun 19, 2009 at 8:57 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Vinay,
Please find the workbook attached with the explanation. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New
The $ is referred to as an Anchor.
For example:
Let's say that you have a list of numbers in column A that represent Hours
A
row1: HOURS
row2: 1
row3: 2
row4: 3
row5: 4
And in row 1, (columns B through D) you place hourly rates
B C D
5 10 15
Now, next to each of the
Hi,
Take a look at the following links...
http://www.15seconds.com/issue/020130.htm
http://www.computerperformance.co.uk/vbscript/wmi.htm
I am still not very clear about what exactly your are trying to do. That is
may be because I personally haven't done this before. Still I would like to
ajit.na...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, April 29, 2009 2:55:37 AM
Subject: $$Excel-Macros$$ Re: Use VBA to determine Windows Groups permissions
for a folder
Hi,
Take a look at the following links...
http://www.15seconds.com/issue/020130.htm
http
)
Does that help?
I appreciate your assistance...
paul
_
From: Ajit Navre ajit.na...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, April 29, 2009 2:55:37 AM
Subject: $$Excel-Macros$$ Re: Use VBA to determine Windows Groups
permissions for a folder
Hi,
Take a look
i know smwhat about using macrosbest way to learn thm is to start
experimenting with anything..im on 9216796066.this is the thing
by which we can reduce our working time to a great extent...in all macro
is the ultimate tool to get in the world of prograqmming for non
Advance filter is the option without any formulas to remember...
below are the steps;
select the data,
copy (ctrl+c)
go to data filter advance filter
select the action tab of - copy to another location
click in the box of copy to, to get the cursor blinking and then
select the desired cell where
Hi Dave,
Using advanced filter can solve your problem. Use Data-Filter-Advanced
Filter (Unique records only must be ticked) and give the reference of the
cell you wanna place your filtered data. Then you can sort the data.
File is enclosed for your reference.
Regards
CA. Atul Singhal
19 matches
Mail list logo