$$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

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 ronsmith...@gmail.com wrote: I have spent the better part of 40 minutes searching the web for what I believe is a simple solution.

$$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$$ regarding vlookup and wildcard function

2014-05-10 Thread Sanjib Chatterjee
thank you On Fri, May 9, 2014 at 6:46 PM, Vaibhav Joshi v...@vabs.in 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,

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

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

$$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. Thanks.

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 ronsmith...@gmail.com wrote: Hi Guys, Thanks for your replies. I should have attached a sample spreadsheet for illustration

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 v...@vabs.in 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,

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 ronsm...@gmail.com javascript:wrote: Hi

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

2014-05-10 Thread Vaibhav Joshi
Cheers!! On Sat, May 10, 2014 at 11:05 PM, Bill Q ronsmith...@gmail.com 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!!