date:20131009

Re: $$Excel-Macros$$ Date format system using VBA

2013-10-09 Thread xlstime

please share ur vba code with example sheet

.

Enjoy
Team XLS



On Thu, Oct 10, 2013 at 6:39 AM, Viswanathan Yoganathan <
viswanathan.yoganat...@asia.xchanging.com> wrote:

>  Hi,
>
>  I am copying the date as text from one sheet and pasting to another sheet
> using the code activesheet.paste. when i do it so, it is converting to
> general number 41135.
>
>  after formatting to d/mm/, the date that is having greater than 12
> get converted exactly to d/mm/ where as date that is having less than
> 12 for which the month and date get interchanged.
>
>  example: there are 3 lines having date 19/07/2013, 22/07/2013,
> 3/10/2013. The first two dates results exactly as same where as the
> 3/10/2013 get converted to 10/03/2013. Please help me on this what could be
> wrong,
>
>  Thanks,
> Vishwa.
>
>
>
>  "CONFIDENTIALITY NOTICE: This message and any attachment are
> confidential and may also be privileged. If you are not the intended
> recipient of this e-mail you may not copy, forward, disclose or otherwise
> use it or any part of it in any form whatsoever. If you are not the
> intended recipient please telephone or e-mail the sender and delete this
> message and any attachment from your system."
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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 answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Date format system using VBA

2013-10-09 Thread Viswanathan Yoganathan

Hi,

I am copying the date as text from one sheet and pasting to another sheet using 
the code activesheet.paste. when i do it so, it is converting to general number 
41135.

after formatting to d/mm/, the date that is having greater than 12 get 
converted exactly to d/mm/ where as date that is having less than 12 for 
which the month and date get interchanged.

example: there are 3 lines having date 19/07/2013, 22/07/2013, 3/10/2013. The 
first two dates results exactly as same where as the 3/10/2013 get converted to 
10/03/2013. Please help me on this what could be wrong,

Thanks,
Vishwa.



"CONFIDENTIALITY NOTICE: This message and any attachment are confidential and 
may also be privileged. If you are not the intended recipient of this e-mail 
you may not copy, forward, disclose or otherwise use it or any part of it in 
any form whatsoever. If you are not the intended recipient please telephone or 
e-mail the sender and delete this message and any attachment from your system."

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Macro code requirement

2013-10-09 Thread Mukesh Kumar

Thanks a lot Ravinder ji for your help.


On Wed, Oct 9, 2013 at 6:05 PM, Ravinder wrote:

> PFA..actually if you will try to rename excel sheet with “M/s Ram Niwas &
> Sons, K”, excel does not allow u rename and len of sheetname should not be
> more than 31 character, so I have taken only 31 character if text is more
> than 31 character.
>
> ** **
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar
> *Sent:* Wednesday, October 09, 2013 5:09 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Macro code requirement
>
> ** **
>
> Dear Sir,
>
> This code is working fine in very first file i have sent you but is
> showing error in next file I have sent you. Please execute macro in
> attached file & see the error.
>
> Regards,
>
> Mukesh Kumar
>
> ** **
>
> On Wed, Oct 9, 2013 at 5:00 PM, Ravinder 
> wrote:
>
> PFA……..
>
>  
>
>  
>
> Sub Button2_Click()
>
> Application.ScreenUpdating = False
>
> 'Application.Calculation = xlCalculationManual
>
> Dim sh As Worksheet
>
> Dim datash As Worksheet
>
> Set datash = Sheets("data")
>
> Set sh = ActiveSheet
>
> For i = 1 To 300
>
> Sheets.Add after:=Sheets(Sheets.Count)
>
> shname = WorksheetFunction.Substitute(datash.Cells(i, 1), "/", " ")
>
> ActiveSheet.Name = shname
>
>  
>
> sh.UsedRange.Copy
>
> Sheets(shname).Range("a4").PasteSpecial xlPasteAll
>
> Selection.Columns.AutoFit
>
> Sheets(shname).Range("a1").ColumnWidth = 15.4
>
> ActiveWindow.DisplayGridlines = False
>
> Sheets(shname).Range("a7").Validation.Delete
>
> Sheets(shname).Range("a7") = datash.Cells(i, 1)
>
>  
>
> Next
>
> sh.Select
>
> MsgBox "Done"
>
> End Sub
>
>  
>
> *From:* Ravinder [mailto:ravinderexcelgr...@gmail.com]
> *Sent:* Wednesday, October 09, 2013 4:04 PM
> *To:* 'excel-macros@googlegroups.com'
> *Cc:* Soum (quote.ex...@gmail.com)
> *Subject:* RE: $$Excel-Macros$$ Macro code requirement
>
>  
>
> pfa
>
>  
>
> *From:* excel-macros@googlegroups.com [
> mailto:excel-macros@googlegroups.com ] *On
> Behalf Of *Mukesh Kumar
> *Sent:* Wednesday, October 09, 2013 3:24 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Macro code requirement
>
>  
>
> Dear Sir,
>
> I have an excel file in which there are 300 names are there & they are
> given different targets. Now I have to take print outs of these 300 names.
> I have prepared drop down list of 300 names in cell A7 in attached sample
> file.
>
> My requirement is that I want 300 sheets according to dropdown list.
> Please provide macro code for this.
>
>  Sample file is attached. Please note that dropdown list in this sample
> file is in A7 cell. I want macro code that works on dropdown list
> regardless of dropdown list position i.e it may be in any other cell in my
> other files.
>
> Regards,
>
> Mukesh Kumar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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 answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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 answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and thei

