Hello, how can I have uncertain number of input for VBA function?
Example, in SUM function, you may put in any numbers of cells
reference or values ==> =SUM(D7,D11,D8,F16).
In this case, 4 inputs. How can I set this up in VBA function?
--
Hello Dear
Try To concatenate using & operator.
If u want to concatenate a1 and b1 then try to use
=a1&"/"&b1
Hope It Will Help
Happy To Help
:)
Shyam
On Fri, Mar 12, 2010 at 11:21 AM, Abhishek Jain wrote:
> Dear Ayush,
>
> Thanks.
>
> I thought of this but in Summary sheet I would have
Hello Dear
Great Solution,Really appriciate the team work.
Happy to Help
:)
Shyam
On Fri, Mar 12, 2010 at 10:43 AM, Abhishek Jain wrote:
>
>
> -- Forwarded message --
> From: Abhishek Jain
> Date: Fri, Mar 12, 2010 at 10:42 AM
> Subject: Fetching Data from All Sheets to S
Hello Dear,
I have already viewed your problem.
please respond that what you want in pivot column and in pivot row.
Please reply so that we can prepare exact pivot.
Hope It Will Help
Happy To Help
:)
Shyam
On Fri, Mar 12, 2010 at 5:25 PM, satya narayana wrote:
>
>
> -- Forwarde
Hello Dear
Following is the answer for best describe your Question.
'''
We had very few.
The biggest was that they dropped "FileSearch".
which is used to search the filesystem for files matching specific criteria.
Instead, we had to write our own version of FileSearch
using the Filesystem object and the Folders and Files collections.
other than that, and the fact that
We're finaly going to Office 2007
VBA code-wise, what issues we may have ?
thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. J
Parag,
Please elaborate what data you want to pick and where ?
Suggestion: Please post new queries by creating new email.
Best regards,
AJ
On Fri, Mar 12, 2010 at 5:51 PM, Parag wrote:
> Hi,
> im attaching 2 file can anyone help me to conditional vlookup, i want to
> the data frm data1 f
Dear Ayush,
Thanks.
I thought of this but in Summary sheet I would have to manually select (or
type) the range of each sheet in Vlookup formula. Also I would have to make
a combined column in each sheet. Like I said there are around 66 sheets and
writing vlookup and make an additional column in e
Mel,
I did something similar to this (not sorting but filtering) for another
project. If you put a sample file of yours, I can help.
Best,
AJ
On Thu, Mar 11, 2010 at 10:22 PM, Mel wrote:
> I have a speadsheet that has 5 columns.
> (Headings are in row 2 and are: Cell A2=Date, B2=Name, C2=Pa
You're welcome Harry. :-)
On Thu, Mar 11, 2010 at 11:34 PM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> AJ,
>
> Thanks, this is exactly what i was looking for
>
> Thanks
>
> Harry
>
> On Mar 7, 10:53 pm, Abhishek Jain wrote:
> > Dear Harpreet,
> >
> > Check the sample file attache
Hi
The attached has a macro for saving 10 books according to names in the list on
Sheet1.
The Workbooks are saved to the default location, but that can be changed.
Not sure if it's what you want, but maybe it's a start.
Regards - Dave.
> Date: Thu, 11 Mar 2010 02:11:47 -0800
> Subject: Re: $$Exc
You are always welcome...!!
suggestion:- Please do not write all Caps while writing any email. Thanks.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Fri, Mar 12, 2010 at 3:44 PM, moham
13 matches
Mail list logo
