Hi team,
I am having 1 excel sheet which shows me error like " to many diff cell
format" while opening the file
. Can. Someone provide me the Solution for this.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titl
Hi team,
I am having 1excel workbook which contains 250 excel sheets and now I want
to extract those sheets into separate workbook for each sheets. Means I
want to create 250 workbooks from.250 sheets request u to can someone
provide me the vb code for this.
Need it little urgently.
--
Join off
ide the solution for the same
For this file u can create 20 to 30 col as dummy..
Awaiting for you revert..
--
Thanks & Regards,
Maulik Desai
9967363926
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
extract the data from the site & paste in excel with
takes lots of time because it contains lots of data.
Requred your input for this..
Thanks in advance
Awaiting for your reply...
--
Thanks & Regards,
Maulik Desai
9967363926
--
FORUM RULES (934+ members already BANNED fo
t; Thanks,
>
>
> Sent on my BlackBerry® from Vodafone
> Thanks & Regards.
> Kiran
>
> -Original Message-
> From: maulik desai
> Sender: excel-macros@googlegroups.com
> Date: Sun, 11 Dec 2011 14:31:50
> To:
> Reply-To: excel-macros@googlegroups.com
>
al Singh wrote:
> Attached is the updated file, now you won't need to prepare a separate
> table to get channel wise unique email id's...
>
>
>
> On Mon, Nov 21, 2011 at 10:09 PM, maulik desai
> wrote:
>
>> Thanks Deepak, Actually those id;'s i cant disclose it b
done
>
> Who are you_,Where are you___Who do you work
> forWhat is this for??_
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* maulik desai
> *Sent:* Sunday, December 04, 2011 1:41 AM
> *To:*
solution
Thanks
On Wed, Dec 7, 2011 at 7:26 PM, Sourabh Salgotra wrote:
> chk attachment
>
>
> On Tue, Dec 6, 2011 at 12:51 PM, maulik desai wrote:
>
>> hi don,
>> thanks for the reply i am working for international firm as sr. Mis
>> executive and this is for 1
,Where are you___Who do you work
> forWhat is this for??_
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: maulik desai
> Sent: Sunday, December 04, 2011 1:41 AM
> To: excel-macros@googlegroups.com
> Su
ironment to
> ensure that no unwanted risk lies open by taking off outlook security. If
> you are not able to change the option, then I am afraid I do not have a
> solution. Maybe someone from the forum can share some advice?
>
> Regards
>
> Sam Mathai Chacko
>
>
> On Sun, De
o are you_,Where are you___Who do you work
> forWhat is this for??_
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: maulik desai
> Sent: Sunday, December 04, 2011 1:41 AM
> To: excel-macros@googlegroups
anks & Regards,
Maulik Desai
9967363926
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answ
:
> Go to Tools>Macro>Security>Programmatic Access>Never Warn
>
> Sam
>
>
> On Tue, Nov 29, 2011 at 8:28 AM, maulik desai wrote:
>
>> Thanks you so much deepak for your great support lastly i just want to
>> ask you 1 thing that when ever i clicked on
>
table to get channel wise unique email id's...
>
>
>
>
> On Mon, Nov 21, 2011 at 10:09 PM, maulik desai wrote:
>
>> Thanks Deepak, Actually those id;'s i cant disclose it but yes Email ids
>> are not common & it is also not based on channel name.its is base
t starts with a clean sheet beginning at row 7 assuming
> your Batch’s are actually named Batch 1, batch 2, etc. Click to see!!
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* maulik desai
> *Sent:* Sunday, November 20, 2011 3:21 AM
> *To
e:
> Sure Maulik... I just want to know those email ids (which you want to add
> in CC & BCC) are common or they'll be changed with every channel name...??
>
> Regards
> Deepak
>
>
> On Sun, Nov 20, 2011 at 2:43 PM, maulik desai wrote:
>
>> Thanks you so mu
;> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>> *From:* maulik desai
>> *Sent:* Sunday, November 13, 2011 10:31 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Required Progres bar / Status bar while
>> macro
On Sun, Nov 20, 2011 at 2:43 PM, maulik desai wrote:
> Thanks you so much deepak for your effort & sorry for late reply becasue i
> can not able to use Gmail from my office pc & i check your file it is
> working very well just one thing i want to ask u that i want to add
>
n 2007 platform..I hope it'll work
> in 2003 as well...
>
> Sorry.. I couldn't attached the excel file with my previous post because
> I's in office at that time & can't access to gmail over
> there...
>
> Regards
> Deepak
>
>
> On Tue, Nov 15,
; to send emails..??
>
>
>
> On Sun, Nov 13, 2011 at 10:30 PM, maulik desai wrote:
>
>> Hi Team,
>>
>> I am having 1 excel sheet in that i have to prepare Chennel wise detail
>> report on a every week & i have to send that information to respective
>> chenne
MyArray(R, 4) & "" & _
>"" & MyArray(R, 5) & "" & _
>""
>Next C
>End If
>Next R
>Call SendEmail(RecAdd, EmailBody)
> Next i
> End Sub
>
> Sub SendEmail(Recei
ro for that. Not 100% checked.
>
> Regards
>
> Sam Mathai Chacko
>
> On Mon, Nov 14, 2011 at 7:07 AM, Deepak Pal Singh <
> deepaktheind...@gmail.com> wrote:
>
>> Can you provide the format of your data.. Also want to know do you
>> outlook to send emails.
he same for others formulas.
Regards.
Daniel
** **
*De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
*De la part de* maulik desai
*Envoyé :* mardi 22 février 2011 18:55
*À :* excel-macros@googlegroups.com
*Objet :* $$Excel-Macros$$ How to use sumproduct Formula in Macro***
attched file ,sheet
2)
Thanks in advance.
--
Thanks & Regards,
Maulik Desai
9967363926
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Adv
un, Jul 31, 2011 at 5:50 PM, Daniel wrote:
>
> Hi,
>
>
>
> In AF2 (array formula, validate with Ctrl+Shift+Enter) :
>
>
>
> =INDEX($A$1:$AE$1,1,MAX(IF($B$2:$AE$2="P",COLUMN($B$2:$AE$2
>
>
>
> Copy down.
>
>
>
> Regards.
>
>
>
&g
4) = LvDtls.Cells(cntr, 4) + 1
> LvDtls.Cells(cntr, LvDtls.Cells(cntr, 256).End(xlToLeft).Column + 1) =
> Format(DataWkSht.Cells(1, ColCntr), "dd-mmm-")
>
> SumRow = LvSummary.Range("A65536").End(xlUp).Row + 1
> LvSummary.Cells(SumRow, 1) = DataWkSht.C
Hi All,
Awaitnig your reply
Kindly revert with the solution.
On Sun, Jun 19, 2011 at 5:42 PM, maulik desai wrote:
> Hi All,
>
> I am having 1 Excel sheet which contains 3 sheets
> In sheet1 main database i have to update in every month for Leave
> calculation
> In Sheet2
sheet)
In sheet3 i have to update the candidates details as per his leave dates
(format & details given in attached sheet)
Request you to kindly provide the solution with the help of formulas & macro
For more details kindly find the attached file.
--
Thanks & R
Values to Variables
>
> Ans=WorksheetFunction.Vlookup(Lookup_Value,Lookup_Vector,Colnum,0)
>
>
>
> On Sun, May 8, 2011 at 4:45 AM, STDEV(i) wrote:
>
>> It would be easy for anyone in the group to respond, if you can send a set
>> of sample data.
>>
>>
>&g
Values to Variables
>
> Ans=WorksheetFunction.Vlookup(Lookup_Value,Lookup_Vector,Colnum,0)
>
>
>
> On Sun, May 8, 2011 at 4:45 AM, STDEV(i) wrote:
>
>> It would be easy for anyone in the group to respond, if you can send a set
>> of sample data.
>>
>>
>&g
also in output
sheets manually (need to open each sheet &change the new file name in that)
Is there any way that whenever I changed the file name of database ,the same
new range also updated in output sheets automatically.
Thanks In advance.
--
Thanks & Regards,
wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> P Before printing, think about the environment.
>
>
> --
>
> ---
mp; ")*(DB!$AP$2:$AP$46803=""Yes""))")
>
> End If
>
> End Sub
>
>
>
> You’ll have to do the same for others formulas.
>
> Regards.
>
> Daniel
>
>
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
ur exact
> requirement until unless you explain it in a better and clear way.
>
> Hope that makes sense :)
>
> ---
> Ms.Exl.Learner
> ---
>
>
> On Wed, Feb 23, 2011 at 10:44 PM, maulik desai wrote:
>
>> Hi ashish sir,
>
you to kindly add this two things inz macros & resend it
Thanks you very much for your time and Support
On Thu, Feb 24, 2011 at 10:46 PM, Mahesh parab wrote:
> Hi Maulik
>
> find attach, hope this is done.
>
> On Mon, Feb 21, 2011 at 11:01 PM, maulik desai
> wrote:
>
wrote:
> see if that helps
> On Tue, Feb 22, 2011 at 11:07 PM, maulik desai
> wrote:
>
>>
>> In My excel database there are Huge database availble
>> for this eg I have given the unique current status (which can be repeted
>> many times )
>> what I want is
s the just small part of the database.
For more infomation kindly ref the attachment
--
Thanks & Regards,
Maulik Desai
9967363926
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tr
me.
On 2/21/11, Mahesh parab wrote:
> Hi Maulik
>
> do u want to delete column which contain only "NA" , not "Na"
> is both are different or same
>
> On Mon, Feb 21, 2011 at 12:08 PM, maulik desai
> wrote:
>
>> Hi mahesh,
>>
>> in a
quired columns "
> as far as New workboooks in output folder are concern reflecting same
> columns as mention by u
>
> On Sun, Feb 20, 2011 at 12:27 PM, maulik desai
> wrote:
>
>> One more thing i have noticed that macro delete the complete Column
>> contains &q
Any progress from any member awaiting
On Wed, Feb 16, 2011 at 1:52 AM, maulik desai wrote:
> Hi Group,
>
> I JUST want Macro instend of Formulas used in sheets
>
> I want a macro which can give me the output like formulas (i dont want to
> use formulas in sheets as it
Any Progress...
On Wed, Feb 16, 2011 at 1:23 AM, maulik desai wrote:
> Hi Group,
>
> I am having database with many columns outof that in one column name is
> current status in that column there are 37 unique attrition codes are
> available ,each code has its logic behind
st 1&3,5
Process 4-Test1 & 2
Process 5 -Test1, 2,3
I just want that above columns(whatever the value in that) to be saved with
other details except " sheet Name should Be" column in outout folder .
Thanks in advance.
On Sun, Feb 20, 2011 at 12:13 PM, maulik desai wrote:
> Hi M
iles, its working correctly. only i done changes to
> remove NA in existing one.
> for C-Test as per u its 1&3 it should be 1,3,5 as per data
> hope its as per u r requirement, i herewith attach revised workbook as well
> steps in word file since u r getting below error
>
>
>
Thanks Ashish Sir,
For such nice solution & time
Sorry for late reply
On Tue, Feb 8, 2011 at 8:23 PM, ashish koul wrote:
> try this
>
>
> On Mon, Feb 7, 2011 at 9:10 PM, maulik desai wrote:
>
>> Hello sir
>>
>> please provide me the correction in your macr
te separate workbook for each value in column J, create a
> folder name Output in thisworkbooks path (where u save the file)
> for each new workbook it will border the used cells
>
>
>
> On Wed, Feb 16, 2011 at 2:14 AM, maulik desai wrote:
>
>> Hi Gurus,
>>
&g
ame sheet name & date.
--
Thanks & Regards,
Maulik Desai
9967363926
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join ou
thanks
On 2/5/11, maulik desai wrote:
> hello Sir,
>
> Sorry for delay replay please find the dummy my database sheet with the
> same
> column no which is apper in database
>
> i want the same macro or formula as a output for attached file.
>
> Once again Congrates As
gt; process 3- 152
> ref type 3-178
> final status-236
>
>
>
> On Wed, Feb 2, 2011 at 9:09 PM, maulik desai wrote:
>
>> Hello sir please find the file as requested
>>
>> -- Forwarded message --
>> From: ashish koul
>> Dat
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/g
ets(1).Cells(i, j + 3).Value
> End If
>
> s = s + 1
> End If
> Next j
> s = s + 1
> Next i
> Application.ScreenUpdating = True
> Application.DisplayAlerts = True
> End Sub
>
>
>
> On Tue, Feb 1, 2011 at 10:20 AM, maulik desai wrote:
>
>>
>> Hi Guru,
>
r latest entry's ref type
as out put as mention in above case (mention in yellow)
--
Thanks & Regards,
Maulik Desai
9967363926
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Hi Group,
Request you to kindly provide me the solution of my below problem.
Ayush :Request you to kindly look into it and provide me the solution
its bit urgent.
Thanks in Advance.
On 1/16/11, maulik desai wrote:
> Hi Excel Gurus,
>
> I am having excel database I want the Diff excel
Hi,
Can some provide me the solution,Awaiting for your responce.
On 1/16/11, maulik desai wrote:
> Hi excel Guru's
>
> 1)I want a macro which can able to Provide the unique entry on the
> basis of walk in date , Date of Birth & name
>
> 2)I am having 3 excel Sheets. In
Hi group,
Awaiting for your help
On 1/16/11, maulik desai wrote:
> Hi Excel Gurus,
>
> I am having excel database I want the Diff excel workbook to be save
> on basis of walkin date & Process from sheet1 (Excel Database) in
> D:\output Data\Sheet name & walk In Da
perfect.
Thanks in advance.
On 1/16/11, ashish koul wrote:
> check sheet 2 see if it helps
>
> On Sun, Jan 16, 2011 at 4:37 PM, maulik desai wrote:
>
>> Hi Excel Guru's,
>>
>> I have to extract data from Server & after cleaing Data i have to
>> paste that dat
3 Will be the Output File
Please Find attached file for your ref & better Understading.
--
Thanks & Regards,
Maulik Desai
9967363926
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Sheet 2 (Summay Sheet) for More detail Please ref Attached excel
Sheet.
Thanks In Advance
--
Thanks & Regards,
Maulik Desai
9967363926
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tric
Hi excel Guru's
I am having 2 Excel sheet.Sheet 1 is the Output File & sheet2 is a database
I want to find the latest entry/ value form sheet2 to Sheet1 by the
help of formulas request you to please find the attached file with eg.
--
Thanks & Regards,
Maulik Des
mp; same task for batch 4
(eg. given in Attached file for better understaing )
need you support
--
Thanks & Regards,
Maulik Desai
9967363926
--
--
Some important links for excel users:
1. Follow us on TWITTER fo
Can be get in Excel Sheet
Hope u guys can help me
Thanks & Regards,
Maulik Desai
9967363926
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twi
HI Guys
Any updates on this !
On 1/28/10, maulik desai wrote:
>
> Hi,
>
> I want a macro which can help to compare two or more then two excel sheet
>
> By row wise
> or by column wise or
> complete sheet
>
> or should have options to select the mode like sai
orksheet & paste it to One Master excel sheet in Sheet1 & sheet2
Respectively)
I will appriciate for quick responce from all gurus in excel
Pls help
Thanks in advance
--
Thanks & Regards,
Maulik Desai
9967363926
--
---
Hi,
I want a Add in which can help me to send mails on a specific time
which is fixed by me
--
Thanks & Regards,
Maulik Desai
9967363926
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Hi
I want a macro that can do a filter data by comments & filter data by colour
--
Thanks & Regards,
Maulik Desai
9967363926
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tr
ards,
Maulik Desai
9967363926
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add
es & paste in 1 master
sheet one below other
awaiting for reply
--
Thanks & Regards,
Maulik Desai
9967363926
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
like to learn Macro
I will Appriciate for helper
Thanks once again
--
Thanks & Regards,
Maulik Desai
9967363926
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
WORKBOOK NOT A SHEET PLS ALL WHO
SEND ME FILES THAT IS TO UNPROTECT SHEET NOT ENTIREWORKBOOK
KINDLY HELP ON THIS
THANKS
On 1/13/10, Mahesh Kumar wrote:
> Send your excel file
> regards
> Mahesh
>
> On Jan 10, 3:32 pm, maulik desai wrote:
> > Hi,
> >
> > Ca
word protercted workbook if they forget his password)
awaiting for your responce
Thanks
On 1/13/10, Mahesh Kumar wrote:
> Send your excel file
> regards
> Mahesh
>
> On Jan 10, 3:32 pm, maulik desai wrote:
> > Hi,
> >
> > Can any one provide me the password
& Regards,
Maulik Desai
9967363926
--
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free
nced, let me know.
>
> Regards
> Hari Kumar
>
> On Fri, May 8, 2009 at 11:46 AM, PRATEEK PAHWA wrote:
>
>>
>> Hi All,
>>
>> Please help me out with an Ebook on excel.
>>
>> Thanks & Regards
>> Prateek Pahwa
>>
&
ords etc.) i want
that same features in excel
in excel there is option called spelling but it not work first we need to
add words then it works pls help me on above case
if any one knows pls let me know
--
Thanks & Regards,
Maulik Desai
99
stay connected to friends and
> family<http://www.microsoft.com/windows/windowslive/default.aspx>
> >
>
--
Thanks & Regards,
Maulik Desai
9967363926
--~--~-~--~~~---~--~~
73 matches
Mail list logo