Re: $$Excel-Macros$$ Macro code requirement

2013-10-09 Thread Mukesh Kumar

Dear Sir,

Please check that there is no changes done in your attached file.

Regards,
Mukesh Kumar


On Wed, Oct 9, 2013 at 4:46 PM, Ravinder wrote:

> pfa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar
> *Sent:* Wednesday, October 09, 2013 4:44 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Macro code requirement
>
> ** **
>
> Dear Ravinder Ji,
>
> I have checked the file, but it is making 50 sheets only. Secondly when I
> tried this macro code in my another file then it is showing error, & after
> ignoring error it is making sheets in which formatting gets disturbed. ***
> *
>
> My requirement is that the macro code first asks for drop down list
> location & after this the macro generate as many as sheets according to
> list.
>
> Please find attached another sample file.
>
> Regards,
>
> Mukesh Kumar
>
> ** **
>
> On Wed, Oct 9, 2013 at 4:04 PM, Ravinder 
> wrote:
>
> pfa
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar
> *Sent:* Wednesday, October 09, 2013 3:24 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Macro code requirement
>
>  
>
> Dear Sir,
>
> I have an excel file in which there are 300 names are there & they are
> given different targets. Now I have to take print outs of these 300 names.
> I have prepared drop down list of 300 names in cell A7 in attached sample
> file.
>
> My requirement is that I want 300 sheets according to dropdown list.
> Please provide macro code for this.
>
>  Sample file is attached. Please note that dropdown list in this sample
> file is in A7 cell. I want macro code that works on dropdown list
> regardless of dropdown list position i.e it may be in any other cell in my
> other files.
>
> Regards,
>
> Mukesh Kumar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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 answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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 answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> ** **
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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 answered.
> 2) Don't post a question in the thread of anothe

$$Excel-Macros$$ Macro code requirement

2013-10-09 Thread Mukesh Kumar

Dear Sir,

I have an excel file in which there are 300 names are there & they are
given different targets. Now I have to take print outs of these 300 names.
I have prepared drop down list of 300 names in cell A7 in attached sample
file.

My requirement is that I want 300 sheets according to dropdown list. Please
provide macro code for this.

 Sample file is attached. Please note that dropdown list in this sample
file is in A7 cell. I want macro code that works on dropdown list
regardless of dropdown list position i.e it may be in any other cell in my
other files.

Regards,
Mukesh Kumar

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Book.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Consolidate to one working sheet

2013-10-09 Thread अनिल नारायण गवली

 Dear Harisha,

The files which u have sent is in different format.  kindly send proper format.

Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd


On Wed, Oct 9, 2013 at 2:54 PM, Hari  wrote:
> Dear Excel gurus,
>
> Please suggest me in how to consolidate these files into one working sheet.
> Got too many files like this. Manually, opening each file, copying and
> pasting in one working sheet.
>
> Waiting for your valuable help.
>
> Thanks,
> Harish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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 answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Re: Read a Text file with delimiter as comma and import the infor into excel sheet

