Re: $$Excel-Macros$$ Re: Autofill Macro

2014-05-10 Thread Vaibhav Joshi
Cheers!! On Sat, May 10, 2014 at 11:05 PM, Bill Q wrote: > Perfect ! Thanks very much Vabz. > > > On Saturday, 10 May 2014 13:25:29 UTC-4, Vabz wrote: > >> Hi >> >> See attached file.. Hope this is what exactly i want, i guess i am >> getting what you mean by autofill.. >> >> Cheers!! >> >> >>

Re: $$Excel-Macros$$ Re: Autofill Macro

2014-05-10 Thread Bill Q
Perfect ! Thanks very much Vabz. On Saturday, 10 May 2014 13:25:29 UTC-4, Vabz wrote: > > Hi > > See attached file.. Hope this is what exactly i want, i guess i am getting > what you mean by autofill.. > > Cheers!! > > > On Sat, May 10, 2014 at 8:44 PM, Bill Q >wrote: > >> Hi Guys, >> >> Thank

Re: $$Excel-Macros$$ regarding vlookup and wildcard function

2014-05-10 Thread Vaibhav Joshi
Cheers!! On Sat, May 10, 2014 at 1:37 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > thank you > > > On Fri, May 9, 2014 at 6:46 PM, Vaibhav Joshi wrote: > >> Hi >> >> It is because you have not referred correct row, when you are in row 4, >> you should refer to row 4 in column

Re: $$Excel-Macros$$ Re: Autofill Macro

2014-05-10 Thread Vaibhav Joshi
Hi See attached file.. Hope this is what exactly i want, i guess i am getting what you mean by autofill.. Cheers!! On Sat, May 10, 2014 at 8:44 PM, Bill Q wrote: > Hi Guys, > > Thanks for your replies. I should have attached a sample spreadsheet for > illustration & clarification purposes. Pl

$$Excel-Macros$$ Re: Autofill Macro

2014-05-10 Thread Bill Q
Hi Guys, Thanks for your replies. I should have attached a sample spreadsheet for illustration & clarification purposes. Please see attached. Very simply - whatever is in "A1" is to go into "B1" identically - the autofilled all the way down until it no longers encounters any data in "A". Tha

Re: $$Excel-Macros$$ Autofill Macro

2014-05-10 Thread Ashish Bhalara
See the attachment of your solution. Use this function... =IF(A2="","",CONCATENATE(COLUMN(),",",ROW())) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Sat, May 10, 2014 at 1:59 PM, Vaibhav Joshi wro

Re: $$Excel-Macros$$ Autofill Macro

2014-05-10 Thread Vaibhav Joshi
Hi See attachment.. It check if rows in col A is empty or not depending upon it puts value in respective rows of col. B ,C etc... If combination of row & col is empty no data will be filled. It takes care upto last Row & col. HTH//Cheers On Sat, May 10, 2014 at 6:20 AM, Bill Q wrote: >

Re: $$Excel-Macros$$ regarding vlookup and wildcard function

2014-05-10 Thread Sanjib Chatterjee
thank you On Fri, May 9, 2014 at 6:46 PM, Vaibhav Joshi wrote: > Hi > > It is because you have not referred correct row, when you are in row 4, > you should refer to row 4 in column A, but in your case you are referring > to one row above. > > See attached file. > > HTH//Cheers > > > On Fri, Ma

$$Excel-Macros$$ regarding not send any mail to Dinesh Kumar

2014-05-10 Thread Sanjib Chatterjee
It is jut a reply to your mail Mr Dinesh Kumar. why not sent any mail? My intention was not sent you any mail, as you are registered with the excel group the mail I sent the group automatically sent to you. As I am a member of the excel group I will send to group whenever I required, but If you

Re: $$Excel-Macros$$ Graph Query

2014-05-10 Thread Shrinivas Shevde
thanks problem solved On Sat, May 10, 2014 at 12:34 AM, ashish koul wrote: > wht do u wanna do .. its x y scatter chart > > > On Thu, May 8, 2014 at 4:59 PM, Shrinivas Shevde > wrote: > >> Dear All >> I received one excel file in whih there is a graph. >> When I try to edit series it shows X a

Re: $$Excel-Macros$$ Autofill Macro

2014-05-10 Thread 'karunanithi ramaswamy' via MS EXCEL AND VBA MACROS
 Hello, what is to be autofill. can u give what is in a1 to a5 and what is to be autofilled in b1 to b5 -r.karunanithi. On Saturday, May 10, 2014 6:20 AM, Bill Q wrote: I have spent the better part of 40 minutes searching the web for what I believe is a simple solution. I have found many answ

$$Excel-Macros$$ doc compare vba

2014-05-10 Thread Arindam Das
I got stuck at one place.If I compare 2 documents entirely(not page by page) how will I get the page numbers where we have the discrepancies.In the below mentioned code I want the page number to be return which are not matching with each other.I tried it but I failed. dim temp as string dim