2013-10-09 Thread De Premor


Another way, little longer in code :D and just a little faster
I'am using manual method, fist, openit as textfile and split by 
delimiter, then copy each column to specified destination


in attached sample with 500k row data, can processed in 2,6 seconds @ my 
old comp




On 09-10-2013 13:13, Anoop K Sharma wrote:

Hi Sonika,

PFA, You can browse the text file you want to store in Excel.. This 
program runs for 3 separated value..


Just open the Excel file, click on button, browse the text file.

Regards,
Anoop
Sr. Developer


On Wed, Oct 9, 2013 at 11:08 AM, rani > wrote:


hi

On Monday, November 5, 2007 11:52:56 PM UTC+5:30, SK wrote:

Hello Everybody,

I am new to Excel VBA. I am trying to read a text file in which
columns are separated by commas, for eg:

1,2,3
2,3,4
3,4,5
4,5,6

I canwrite this to an Excel worksheet. So, final Excel sheet has 3
columns and 4 rows(number of rows depends on on how many
entries we
have in a text file). So the worksheet will look like:

1 | 2 | 3
2 | 3 | 4
3 | 4 | 5
4 | 5 | 6

If I specify the range of the cells for example B9, my first
column
starts from B9, second from C9 and thrid from D9. I want to do
something different. I want to have different range set for
diffferent
column.
Can I specify that the first column should populate in range
B9:Bx((where x is the number of rows in the text file) and second
coulmn populate in range G9:Gx(where x is the number of rows
in the
text file) and third column populates in range I9:Ix((where x
is the
number of rows in the text file).

Thanks for your help in advance.
~SK

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
forum @ https://www.facebook.com/discussexcel

FORUM RULES

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 answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any
security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to excel-macros+unsubscr...@googlegroups.com
.
To post to this group, send email to excel-macros@googlegroups.com
.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




--
Regards,
Anoop
Sr. Developer
Facebook ID - https://www.facebook.com/anooop.k.sharma
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES

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 answered.

2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security 
measure.

4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners 
and members are not responsible for any loss.

---
You received this message because you are subscribed to the Google 
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 o

Re: $$Excel-Macros$$ Complicated Formula (automatic add back)

2013-10-09 Thread Kartik Dale

Hi Amar,

As Ravinder said your question was not clear. I tried to resolve your
query, plz find attachment. If this is not you are looking for let us be
clear on your question.

Regards,
Kartik


On Mon, Oct 7, 2013 at 4:36 PM, amar takale  wrote:

> Dear Experts
>
> Pls anybody guide me on this issue
>
> Regards
> Amar
>
>
>
> On Mon, Oct 7, 2013 at 11:35 AM, amar takale  wrote:
>
>> Dear Ravinder
>> Actually I want Previous balance Quantity of A ( 5 unit) in cell H23 to
>> add this 5 Quantity in next cell F27 Same Name A means total Received
>> Quantity+Previous balance Quantity of A (Answer is 2+5=7) like this
>> next...
>> Regards
>> Amar
>>
>>
>> On Sat, Oct 5, 2013 at 2:48 PM, Ravinder wrote:
>>
>>> Query is not clear..
>>>
>>> ** **
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *amar takale
>>> *Sent:* Friday, October 04, 2013 7:05 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Complicated Formula (automatic add back)
>>>
>>> ** **
>>>
>>> Dear Experts
>>>
>>> Pls solution my critical formula issue in excel.I hope anyone help me to
>>> resolve this issue.
>>>
>>> Regards
>>>
>>> Amar
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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 answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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 answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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 answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
>

Re: $$Excel-Macros$$ Date format system using VBA

$$Excel-Macros$$ Date format system using VBA

Re: $$Excel-Macros$$ Macro code requirement

Re: $$Excel-Macros$$ Macro code requirement

$$Excel-Macros$$ Macro code requirement

Re: $$Excel-Macros$$ Consolidate to one working sheet

Re: $$Excel-Macros$$ Re: Read a Text file with delimiter as comma and import the infor into excel sheet

Re: $$Excel-Macros$$ Complicated Formula (automatic add back)

8 matches

Site Navigation

Mail list logo

Footer information