$$Excel-Macros$$ Re: Need excel formula

[Lalit_Mohan]

Hi Sriram,
 
Could you please explain excatly what you are looking for so that we can 
provide you the solution related to the query.
 
Regards,
Lalit Mohan

On Friday, 29 June 2012 12:10:47 UTC+5:30, sriram ji wrote:

>
> Dear Excel Guru,
>
> Please find the attached file and help me 
>
>
>
> Thanks & Regards,
>
> Sriram G
> Chennai
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: Book3.xlsx

[Lalit_Mohan]

Hi Neeraj,
 
Hope it helps you
 
Sub FindFormula()
Dim rngDtRange  As Range
Const strDataRange  As String = "B1:B1000"
Dim firstAddressAs String
Const strFindFormulaAs String = "=RANDBETWEEN?"
With ThisWorkbook.Worksheets("Sheet1").Range(strDataRange)
Set rngDtRange = .Find(what:=strFindFormula, LookIn:=xlFormulas)
If Not rngDtRange Is Nothing Then
firstAddress = rngDtRange.Address
Do
rngDtRange.Offset(, 1).Value = 
Replace(Replace(strFindFormula, "=", ""), "?", "")
Set rngDtRange = .FindNext(rngDtRange)
Loop While Not rngDtRange Is Nothing And rngDtRange.Address <> 
firstAddress
End If
End With
End Sub
 
Regards,
Lalit Mohan

On Friday, 29 June 2012 12:11:51 UTC+5:30, neeraj chauhan wrote:

>  Dear Experts,
>
>  
>
> I have a sheet kindly find it,  if we have two formulas in one  *“B” *Colum 
> and I want to paste special only one (Randbetween) formula then how can I 
> do it? 
>
>  
>
> Kindly find the attached sheet for the concerned.
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Need excel formula

[NOORAIN ANSARI]

Dear Sriram,

Please try it..

=INDEX($H$1:$N$1,0,SMALL(IF($H2:$N2=$C2,COLUMN($H$1:$N$1),""),COLUMN(A1))-7)

with ctrl+shift+Enter

Hope it helps to u.

See attached sheet.

-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com



PM, sriram ji  wrote:

>
> Dear Excel Guru,
>
> Please find the attached file and help me
>
>
>
> Thanks & Regards,
>
> Sriram G
> Chennai
>
> --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Copy of Need formula(sreeram).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Book3.xlsx

[Lalit_Mohan]

Hi Neeraj,
 
Revised with formula copy
 
Sub FindFormula()
Dim rngDtRange  As Range
Const strDataRange  As String = "B1:B1000"
Dim firstAddressAs String
Const strFindFormulaAs String = "=RANDBETWEEN?"
With ThisWorkbook.Worksheets("Sheet1").Range(strDataRange)
Set rngDtRange = .Find(what:=strFindFormula, LookIn:=xlFormulas)
If Not rngDtRange Is Nothing Then
firstAddress = rngDtRange.Address
Do
rngDtRange.Offset(, 1).Formula = rngDtRange.Formula
Set rngDtRange = .FindNext(rngDtRange)
Loop While Not rngDtRange Is Nothing And rngDtRange.Address <> 
firstAddress
End If
End With
End Sub
 
Regards,
Lalit Mohan

On Friday, 29 June 2012 12:11:51 UTC+5:30, neeraj chauhan wrote: 
>
>  Dear Experts,
>
>  
>
> I have a sheet kindly find it,  if we have two formulas in one  *“B” *Colum 
> and I want to paste special only one (Randbetween) formula then how can I 
> do it? 
>
>  
>
> Kindly find the attached sheet for the concerned.
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: Need excel formula

[Rajan_Verma]

 
 
use this in D14 and Paste in All Cells :
 
=IFERROR(INDEX($H$13:$N$13,1,LARGE(--($H14:$N14=D$13)*COLUMN($H$13:$N$13),1)-7),"")
 
 
Rajan.

On Friday, 29 June 2012 12:10:47 UTC+5:30, sriram ji wrote:

>
> Dear Excel Guru,
>
> Please find the attached file and help me 
>
>
>
> Thanks & Regards,
>
> Sriram G
> Chennai
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Introduce Yourself !!

[Abdulgani Shaikh]

Sorry for late.

Myself Shaikh AbdulGani A.R., working as Taxation Manager
also practicing as Tax Consultant in field of Income-tax, TDS and MH VAT.

This group helped me a lot for making lot of templates for smooth working.

Regard



On Wed, Jun 13, 2012 at 3:47 PM, Tinusz Tamás  wrote:

> Hi all,
>
> Name : *Tamás TINUSZ*
>
> * *
>
> gender: male
>
> Age : 47
>
> Current City : Budapest (Hungary / Europe)
>
> Job: Customer Service – Office Leader in Waterworks
>
> Experience : ~25Years
>
>
> Facebook: https://www.facebook.com/tinusz.tamas
>
> Interest : Excel Formulas, VBA, tipps & tricks..
>
> Mobile : +36204227400
>
> 
>
> ** **
>
> Thanking You
>
> ** **
>
> *Tamás*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain
> *Sent:* Friday, June 08, 2012 9:22 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Introduce Yourself !!
>
> ** **
>
> Hey all new and current posters,
>
>  
>
> Welcome to excel group,one of the largest online community of excel Fans!*
> ***
>
>  
>
> I hope you enjoy your time here & find this forum to be a friendly and
> knowledgeable community. Please feel free to post a small introduction, a
> friendly hello or tell us a bit about yourself. Why not tell us where are
> you from, what you do, what your interests are, how old you are, which is
> your favourite excel site or blog is or anything else that comes to mind!
>
> Thanks for your time
> Ayush Jain
>
> Group Manager
>
> Microsoft MVP
>
> --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: Automatic Email from Excel

[Vish]

Sorry VBS file could not get attached.
 
Copy paste the below code in a notepad and save it with extension *.VBS*
** 

Dim myExcel
Set myExcel = CreateObject("Excel.Application") 
myExcel.DisplayAlerts = False
myExcel.AskToUpdateLinks = False
myExcel.AlertBeforeOverwriting = False
myExcel.Workbooks.Open("C:\Users\vishwamitrad_m\Documents\Book1.xlsx")
myExcel.visible=true 
 
 

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ Re: Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

[Asa Rossoff]

Hi H.,

True, Value2 is not necessary for the Format function version, but depending
on which alternative you are comparing it to, it is faster, more
predictable, or both.

 

with the options:

CELL

CELL.Value

CELL.Value2

CELL.Text

.

* CELL is a Range object, so if you use it in the context of a value, you
are implicitly asking for the default property of the range, which is for
most practical purposes the same as the Value property.  Always best to be
explicit, though (especially because there are times when the Range might be
used when you want the Value and vice-versa)

* CELL.Value is the value of the cell, converted to a similar VBA datatype
based on the contents of the cell and the way the cell is formatted.  The
problems with this are: 1) this takes time, and you often don't need this to
occur, 2) the VBA datatypes do not hold exactly the same information, so
there is a loss of data.  For example, the VBA Date datatype is lower
resolution for times (while supporting a wider range of dates) than
date/times on the worksheet.  The VBA Currency data type is not a floating
point number, but a scaled decimal, which is it's strength (no rounding
errors) -- but currencies on the worksheet are floating point numbers.  VBA
Currency stores 4 digits afte the decimal place; floating point numbers on
the worksheet store slightly over 15 significant digits (either side of the
decimal).

* CELL.Value2 provides the exact underlying value of cells.  It's the only
way to preserve those values in VBA, and it's faster than CELL.Value.
Value2 is always my first choice.  I fall back to Value when I require the
datatype conversion that Value does.

* CELL.Text is a texual representation of the cell's data as formatted on
the worksheet.  This often results in a loss of underlying data.  Unless you
need a formatted string, it requires conversion back to an appropriate
datatype (whether you do it explicitly or allow VBA to do it implicitly),
and CELL.Text returns "" for hidden columns.

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of tangledweb
Sent: Thursday, June 28, 2012 10:25 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Can I get the day of the week (e.g.
Friday) from the date already encoded in a string?

 

Thanks Asa and belatedly Noorain.  The format function worked and as it
happens the other method was returning the wrong day for all those who might
use it.

The .value2 does not seem to be necessary but I left it anyway.

 


On Wednesday, June 27, 2012 10:09:16 PM UTC-7, tangledweb wrote:

Asa!  Good to hear from you.  I am fine.  Hope the same for you.   The 
example I posted seemed to work but I admit I did not check to see if 
the correct day was returned.  Tomorrow I will do that and try out 
your format function version (which I think someone else posted 
earlier but I had not tried it yet). 

On Wed, Jun 27, 2012 at 9:35 PM, Asa Rossoff  wrote: 
> Hi!  Hope you are well. 
> 
> 
> 
> The "VBA way" is to use VBA's Format function (Replace CELL with the range

> object for the cell desired): 
> 
> Format(CELL.Value2, "") 
> 
> 
> 
> If you wanted to use the TEXT function, the example given -- I believe -- 
> will return incorrect results.  These versions would return the correct 
> result (replace WORKSHEET/CELL): 
> 
> Worksheetfunction.Text(CELL, "") 
> 
> WORKSHEET.evaluate("text(" & CELL.address & ","""")") 
> 
> WORKSHEET.evaluate("text(" & CELL.value2 & ","""")") 
> 
> WORKSHEET.evaluate("text(""" & CELL.value & ""","""")") 
> 
> 
> 
> The Format function would be my preference, but of the TEXT function 
> versions, the first is most efficient, then second, then third.  The first

> uses a cell reference to supply the date value, the second a dateserial 
> (Value2 returns a number for dates), the third a text representation of
the 
> date (the Value property converts date/time values on the worksheet to
VBA's 
> Date datatype, but when you concatenate it with a string, VBA's datatype 
> coercion behavior is to convert it to a text representation using the
system 
> locale's short date and/or short time settings). 
> 
> 
> 
> The previous example acquired the cell value via it's Text property, which

> is dangerous and rarely desired.  Text returns the value of the cell as 
> formatted, but if the column is hidden, it returns an empty string.  Also,

> the Day function will cause trouble.  It's a common misunderstanding to 
> think it should be used with the Text function, but this is almost never 
> desired.  Day returns a number between 1 and 7 to indicate the day of the 
> week.  Text formats dates or dateserial numbers, not day numbers.  Text
will 
> interpret numbers between 1 and 7 as the first 7 days on it's dateserial 
> calendar, which are 1/1/1900 through 1/7/1900. 
> 
> 
> 
> Asa 
> 
> 
> 
> 
> 
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]

> On Behalf Of tangledw

$$Excel-Macros$$ What do you recommend?? If Formulas, Tables with macros, vlookups?

[Jorge Marques]

Hi guys i have a sheet where I every month i calculate the costs for
logistics, there are 3 conditions (KM, Weight in KG, and Volumes), where i
have to calculate depending on the data put in the columns B,C,D

if it is zone 1,2,3 and has the volumes or weight under those limits it
puts those values. if zone 4 and under those 3 limits we have to multiply
the value in the table with the extra km in column D.

Until now i only had 2 transport company´s so I used if formulas to
calculate the costs, but now I have 3 more, a total of 5, and I think if i
use if formulas it will be heavy on the code and generate errors.

What do you recommend?

Thank you very much in advance.

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

transaa.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ What do you recommend?? If Formulas, Tables with macros, vlookups?

[Asa Rossoff]

Hi Jorge,

Looks like this can be handled using lookup formulas.

 

One good way to perform lookups is to have a number representing each of
your criteria each alone in their own cell, preferably all in the same table
for all transporters.  You can use pivot tables to generate the cross
referenced charts you have now for easy human-reading for each shipper, and
your Cost table can use lookup formulas to do its calculation.

 

I'm a bit confused about a few details, and don't have a lot of time right
now, but will try to take another look in the coming days if you haven't a
solution yet.

 

Some questions though:

You refer to 6 items of data:  (1) Transporter (2) Zone (3) Volumes (4)
Weight/KG (5) Distance/KM (6) Cost.

 

The charts for each Transporter seem to contain 4 items of data.  5
including the name of the transporter.  I assume the row 2 of the
transporter tables contain ranges for VOLUMES, row 3 ranges for WEIGHT/KG;
Column 1 zontains ZONE.  The data points in cells B4:D7 then must contain
either DISTANCE/KM or COST… But which?  And where is the other item?

 

It's possible to perform a lookup that checks multiple criteria and finds
the intersection on a table like this.  Perhaps--since the ranges for
volumes and KG seem to be the same for all transporters, as do the number of
zones--insert another column either before or after the zone column for the
Shipper name/ID, and include all transporters' data in the one table while
maintaining a similar format.  You can then use a lookup strategy that might
go like this:  use MATCH functions for each criteria, and logic to determine
the right combination of criteria, then use the index function to retrieve
the selected column, and another index function to retrieve the selected
row.  Place a space between those two functions (all in the same formula)
and Excel will return the intersection of that row and column, which will be
a single matching cell.

 

Asa

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jorge Marques
Sent: Friday, June 29, 2012 1:54 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ What do you recommend?? If Formulas, Tables with
macros, vlookups?

 

Hi guys i have a sheet where I every month i calculate the costs for
logistics, there are 3 conditions (KM, Weight in KG, and Volumes), where i
have to calculate depending on the data put in the columns B,C,D

 

if it is zone 1,2,3 and has the volumes or weight under those limits it puts
those values. if zone 4 and under those 3 limits we have to multiply the
value in the table with the extra km in column D.

 

Until now i only had 2 transport company´s so I used if formulas to
calculate the costs, but now I have 3 more, a total of 5, and I think if i
use if formulas it will be heavy on the code and generate errors.

 

What do you recommend?

 

Thank you very much in advance.

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: Help in Access

[Lalit_Mohan]

HI Manoj,
 
You can try this query in database may be it helps you
 
select id from Tab_Data GROUP BY id
 
(where id is the field name and Tab_Data is table name. you can add more 
columns to it just by adding column name with , and the same column in 
group by seperated by ,)
 
Regards,
Lalit Mohan

On Friday, 29 June 2012 15:14:18 UTC+5:30, Manoj Kumar wrote:

> Dear Experts,
>
>
> I have data in month wise data in Access in different query..
> Please help me to find unique id From DATA in attached file..
>
>
>
> Regard
> Manoj
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Re: Help in Access

[Manoj Kumar]

where is the option of Tab_Data...



On Fri, Jun 29, 2012 at 3:37 PM, Lalit_Mohan wrote:

> HI Manoj,
>
> You can try this query in database may be it helps you
>
> select id from Tab_Data GROUP BY id
>
> (where id is the field name and Tab_Data is table name. you can add more
> columns to it just by adding column name with , and the same column in
> group by seperated by ,)
>
> Regards,
> Lalit Mohan
>
> On Friday, 29 June 2012 15:14:18 UTC+5:30, Manoj Kumar wrote:
>
>> Dear Experts,
>>
>>
>> I have data in month wise data in Access in different query..
>> Please help me to find unique id From DATA in attached file..
>>
>>
>>
>> Regard
>> Manoj
>>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: Help in Access

[Lalit_Mohan]

Hi Manoj,
 
My previous post is just an example to show how you can get unique id just 
replace columna and table name accordingly.
 
Regards,
Lalit Mohan

On Friday, 29 June 2012 15:14:18 UTC+5:30, Manoj Kumar wrote:

> Dear Experts,
>
>
> I have data in month wise data in Access in different query..
> Please help me to find unique id From DATA in attached file..
>
>
>
> Regard
> Manoj
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-2

[vijay yadav]

Hi Lalit
 
Please,Please help me 
 
Please make a little change in superb macro which you had mode.
 
The macro worked but since it doesn't fulfil one condition I have to check 
the entire data again one by one which 
 
defetas the very purpose of using macro
 
Please modify the macro AND HELP ME
 
Regards
vIJAY yADAV 
 
 

On Friday, 29 June 2012 14:30:31 UTC+5:30, vijay yadav wrote:

> Hi Lalit_Mohan / VBA experts
>  
> Please help me to correct the  macro in the above attached sheet to get 
> the desired output.
>  
> Macro does the following 
>  
> Q) X6-1,4,5,6,9,X7-223,56,67,X30 in cell c34 is  written as
>  
> A ) X6-1 in cell c34
>  X6-4 in cell c35
>  X6-5 in cell c36 
>  X6-6 in cell C37
>  X6-9 in cell c38 
>  X6-X7-223 in cell C39( BUT I WANT X7-223 )
>  X6-56 in cell cell C40( BUT I WANT X7-56 ) 
>  X6-67 in cell c41  ( BUT I WANT X7-67 )
>  X6-X30 in cell c42( BUT I WANT X30 )
>  
> the logic is that the letter X at right has to be the prefix
> and not the left one
>  
> No rows should be created as suitable rows are already availiable
>  
> Please help
>  
> Regards
>  
> Vijay yadav
>   
>  
> Regards
> Vijay Yadav
>
>
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-2

[Lalit_Mohan]

Hi Vijay,
 
Try this
 
Sub SeperateData()
Dim varVal  As Variant
Dim lngLoop As Long
Dim rngRangeAs Range
Dim strIni  As String
Dim strFinalAs String
Dim strTemp As String
Dim lngVal  As Long
Dim lngCell As Long

Set rngRange = ActiveSheet.Range("A2:A3400")
For lngCell = 0 To rngRange.Rows.Count
If LCase(rngRange.Resize(1, 1).Offset(lngCell).Value) Like "?x*" Or 
LCase(rngRange.Resize(1, 1).Offset(lngCell).Value) Like "x*" Then
varVal = Split(rngRange.Resize(1, 1).Offset(lngCell), ",")
For lngLoop = LBound(varVal) To UBound(varVal)
If LCase(varVal(lngLoop)) Like "x*" Or 
LCase(varVal(lngLoop)) Like "?x*" Then

ComeAgain:
strIni = Trim(varVal(lngLoop))
strFinal = strIni
Else
strTemp = ""

If Trim(LCase(varVal(lngLoop))) Like "x*" Or 
Trim(LCase(varVal(lngLoop))) Like "?x*" Then GoTo ComeAgain
For lngVal = 0 To UBound(Split(strIni, "-"))
If lngVal < UBound(Split(strIni, "-")) Then
strTemp = strTemp & IIf(Split(strIni, 
"-")(lngVal) <> "", Split(strIni, "-")(lngVal), "-")
End If
Next lngVal

If Evaluate("=mid(""" & varVal(lngLoop) & """,1,1)") = 
"-" Then
varVal(lngLoop) = Evaluate("=mid(""" & 
varVal(lngLoop) & """,2,LEN(""" & varVal(lngLoop) & """)-1)")
End If

strFinal = strTemp & "-" & varVal(lngLoop)
End If
rngRange.Resize(1, 1).Offset(lngCell + lngLoop).Value = 
strFinal
Next lngLoop
End If
Next lngCell

End Sub
 
 
Regards,
Lalit Mohan
 

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ IN TROUBLE

[Azhar Rai]

Hello Dear Gurus

I want to add columns in an *excel sheet* between *R* and *AQ* to be total 
in number as in cell *H5* and I also want this to be replicated in sheet2, 
sheet3, and sheet4 and these columns  should also carry the formula from 
column *R*.

Gurus please help me.

Thanks


-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ IN TROUBLE

[NOORAIN ANSARI]

Dear Azhar,

Please share sample workbook with Group.

On Fri, Jun 29, 2012 at 4:38 PM, Azhar Rai  wrote:

> Hello Dear Gurus
>
> I want to add columns in an *excel sheet* between *R* and *AQ* to be
> total in number as in cell *H5* and I also want this to be replicated in
> sheet2, sheet3, and sheet4 and these columns  should also carry the formula
> from column *R*.
>
> Gurus please help me.
>
> Thanks
>
>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: IN TROUBLE

[Lalit_Mohan]

Hi Azhar,
 
Try this and change accordingly
 
Sub InsertColumnWithFormula()
Const lngNoOfColAs Long = 2
Dim varSheets() As Variant
Dim lngLoop As Long
Const strStartRange As String = "R1"


varSheets = Array("Sheet1", "Sheet2", "Sheet3")

Application.DisplayAlerts = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False

For lngLoop = LBound(varSheets) To UBound(varSheets)
With ThisWorkbook.Worksheets(varSheets(lngLoop))
.Range(strStartRange).Offset(, (lngNoOfCol - 1) * 
-1).Resize(, lngNoOfCol).EntireColumn.Copy
.Range(strStartRange).Offset(, 1).Insert Shift:=xlToRight
End With
Next lngLoop

Application.CutCopyMode = xlCopy
Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
Application.DisplayAlerts = True
End Sub
 
Regards,
Lalit Mohan

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Need a VBA code to display name in "Last Name, First Name" format

[sharath chandra]

Hello Experts,

I have attached a spreadsheet. In Column F we have a name. By default it is 
validated in the format "First Name (and Middle Name if exists) Last Name".

So when someone types in a name in any of the cell in Column F, it should 
convert the format to "Last Name, (comma) First (and Middle) Name".

I hope I am able to explain it clearly.

Thank you in advance,

Sharath

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

NeedVBA-Code.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-2

[vijay yadav]

Hi Lalit_Mohan
 
Great work !  wow ! excellent !This works perfect!
 
U are really a expert and a genius  in this field
 
This will really  save a lot of time and work for me 
 
Regards
Vijay yadav
 

On Friday, 29 June 2012 14:30:31 UTC+5:30, vijay yadav wrote:

> Hi Lalit_Mohan / VBA experts
>  
> Please help me to correct the  macro in the above attached sheet to get 
> the desired output.
>  
> Macro does the following 
>  
> Q) X6-1,4,5,6,9,X7-223,56,67,X30 in cell c34 is  written as
>  
> A ) X6-1 in cell c34
>  X6-4 in cell c35
>  X6-5 in cell c36 
>  X6-6 in cell C37
>  X6-9 in cell c38 
>  X6-X7-223 in cell C39( BUT I WANT X7-223 )
>  X6-56 in cell cell C40( BUT I WANT X7-56 ) 
>  X6-67 in cell c41  ( BUT I WANT X7-67 )
>  X6-X30 in cell c42( BUT I WANT X30 )
>  
> the logic is that the letter X at right has to be the prefix
> and not the left one
>  
> No rows should be created as suitable rows are already availiable
>  
> Please help
>  
> Regards
>  
> Vijay yadav
>   
>  
> Regards
> Vijay Yadav
>
>
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-23,56,67,X30 in cell c34 to be written as X6-1 in cell c34 X6-4 in cell c35 and

[vijay yadav]

Hi Lalit_Mohan
 
Great work !  wow ! excellent !This works perfect!
 
U are really a expert and a genius  in this field
 
This will really  save a lot of time and work for me 
 
Regards
Vijay yadav

On Thursday, 28 June 2012 15:39:56 UTC+5:30, vijay yadav wrote: 
>
> Dear members, 
>
> Please help me solve the above problem using "macro" or "array formulae". 
>
> Problem -  data seperated by hypen - and comma , to be written in 
> rows existing below (should not insert rows but place data in already 
> existing rows ) 
>
>
> eg 1 
>
> X6-1,4,5,6,9,X7-23,56,67,X30 in cell C34 
>
> ANSWER should be - 
>
> X6-1 in cell c34 
> X6-4 in cell c35 
> X6-5 in cell C36 
> X6-6 in cell C37 
> X6-9 in cell C38 
> X7-23 in cell C39 
> X7-56 in cell C40 
> X7-67 in cell C41 
> X30  in cell C42 
>
> eg 2 
>
> X6-33,36 in cell C55 
>
> Answer should be 
> X6-33 in cell C55 
> X6-36 in cell C56 
>
>
> A) similar data is saved in the rows one below other seperated by suitable 
> rows 
> The macro should consider  3000 rows containg any data seperated by - and 
> , 
>
> B) data in the cell may contain 1 to 3 hypen and at most 15 commas 
>
> C) letter 'X' will be always present in data 
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Help in Access

[╰» ℓαℓιт мσαнη]

Hi Manoj,

Try this

select [store id] from [Acer All Data] group by [store id]
select [store id] from [Apr'12] group by [store id]
select [store id] from [Mar'12] group by [store id]
select [store id] from [May'12] group by [store id]

Regards,
Lalit Mohan


On Fri, Jun 29, 2012 at 3:14 PM, Manoj Kumar  wrote:
> Dear Experts,
>
>
> I have data in month wise data in Access in different query..
> Please help me to find unique id From DATA in attached file..
>
>
>
> Regard
> Manoj
>
> --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Macro timings should be multiple based on date changing

[Lokesh Loki]

Hi All,

Please find the attached excel file, and i need total macro timings based
on date changes.

Let me know for any clarification.

Regards
Lokesh.M

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

multiple the timings based on date changes.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Replace data from another sheets by adding raw

[Ashish Bhalara]

On Fri, Jun 29, 2012 at 7:20 PM, Ashish Bhalara
wrote:

> Dear experts,
>
> I need a function or macro to replace data from another sheets by addition
> of raw, these addition of raw is depend on the record of another sheet. you
> can find attached sheet for better understanding. I can do it manually but
> there are thousands of record to process so its not possible to do this.
>

> Thanks & regards.
>
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards.

Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Help in Access

[NOORAIN ANSARI]

Dear Manoj,

Please use it..

SELECT Month, Store ID
FROM [Acer All Data]
WHERE ((Month)="apr'12"));

-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Fri, Jun 29, 2012 at 7:11 PM, ╰» ℓαℓιт мσαнη wrote:

> Hi Manoj,
>
> Try this
>
> select [store id] from [Acer All Data] group by [store id]
> select [store id] from [Apr'12] group by [store id]
> select [store id] from [Mar'12] group by [store id]
> select [store id] from [May'12] group by [store id]
>
> Regards,
> Lalit Mohan
>
>
> On Fri, Jun 29, 2012 at 3:14 PM, Manoj Kumar 
> wrote:
> > Dear Experts,
> >
> >
> > I have data in month wise data in Access in different query..
> > Please help me to find unique id From DATA in attached file..
> >
> >
> >
> > Regard
> > Manoj
> >
> > --
> > FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > NOTE : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > To unsubscribe, send a blank email to
> > excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ Macro timings should be multiple based on date changing

[Lalit Mohan]

Hi Lokesh,

 

Please find the attached. Change the formula accordingly.

 

 

Regards,

Lalit Mohan

www.excelfox.com/forum

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: Friday, June 29, 2012 7:18 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro timings should be multiple based on date
changing

 

Hi All,

Please find the attached excel file, and i need total macro timings based on
date changes. 

Let me know for any clarification.

Regards
Lokesh.M

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Copy of multiple the timings based on date changes.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Copy JPG images from Word into Excel

[Paul Schreiner]

I'm sorry, but here's the longer version of the story:

I have an Oracle database.
I use Excel as a front-end to the database.
The Excel application is used to store and retrieve over 60,000 "documents"
Each "document" consists of 2 to 130 sheets.
Reporting tools allow me to search the content of all the documents very 
quickly.
The application includes over 30,000 lines of VBA code
(There is MUCH more going on with this application beyond storage and retrieval)

I am now in the process of converting/loading over 3,000 "inspection" documents 
into this application.

Unfortunately, the people who "Designed" the inspection documents chose to use 
a 
Word Processing program instead of a spreadsheet.
(the oldest documents were originally in WordPerfect, then later converted to 
Word)

I've moved most of the Word documents into specific folders.
I now am writing VBA code (in Excel) to open each of the Word Documents,
read the document and place the data into appropriate cells of the Excel 
templates.

I successfully used:

    Set DocRange = mWord.ActiveDocument.Range(Start:=0, End:=0)
    DocRange.wholestory
    TxtArray = Split(DocRange.Text, Chr(13))

to loop through the TxtArray and populate the rows of the Excel file.
-

My problem now is that many of the documents contain image files.
-


I have spent 30+ hours searching and testing various approaches...
I've discovered that while Excel utilizes the Shapes collection,
SOME of these images in my Word files are found in the InlineShapes collection.

With this code:

For Each iShape In ActiveDocument.InlineShapes
    iShape.Select
    Selection.Copy
 Next iShape

I am able to copy each shape to the ClipBoard, 
and I'm confident that I could switch to the Excel application and Paste it.

I have also tried saving the Word document in HTML format, which effectively
copies out all of the images (which is REALLY nice).

However, I have another problem.
I cannot seem to be able to figure out WHERE the shape is in the Word file.
According to the documentation,
InlineShapes are attached to a Range object (which is not quite the same as a 
Range in Excel)
But I cannot seem to be able to figure out how to determine which LINE the 
image 
is attached to!

And I haven't had any luck reading the HTML documents to determine placement.

Any ideas?
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Automatic Email from Excel

[ashwani agnihotri]

Hi,

I have a query..suppose i put some thing in column B and i have mail id in
column C i want to sent the mail on that ID.

In the example given below if i enter done in column B a mail should be
send on address entered in column C

   ABC

ram







sham

done

*sham@xyzmail*



rahim

done

*rahim@xyzmail*



Abdul








Can someone help me with this??


On Thu, Jun 28, 2012 at 4:05 PM, NOORAIN ANSARI wrote:

> Dear Hemanath,
>
> Please try it..
>
> Sub maildata()
> Dim olApp As Outlook.Application
> Dim olMail As MailItem
> Dim i As Integer, j As Integer
> Dim sh As Worksheet
> On Error Resume Next
> Application.ScreenUpdating = False
> Set olApp = New Outlook.Application
> Set olMail = olApp.CreateItem(olMailItem)
> Set sh = ThisWorkbook.Sheets(1)
> With sh
>   j = sh.Range("B" & Rows.Count).End(xlUp).Row
>   For i = 2 To j
>   If CDate(.Cells(i, "B")) = Date Then
>  With olMail
> .To = .Cells(i, "D")
> .CC = "noorain.ans...@gmail.com"
> .Subject = .Cells(i, "C")
> .Body = "Hi" & vbCrLf & vbCrLf & "Please find the attached
> Report" & " Thanks " & vbCrLf & vbCrLf & vbCrLf & "Regards" & vbCrLf & "
> Noorain Ansari"
> .Display
>  End With
>   End If
>   Next i
> End With
>   Set olMail = Nothing
>   Application.ScreenUpdating = True
>   On Error GoTo 0
> End Sub
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Thu, Jun 28, 2012 at 2:29 PM, hemanath dhanasekar 
> wrote:
>
>> Friends,
>>
>> I have an excel spreadsheet with dates updated on it, all I need is that
>> the system should automatically send an Email to the specified email
>> address automatically by picking up that particular date.
>>
>> Ex:
>>
>> Date:Subject  To
>>
>> 29/06/2012 Renew your Insurancehema5s...@gmail.com
>>
>> so, on 28th or 29th the system should automatically send an email and to
>> that particular person with that subject from spreadsheet.
>>
>> is that Possible? if yes means please help me.
>>
>> --
>> Thanks
>> Hemanath.D
>>
>>  --
>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

[ashish koul]

can you attach the sample file

On Fri, Jun 29, 2012 at 9:18 PM, jmothilal  wrote:

> Dear any one
>
> I want 3 cell values in 1 cell line by line
>
> Thanks in advance
>
> like
>
>  MOTHILAL
> NAVEEN
> RAJA MOTHILAL NAVEEN RAJA
>
> --
>
> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
> :Otteri, Vellore-2*
>
>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/* 


P Before printing, think about the environment.

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

[jmothilal]

On Fri, Jun 29, 2012 at 9:19 PM, ashish koul  wrote:

> can you attach the sample file
>
>
> On Fri, Jun 29, 2012 at 9:18 PM, jmothilal  wrote:
>
>> Dear any one
>>
>> I want 3 cell values in 1 cell line by line
>>
>> Thanks in advance
>>
>> like
>>
>>  MOTHILAL
>> NAVEEN
>> RAJA MOTHILAL NAVEEN RAJA
>>
>> --
>>
>> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
>> :Otteri, Vellore-2*
>>
>>
>>  --
>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/* 
>
>
> P Before printing, think about the environment.
>
>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

MERGE 1 CELL.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

[ashish koul]

Sub breaktext()
For i = 1 To Sheets(1).Range("a65356").End(xlUp).Row
splitdata = Split(Sheets(1).Range("a" & i).Value, Chr(10))
Sheets(1).Range(Cells(i, 2), Cells(i, 2 + UBound(splitdata))).Value =
splitdata
Next
End Sub


On Fri, Jun 29, 2012 at 9:21 PM, jmothilal  wrote:

>
>
> On Fri, Jun 29, 2012 at 9:19 PM, ashish koul wrote:
>
>> can you attach the sample file
>>
>>
>> On Fri, Jun 29, 2012 at 9:18 PM, jmothilal  wrote:
>>
>>> Dear any one
>>>
>>> I want 3 cell values in 1 cell line by line
>>>
>>> Thanks in advance
>>>
>>> like
>>>
>>>  MOTHILAL
>>> NAVEEN
>>> RAJA MOTHILAL NAVEEN RAJA
>>>
>>> --
>>>
>>> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
>>> :Otteri, Vellore-2*
>>>
>>>
>>>  --
>>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *http://www.excelvbamacros.com/*
>> *http://www.accessvbamacros.com/* 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>  --
>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
>
> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
> :Otteri, Vellore-2*
>
>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/* 


P Before printing, think about the environment.

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

---

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

[Aditya Tyagi]

=B1&CHAR(10)&C1 &CHAR(10)&D1 try this

On Sat, Jun 30, 2012 at 5:00 AM, ashish koul  wrote:

> Sub breaktext()
> For i = 1 To Sheets(1).Range("a65356").End(xlUp).Row
> splitdata = Split(Sheets(1).Range("a" & i).Value, Chr(10))
> Sheets(1).Range(Cells(i, 2), Cells(i, 2 + UBound(splitdata))).Value =
> splitdata
> Next
> End Sub
>
>
> On Fri, Jun 29, 2012 at 9:21 PM, jmothilal  wrote:
>
>>
>>
>> On Fri, Jun 29, 2012 at 9:19 PM, ashish koul wrote:
>>
>>> can you attach the sample file
>>>
>>>
>>> On Fri, Jun 29, 2012 at 9:18 PM, jmothilal  wrote:
>>>
 Dear any one

 I want 3 cell values in 1 cell line by line

 Thanks in advance

 like

  MOTHILAL
 NAVEEN
 RAJA MOTHILAL NAVEEN RAJA

 --

 *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
 :Otteri, Vellore-2*


  --
 FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

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


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *http://www.excelvbamacros.com/*
>>> *http://www.accessvbamacros.com/* 
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>  --
>>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>
>>
>> --
>>
>> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
>> :Otteri, Vellore-2*
>>
>>
>>  --
>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/* 
>
>
> P Before printing, think about the environment.
>
>
>  --
> FORUM RULES (986+ 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 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) Cr

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

[jmothilal]

i am using office 2003,  are u send sample worksheet
Thanks
Mothilal

On Fri, Jun 29, 2012 at 9:46 PM, Aditya Tyagi  wrote:

> =B1&CHAR(10)&C1 &CHAR(10)&D1 try this
>
>
> On Sat, Jun 30, 2012 at 5:00 AM, ashish koul wrote:
>
>> Sub breaktext()
>> For i = 1 To Sheets(1).Range("a65356").End(xlUp).Row
>> splitdata = Split(Sheets(1).Range("a" & i).Value, Chr(10))
>> Sheets(1).Range(Cells(i, 2), Cells(i, 2 + UBound(splitdata))).Value =
>> splitdata
>> Next
>> End Sub
>>
>>
>> On Fri, Jun 29, 2012 at 9:21 PM, jmothilal  wrote:
>>
>>>
>>>
>>> On Fri, Jun 29, 2012 at 9:19 PM, ashish koul wrote:
>>>
 can you attach the sample file


 On Fri, Jun 29, 2012 at 9:18 PM, jmothilal wrote:

> Dear any one
>
> I want 3 cell values in 1 cell line by line
>
> Thanks in advance
>
> like
>
>  MOTHILAL
> NAVEEN
> RAJA MOTHILAL NAVEEN RAJA
>
> --
>
> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
> :Otteri, Vellore-2*
>
>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




 --
 *Regards*
 * *
 *Ashish Koul*
 *http://www.excelvbamacros.com/*
 *http://www.accessvbamacros.com/* 


 P Before printing, think about the environment.


  --
 FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

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


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com

>>>
>>>
>>>
>>> --
>>>
>>> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
>>> :Otteri, Vellore-2*
>>>
>>>
>>>  --
>>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *http://www.excelvbamacros.com/*
>> *http://www.accessvbamacros.com/* 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Pr

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

[Aditya Tyagi]

On Sat, Jun 30, 2012 at 5:21 AM, jmothilal  wrote:

> i am using office 2003,  are u send sample worksheet
> Thanks
> Mothilal
>
>
> On Fri, Jun 29, 2012 at 9:46 PM, Aditya Tyagi wrote:
>
>> =B1&CHAR(10)&C1 &CHAR(10)&D1 try this
>>
>>
>> On Sat, Jun 30, 2012 at 5:00 AM, ashish koul wrote:
>>
>>> Sub breaktext()
>>> For i = 1 To Sheets(1).Range("a65356").End(xlUp).Row
>>> splitdata = Split(Sheets(1).Range("a" & i).Value, Chr(10))
>>> Sheets(1).Range(Cells(i, 2), Cells(i, 2 + UBound(splitdata))).Value =
>>> splitdata
>>> Next
>>> End Sub
>>>
>>>
>>> On Fri, Jun 29, 2012 at 9:21 PM, jmothilal  wrote:
>>>


 On Fri, Jun 29, 2012 at 9:19 PM, ashish koul wrote:

> can you attach the sample file
>
>
> On Fri, Jun 29, 2012 at 9:18 PM, jmothilal wrote:
>
>> Dear any one
>>
>> I want 3 cell values in 1 cell line by line
>>
>> Thanks in advance
>>
>> like
>>
>>  MOTHILAL
>> NAVEEN
>> RAJA MOTHILAL NAVEEN RAJA
>>
>> --
>>
>> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
>> :Otteri, Vellore-2*
>>
>>
>>  --
>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum
>> in signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/* 
>
>
> P Before printing, think about the environment.
>
>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



 --

 *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
 :Otteri, Vellore-2*


  --
 FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

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


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com

>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *http://www.excelvbamacros.com/*
>>> *http://www.accessvbamacros.com/* 
>>>
>>>
>>> P Before printing, think abo

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

[jmothilal]

Thanks so much its working .

Thanks with Mothilal.J


On Fri, Jun 29, 2012 at 9:55 PM, Aditya Tyagi  wrote:

>
>
> On Sat, Jun 30, 2012 at 5:21 AM, jmothilal  wrote:
>
>> i am using office 2003,  are u send sample worksheet
>> Thanks
>> Mothilal
>>
>>
>> On Fri, Jun 29, 2012 at 9:46 PM, Aditya Tyagi wrote:
>>
>>> =B1&CHAR(10)&C1 &CHAR(10)&D1 try this
>>>
>>>
>>> On Sat, Jun 30, 2012 at 5:00 AM, ashish koul wrote:
>>>
 Sub breaktext()
 For i = 1 To Sheets(1).Range("a65356").End(xlUp).Row
 splitdata = Split(Sheets(1).Range("a" & i).Value, Chr(10))
 Sheets(1).Range(Cells(i, 2), Cells(i, 2 + UBound(splitdata))).Value =
 splitdata
 Next
 End Sub


 On Fri, Jun 29, 2012 at 9:21 PM, jmothilal wrote:

>
>
> On Fri, Jun 29, 2012 at 9:19 PM, ashish koul wrote:
>
>> can you attach the sample file
>>
>>
>> On Fri, Jun 29, 2012 at 9:18 PM, jmothilal wrote:
>>
>>> Dear any one
>>>
>>> I want 3 cell values in 1 cell line by line
>>>
>>> Thanks in advance
>>>
>>> like
>>>
>>>  MOTHILAL
>>> NAVEEN
>>> RAJA MOTHILAL NAVEEN RAJA
>>>
>>> --
>>>
>>> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan
>>> Complex :Otteri, Vellore-2*
>>>
>>>
>>>  --
>>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum
>>> in signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *http://www.excelvbamacros.com/*
>> *http://www.accessvbamacros.com/* 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>  --
>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum
>> in signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
>
> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
> :Otteri, Vellore-2*
>
>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank e

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

[NOORAIN ANSARI]

Dear Moti Lal,

You can use below UDF for dynamically

Function combine_cells(rng As Excel.Range) As String
Dim cell As Excel.Range
For Each cell In rng.Cells
combine_cells = combine_cells + CStr(cell.Value) & Chr(10)
Next cell
End Function

see attached sheet
-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Fri, Jun 29, 2012 at 9:18 PM, jmothilal  wrote:

> Dear any one
>
> I want 3 cell values in 1 cell line by line
>
> Thanks in advance
>
> like
>
>  MOTHILAL
> NAVEEN
> RAJA MOTHILAL NAVEEN RAJA
>
> --
>
> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
> :Otteri, Vellore-2*
>
>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

MERGE 1 CELL(Motilal).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: merge 3 cell values 1 cell

[Prince Dubey]

Hi Mothi,

I Hope this helpful for you.


You need to Pass : Sheet Name ,  Cells to be Copied e.g  C3:E3   and the 
Cell in which data Needs to be pasted.



Sub test(strSheetName As String, strSourceRng As String, strTargetrangen As 
String)

Dim Srng As Range
Dim rngcell As Range


With ThisWorkbook.Worksheets(strSheetName)
Set Srng = .Range(strSourceRng)
 For Each rngcell In Srng
.Range(strTargetrangen) = .Range(strTargetrangen) & rngcell.Value & 
vbNewLine
 Next
End With

End Sub


regards
Prince Dubey.

On Friday, 29 June 2012 21:18:36 UTC+5:30, mothi wrote:
>
> Dear any one
>
> I want 3 cell values in 1 cell line by line
>
> Thanks in advance
>
> like
>
>  MOTHILAL
> NAVEEN
> RAJA MOTHILAL NAVEEN RAJA
>
> -- 
>
> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex 
> :Otteri, Vellore-2*
>
>
>  

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: Help in Access

[Prince Dubey]

Hi manoj,

Please Use this I hope this will work for you..


SELECT distinct [Store ID]
FROM [Acer All Data];

union


SELECT distinct [Store ID]
FROM [Mar'12];
union
SELECT distinct [Store ID]
FROM [Apr'12];
union
SELECT distinct [Store ID]
FROM [May'12];

Regards
Prince Dubey.




On Friday, 29 June 2012 15:14:18 UTC+5:30, Manoj Kumar wrote:
>
> Dear Experts,
>
>
> I have data in month wise data in Access in different query..
> Please help me to find unique id From DATA in attached file..
>
>
>
> Regard
> Manoj
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ Copy JPG images from Word into Excel

[Asa Rossoff]

Hi Paul,

I have not automated Word much.. so these are just some thoughts:

 

Have you already tried these ideas?

1)  export from Word as MHT (images will be emebedded with the html file
to reduce file clutter), then open the file in Excel.

2)  Open the document in Word, Select All, Copy >> Excel: Paste

3)  Print the word file to PDF, then use the Acrobat OLE automation (or
perhaps some third-party PDF component) -- I think it's called the
Interapplication Communication API -- to retrieve the document contents.
Not even positive it offers that functionality.

4) Embed the Word document in your Excel file as-is.

5)  Embed a PDF of the word document in your Excel file (if you want a
"standard format" form consistency)

 

I just tried the first two ideas, and although they brought everything over,
the images sometimes were placed on top of the text.

 

As to parsing an HTML file which you mentioned: I would think inline images
would appear in the HTML file inline with the text.  Their IMG tag should
appear among the text where the image should be placed.  Images anchored to
the page might include CSS layout information to plcae them correctly and
don't necessarily appear inline with the text that they are displayed next
to.

 

Accurately parsing all the layout data and covnerting it to display on a
worksheet sounds problematic to me.  Without some form of embedding, I don't
think you'll be able to duplicate all aspects of the Word layout even if you
read it accurately from the Word object model.

 

Asa

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Paul Schreiner
Sent: Friday, June 29, 2012 7:41 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Copy JPG images from Word into Excel

 

I'm sorry, but here's the longer version of the story:

 

I have an Oracle database.

I use Excel as a front-end to the database.

The Excel application is used to store and retrieve over 60,000 "documents"

Each "document" consists of 2 to 130 sheets.

Reporting tools allow me to search the content of all the documents very
quickly.

The application includes over 30,000 lines of VBA code

(There is MUCH more going on with this application beyond storage and
retrieval)

 

I am now in the process of converting/loading over 3,000 "inspection"
documents into this application.

 

Unfortunately, the people who "Designed" the inspection documents chose to
use a Word Processing program instead of a spreadsheet.

(the oldest documents were originally in WordPerfect, then later converted
to Word)

 

I've moved most of the Word documents into specific folders.

I now am writing VBA code (in Excel) to open each of the Word Documents,

read the document and place the data into appropriate cells of the Excel
templates.

 

I successfully used:


Set DocRange = mWord.ActiveDocument.Range(Start:=0, End:=0)
DocRange.wholestory
TxtArray = Split(DocRange.Text, Chr(13))

 

to loop through the TxtArray and populate the rows of the Excel file.


-

My problem now is that many of the documents contain image files.


-

 

I have spent 30+ hours searching and testing various approaches...

I've discovered that while Excel utilizes the Shapes collection,

SOME of these images in my Word files are found in the InlineShapes
collection.

 

With this code:

 

For Each iShape In ActiveDocument.InlineShapes

iShape.Select
Selection.Copy
 Next iShape

 

I am able to copy each shape to the ClipBoard, 

and I'm confident that I could switch to the Excel application and Paste it.

 

I have also tried saving the Word document in HTML format, which effectively

copies out all of the images (which is REALLY nice).

 

However, I have another problem.

I cannot seem to be able to figure out WHERE the shape is in the Word file.

According to the documentation,

InlineShapes are attached to a Range object (which is not quite the same as
a Range in Excel)

But I cannot seem to be able to figure out how to determine which LINE the
image is attached to!

 

And I haven't had any luck reading the HTML documents to determine
placement.

 

Any ideas?
 

Paul

-
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-

-- 
FORUM RULES (986+ 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 answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't

Re: $$Excel-Macros$$ Macro timings should be multiple based on date changing

[Lokesh Loki]

Hi Lalit,

Thanks for replying to my query.

Actually i needed when i am changing the dates the macro timings i.e.
4:00:00 should be multiplied like this 8:00:00, 12:00:00, 16:00:00 and this
timings will added to the total timings.

Examples:

  * TimingsMacro timings   Total timings*
 5:30:15 +  4:00:00   =   9:30:15
 5:30:15 +  8:00:00   =  13:30:15
 5:30:15 + 12:00:00  =  17:30:15
 5:30:15 + 12:00:00  =  21:30:15

Please refer attached excel sheet i have mentioned date wise results so do
the needful.

Regards
Lokesh.M

On Fri, Jun 29, 2012 at 8:01 PM, Lalit Mohan wrote:

> Hi Lokesh,
>
> ** **
>
> Please find the attached. Change the formula accordingly.
>
> ** **
>
> ** **
>
> *Regards,*
>
> *Lalit Mohan*
>
> *www.excelfox.com/forum*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki
> *Sent:* Friday, June 29, 2012 7:18 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Macro timings should be multiple based on
> date changing
>
> ** **
>
> Hi All,
>
> Please find the attached excel file, and i need total macro timings based
> on date changes.
>
> Let me know for any clarification.
>
> Regards
> Lokesh.M
>
> --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Fwd: $$Excel-Macros$$ Macro timings should be multiple based on date changing

[Lokesh Loki]

Hi Lalit,

Thanks for replying to my query.

Actually i needed when i am changing the dates the macro timings i.e.
4:00:00 should be multiplied like this 8:00:00, 12:00:00, 16:00:00 and this
timings will added to the total timings.

Examples:

  * TimingsMacro timings   Total timings*
 5:30:15 +  4:00:00   =   9:30:15
 5:30:15 +  8:00:00   =  13:30:15
 5:30:15 + 12:00:00  =  17:30:15
 5:30:15 + 12:00:00  =  21:30:15

Please refer attached excel sheet i have mentioned date wise results so do
the needful.

Regards
Lokesh.M


On Fri, Jun 29, 2012 at 8:01 PM, Lalit Mohan wrote:

> Hi Lokesh,
>
> ** **
>
> Please find the attached. Change the formula accordingly.
>
> ** **
>
> ** **
>
> *Regards,*
>
> *Lalit Mohan*
>
> *www.excelfox.com/forum*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki
> *Sent:* Friday, June 29, 2012 7:18 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Macro timings should be multiple based on
> date changing
>
> ** **
>
> Hi All,
>
> Please find the attached excel file, and i need total macro timings based
> on date changes.
>
> Let me know for any clarification.
>
> Regards
> Lokesh.M
>
> --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

multiple the timings based on date changes.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

[╰» ℓαℓιт мσαнη]

Hi,

Try this also

=A1&" "&B1&" "&C1

Regards,
Lalit Mohan


On Fri, Jun 29, 2012 at 11:29 PM, NOORAIN ANSARI
wrote:

> Dear Moti Lal,
>
> You can use below UDF for dynamically
>
> Function combine_cells(rng As Excel.Range) As String
> Dim cell As Excel.Range
> For Each cell In rng.Cells
> combine_cells = combine_cells + CStr(cell.Value) & Chr(10)
> Next cell
> End Function
>
> see attached sheet
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Fri, Jun 29, 2012 at 9:18 PM, jmothilal  wrote:
>
>> Dear any one
>>
>> I want 3 cell values in 1 cell line by line
>>
>> Thanks in advance
>>
>> like
>>
>>  MOTHILAL
>> NAVEEN
>> RAJA MOTHILAL NAVEEN RAJA
>>
>> --
>>
>> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
>> :Otteri, Vellore-2*
>>
>>
>>  --
>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ IN TROUBLE

[╰» ℓαℓιт мσαнη]

Hi Azhar,

Try this revised version...

Sub InsertColumnWithFormula()
Const lngNoOfColAs Long = 2
Dim varSheets() As Variant
Dim lngLoop As Long
Const strStartRange As String = "R1"


varSheets = Array("Sheet1", "Sheet2", "Sheet3")

Application.DisplayAlerts = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False

For lngLoop = LBound(varSheets) To UBound(varSheets)
With ThisWorkbook.Worksheets(varSheets(lngLoop))
.Range(strStartRange).Offset(, (lngNoOfCol - 1) *
-1).Resize(, lngNoOfCol).EntireColumn.Copy
.Range(strStartRange).Offset(, 1).Insert Shift:=xlToRight
End With
Next lngLoop

Application.CutCopyMode = False
Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
Application.DisplayAlerts = True
End Sub

Regards,
Lalit Mohan
Regards,
Lalit Mohan


On Fri, Jun 29, 2012 at 4:51 PM, NOORAIN ANSARI
 wrote:
> Dear Azhar,
>
> Please share sample workbook with Group.
>
>
> On Fri, Jun 29, 2012 at 4:38 PM, Azhar Rai  wrote:
>>
>> Hello Dear Gurus
>>
>> I want to add columns in an excel sheet between R and AQ to be total in
>> number as in cell H5 and I also want this to be replicated in sheet2,
>> sheet3, and sheet4 and these columns  should also carry the formula from
>> column R.
>>
>> Gurus please help me.
>>
>> Thanks
>>
>>
>> --
>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
> --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

[jmothilal]

Dear NOORAIN ANSARI sir

Thanks for sending function coding.

Mothilal.J


On Sat, Jun 30, 2012 at 8:35 AM, ╰» ℓαℓιт мσαнη wrote:

> Hi,
>
> Try this also
>
> =A1&" "&B1&" "&C1
>
> Regards,
> Lalit Mohan
>
>
>
> On Fri, Jun 29, 2012 at 11:29 PM, NOORAIN ANSARI  > wrote:
>
>> Dear Moti Lal,
>>
>> You can use below UDF for dynamically
>>
>> Function combine_cells(rng As Excel.Range) As String
>> Dim cell As Excel.Range
>> For Each cell In rng.Cells
>> combine_cells = combine_cells + CStr(cell.Value) & Chr(10)
>> Next cell
>> End Function
>>
>> see attached sheet
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>> On Fri, Jun 29, 2012 at 9:18 PM, jmothilal  wrote:
>>
>>> Dear any one
>>>
>>> I want 3 cell values in 1 cell line by line
>>>
>>> Thanks in advance
>>>
>>> like
>>>
>>>  MOTHILAL
>>> NAVEEN
>>> RAJA MOTHILAL NAVEEN RAJA
>>>
>>> --
>>>
>>> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
>>> :Otteri, Vellore-2*
>>>
>>>
>>>  --
>>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>>
>>
>>  --
>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegro

Re: $$Excel-Macros$$ Macro timings should be multiple based on date changing

[╰» ℓαℓιт мσαнη]

Hi Lokesh,

Please find the attached hope it meets your specification

Regards,
Lalit Mohan


On Sat, Jun 30, 2012 at 7:32 AM, Lokesh Loki  wrote:
> Hi Lalit,
>
> Thanks for replying to my query.
>
> Actually i needed when i am changing the dates the macro timings i.e.
> 4:00:00 should be multiplied like this 8:00:00, 12:00:00, 16:00:00 and this
> timings will added to the total timings.
>
> Examples:
>
>            Timings    Macro timings   Total timings
>              5:30:15 +  4:00:00   =   9:30:15
>  5:30:15 +  8:00:00           =  13:30:15
>  5:30:15 + 12:00:00          =  17:30:15
>  5:30:15 + 12:00:00  =  21:30:15
>
> Please refer attached excel sheet i have mentioned date wise results so do
> the needful.
>
> Regards
> Lokesh.M
>
>
> On Fri, Jun 29, 2012 at 8:01 PM, Lalit Mohan 
> wrote:
>>
>> Hi Lokesh,
>>
>>
>>
>> Please find the attached. Change the formula accordingly.
>>
>>
>>
>>
>>
>> Regards,
>>
>> Lalit Mohan
>>
>> www.excelfox.com/forum
>>
>>
>>
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>> On Behalf Of Lokesh Loki
>> Sent: Friday, June 29, 2012 7:18 PM
>> To: excel-macros@googlegroups.com
>> Subject: $$Excel-Macros$$ Macro timings should be multiple based on date
>> changing
>>
>>
>>
>> Hi All,
>>
>> Please find the attached excel file, and i need total macro timings based
>> on date changes.
>>
>> Let me know for any clarification.
>>
>> Regards
>> Lokesh.M
>>
>> --
>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>> --
>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
> --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this foru

Re: $$Excel-Macros$$ Replace data from another sheets by adding raw

[Ashish Bhalara]

Dear experts,

Please suggest what should I do in that case, waiting for reply.

On Fri, Jun 29, 2012 at 7:23 PM, Ashish Bhalara
wrote:

>
>
> On Fri, Jun 29, 2012 at 7:20 PM, Ashish Bhalara  > wrote:
>
>> Dear experts,
>>
>> I need a function or macro to replace data from another sheets by
>> addition of raw, these addition of raw is depend on the record of another
>> sheet. you can find attached sheet for better understanding. I can do it
>> manually but there are thousands of record to process so its not possible
>> to do this.
>>
>
>> Thanks & regards.
>>
>> Ashish Bhalara
>> 9624111822
>> P*Please do not print this email unless it is absolutely necessary.
>> Spread environmental üawareness.♣♣♣*
>>
>>
>>  --
>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards.
>
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>
>


-- 
Thanks & regards.

Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ Convert houseName Column to Hyperlink by combining PropID Col with Static URL Root

[Rajan_Verma]

HI 

 

Try this :

 

Sub MTest()

 

Dim Hyp As Hyperlink

Dim rngCell As Range

Dim wksSheet As Worksheet

Dim strURL  As String

Set wksSheet = Worksheets("cleaner")

strURL =
"http://www.pawleysvacationrentals.com/PawleysIsland/VacationRentals/Pawleys
Island/Details/"

 
Range("rngRange").CurrentRegion.Columns(Range("rngRange").CurrentRegion.Colu
mns.Count).Delete

   For Each rngCell In
Range("rngRange").CurrentRegion.Columns(2).Offset(1).Cells

If rngCell.Value = "" Then Exit Sub

wksSheet.Hyperlinks.Add rngCell, strURL & "\" & rngCell.Offset(,
-1).Value, "", "Click", rngCell.Value

Next rngCell



End Sub

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of charlyRoot
Sent: 29 June 2012 2:10
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Convert houseName Column to Hyperlink by combining
PropID Col with Static URL Root

 


I'm trying to remove unnecessary columns from my sheet so it fits in emails
better. The last column is "Link" column. 

 


PropID

Name

BedRms

Beds

BathRms

Area

Sleeps

 Rent 

 Tax 

 Damage 

 ResFee 

Total

Link


CG10

Charlestown Grant 10

4

KQQTT

4.1

LBTS

8

 $ 4,460

 $ 446.00

 $ 50

 $  40

 $ 4,996

 
 Link


HAS102

Hamilton 102

3

KQQS

3

LBTS

8

 $ 3,070

 $ 307.00

 $ 50

 $  40

 $ 3,467

 
 Link


HAS402

Hamilton 402

3

KQTT

3

LBTS

6

 $ 2,765

 $ 276.50

 $ 50

 $  40

 $ 3,132

 
 Link

 

The link is composed by combining a contents from "statics" sheet 

 


http://www.pawleysvacationrentals.com/PawleysIsland/VacationRentals/PawleysI
sland/Details/

 

with the PropID value in the first column to produce something like this as
a target for the link:

 


http://www.pawleysvacationrentals.com/PawleysIsland/VacationRentals/PawleysI
sland/Details/
 CG10

 

Well here is what I want to change: I want to drop the "Link" column
altogether and just turn "Name" column into links using the same combination
as before.

 

Like this:


PropID

Name

BedRms

Beds

BathRms

Area

Sleeps

 Rent 

 Tax 

 Damage 

 ResFee 

Total


CG10

Charlestown Grant 10
 

4

KQQTT

4.1

LBTS

8

 $ 4,460

 $ 446.00

 $ 50

 $  40

 $ 4,996


HAS102

Hamilton 102
 

3

KQQS

3

LBTS

8

 $ 3,070

 $ 307.00

 $ 50

 $  40

 $ 3,467


HAS402

Hamilton 402
 

3

KQTT

3

LBTS

6

 $ 2,765

 $ 276.50

 $ 50

 $  40

 $ 3,132

 

Here is my code so far:

 

 

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--

RE: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

[Rajan_Verma]

HI

 

HTH

 

Sub DisableCtrlD()



Dim blnflag  As Boolean

Dim strPwd As String



strPwd = Application.InputBox("Enter the Password ", "Password")

blnflag = Application.InputBox("To Enable Key Press 1 and To disable press 
0 ", "Password")



If strPwd = "GiveYourPwd" Then

If blnflag Then

Application.OnKey "^d", ""

Else

Application.OnKey "^d", "Test"

End If

End If

End Sub

 

Sub Test()

MsgBox "Disabled"

End Sub

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Muralidhar E
Sent: 29 June 2012 10:08
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

 

Hi gm experts,

 

is anybody solve my problem reg. disable ctrl+d option.

Iam waiting for solution for the problem.



 

On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E  wrote:

Hi group,

 

Because of CTRl+D just fill down the data iam facing this problem, when i want 
to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not observing 
it later it was effecting to the data.

So i what i need is i want to disable Ctrl+D with a passward and same time 
i want to enable with a passward.

 

I think it will usefull for others also.

 

Thanks in Advance.



 

On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma  wrote:

Do you have any add-in or macro in  personal.xlsb which  have any macro 
assigned Ctrl+D??

Because excel default Ctrl+D just fill down the data. 

 

Regards

Rajan verma

+91 7838100659   [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Muralidhar E
Sent: 27 June 2012 3:18
To: excel-macros@googlegroups.com
Cc: ahmedhon...@gmail.com 


Subject: Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

 


Hi,

 

But it will not come to the notice at the same time, it was accidently going 
on, iam not observing it later it was effecting to the data.


 

On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest  wrote:

Dear,

 

I think using Ctrl + Z will allow you to take back the action you performed i.e 
Undo the last action ;-). This should help. If not, check other experts advice. 

 

Thanks,

 



 

On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E  wrote:


Dear all,

 

Iam using Office 2007, when iam need to use Crl+F accidently iam hitting 
Ctrl+D, iam loosing some data and iam unable to find the changes happening to 
the data file.

Iam want to disable Ctrl+D option with a passward and the same enable with 
passward,  it should for that worksheet only.

 

Thanks in advance.
-- 

Thanks & Regards,

 

Muralidhar E.

 

-- 
-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com 
 
 
 





-- 

Ahmed Bawazir

احمد باوزير

 




-- 

Thanks & Regards,

 

Muralidhar E.

 

-- 
-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
 
 

-- 
-- 
FORUM RULES (986+ 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 Advi

RE: $$Excel-Macros$$ page setup - Reg

[Lalit Mohan]

Hi Mothilal,

 

 

Hope it helps you

 

Sub SetSheetOrientation()

 

Dim wbkAll  As Workbook

Dim wksSheetAs Worksheet



Set wbkAll = ThisWorkbook

For Each wksSheet In wbkAll.Worksheets

wksSheet.PageSetup.Orientation = xlLandscape

wksSheet.PageSetup.TopMargin = 0.5

wksSheet.PageSetup.BottomMargin = 0.5

wksSheet.PageSetup.LeftMargin = 0.5

wksSheet.PageSetup.RightMargin = 0.5

Next wksSheet

 

End Sub

 

 

Regards,

Lalit Mohan

www.excelfox.com/forum

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of jmothilal
Sent: Saturday, June 30, 2012 9:18 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ page setup - Reg

 

Dear any one

 

i want set all worksheets  in landscape with  top,bottom,left, right margin
0.5 inches.

 

Thanks with


 

-- 

J.Mothilal : Universal Computer Systems : # 16, Brindavan Complex :Otteri,
Vellore-2

 

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ Re: Book3.xlsx

[Rajan_Verma]

Hi

Try this :

 

 

Sub MTest()

Dim rngRange As Range

Set rngRange = Range("A1").CurrentRegion.Offset(1)

Application.screenUpdating=False

rngRange.Sort key1:=rngRange.Cells(1, 3)



Set rngRange =
Range("A1").CurrentRegion.Columns(3).SpecialCells(xlCellTypeConstants).Offse
t(, -1)

rngRange.Value = rngRange.Value

Set rngRange = Range("A1").CurrentRegion.Offset(1)

rngRange.Sort key1:=rngRange.Cells(1, 1)

Application.screenUpdating=True

 

End Sub

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lalit_Mohan
Sent: 29 June 2012 12:54
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Book3.xlsx

 

Hi Neeraj,

 

Hope it helps you

 

Sub FindFormula()

Dim rngDtRange  As Range
Const strDataRange  As String = "B1:B1000"
Dim firstAddressAs String
Const strFindFormulaAs String = "=RANDBETWEEN?"

With ThisWorkbook.Worksheets("Sheet1").Range(strDataRange)
Set rngDtRange = .Find(what:=strFindFormula, LookIn:=xlFormulas)
If Not rngDtRange Is Nothing Then
firstAddress = rngDtRange.Address
Do
rngDtRange.Offset(, 1).Value =
Replace(Replace(strFindFormula, "=", ""), "?", "")
Set rngDtRange = .FindNext(rngDtRange)
Loop While Not rngDtRange Is Nothing And rngDtRange.Address <>
firstAddress
End If
End With

End Sub

 

Regards,

Lalit Mohan


On Friday, 29 June 2012 12:11:51 UTC+5:30, neeraj chauhan wrote:

Dear Experts,

 

I have a sheet kindly find it,  if we have two formulas in one  "B" Colum
and I want to paste special only one (Randbetween) formula then how can I do
it? 

 

Kindly find the attached sheet for the concerned.

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

[Muralidhar E]

Hi,

Rajan,

thanks alot.
Warm Ragards,

Muralidhar E
On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma wrote:

>  HI
>
> ** **
>
> HTH
>
> ** **
>
> Sub DisableCtrlD()
>
> 
>
> Dim blnflag  As Boolean
>
> Dim strPwd As String
>
> 
>
> strPwd = Application.InputBox("Enter the Password ", "Password")
>
> blnflag = Application.InputBox("To Enable Key Press 1 and To disable
> press 0 ", "Password")
>
> 
>
> If strPwd = "GiveYourPwd" Then
>
> If blnflag Then
>
> Application.OnKey "^d", ""
>
> Else
>
> Application.OnKey "^d", "Test"
>
> End If
>
> End If
>
> End Sub
>
> ** **
>
> Sub Test()
>
> MsgBox "Disabled"
>
> End Sub
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E
> *Sent:* 29 June 2012 10:08
> *To:* excel-macros@googlegroups.com
>
> *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
>
>  ** **
>
> Hi gm experts,
>
>  
>
> is anybody solve my problem reg. disable ctrl+d option.
>
> Iam waiting for solution for the problem.
>
>
>
>  
>
> On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E 
> wrote:
>
> Hi group,
>
>  
>
> Because of CTRl+D just fill down the data iam facing this problem, when i
> want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not
> observing it later it was effecting to the data.
>
> So i what i need is i want to *disable Ctrl+D with a passward* and
> same time i want to *enable with a passward*.
>
>  
>
> I think it will usefull for others also.
>
>  
>
> Thanks in Advance.
>
>
>
>  
>
> On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma 
> wrote:
>
> Do you have any add-in or macro in  personal.xlsb which  have any macro
> assigned Ctrl+D??
>
> Because excel default Ctrl+D just fill down the data. 
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E
> *Sent:* 27 June 2012 3:18
> *To:* excel-macros@googlegroups.com
> *Cc:* ahmedhon...@gmail.com 
>
>
> *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
>
>  
>
>
> Hi,
>
>  
>
> But it will not come to the notice at the same time, it was accidently
> going on, iam not observing it later it was effecting to the data.
>
>
>  
>
> On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest 
> wrote:
>
> Dear,
>
>  
>
> I think using Ctrl + Z will allow you to take back the action you
> performed i.e Undo the last action ;-). This should help. If not, check
> other experts advice. 
>
>  
>
> Thanks,
>
>  
>
>
>
>  
>
> On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E 
> wrote:
>
>
> Dear all,
>
>  
>
> Iam using Office 2007, when iam need to use Crl+F accidently iam hitting
> Ctrl+D, iam loosing some data and iam unable to find the changes happening
> to the data file.
>
> Iam want to disable Ctrl+D option with a passward and the same enable with
> passward,  it should for that worksheet only.
>
>  
>
> Thanks in advance.
> -- 
>
> *Thanks & Regards,*
>
>  
>
> *Muralidhar E.*
>
>  
>
> --
> --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>  
>
>
>
> 
>
> -- 
>
> Ahmed Bawazir
>
> *احمد باوزير*
>
>  
>
>
>
>
> -- 
>
> *Thanks & Regards,*
>
>  
>
> *Muralidhar E.*
>
>  
>
> --
> --
> FORUM RULES (986+ 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 answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't po

$$Excel-Macros$$ Delete controls that were created at run time with the Add method

[learner]

Hi!

I need userform controls created runtime to respond various data input 
sessions
and use exclamation syntax to reference properties of these controls.

UserForm2!Label1.Caption = "xxx" works fine from within the form 
module.

However, I also need to delete such controls before the form is repainted 
to respond change of data set. 

The Excel Visual Basic Help "Clear Method" suggests: 

"For a Controls collection, Clear deletes controls that were created at run 
time with the Add method". 

Syntax

object.Clear

Unfortunately, no syntax example is given. 

Following statements give error "Could not find specified object".

UserForm2!Label1.Clear
UserForm2!Controls.Label1.Clear

I have tried "!" & "." either alone or in combination at various positions 
without success.

Help with correct syntax to refer controls collection.

Thanks
Learner

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Re: Help in Access

[Manoj Kumar]

Sorry for delay

Thanks Dear...

On Sat, Jun 30, 2012 at 12:51 AM, Prince Dubey wrote:

> Hi manoj,
>
> Please Use this I hope this will work for you..
>
>
> SELECT distinct [Store ID]
> FROM [Acer All Data];
>
> union
>
>
> SELECT distinct [Store ID]
> FROM [Mar'12];
> union
> SELECT distinct [Store ID]
> FROM [Apr'12];
> union
> SELECT distinct [Store ID]
> FROM [May'12];
>
> Regards
> Prince Dubey.
>
>
>
>
> On Friday, 29 June 2012 15:14:18 UTC+5:30, Manoj Kumar wrote:
>>
>> Dear Experts,
>>
>>
>> I have data in month wise data in Access in different query..
>> Please help me to find unique id From DATA in attached file..
>>
>>
>>
>> Regard
>> Manoj
>>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ Re: IN TROUBLE

[Rajan_Verma]

Just Group your all worksheet by selecting them with Ctrl key and work with
any one ,

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lalit_Mohan
Sent: 29 June 2012 5:03
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: IN TROUBLE

 

Hi Azhar,

 

Try this and change accordingly

 

Sub InsertColumnWithFormula()

Const lngNoOfColAs Long = 2
Dim varSheets() As Variant
Dim lngLoop As Long
Const strStartRange As String = "R1"


varSheets = Array("Sheet1", "Sheet2", "Sheet3")

Application.DisplayAlerts = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False

For lngLoop = LBound(varSheets) To UBound(varSheets)
With ThisWorkbook.Worksheets(varSheets(lngLoop))
.Range(strStartRange).Offset(, (lngNoOfCol - 1) *
-1).Resize(, lngNoOfCol).EntireColumn.Copy
.Range(strStartRange).Offset(, 1).Insert Shift:=xlToRight
End With
Next lngLoop

Application.CutCopyMode = xlCopy
Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
Application.DisplayAlerts = True

End Sub

 

Regards,

Lalit Mohan

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ Macro timings should be multiple based on date changing

[Rajan_Verma]

Use this One in G11:

 

=D11+(((A12-A11)+1)/24*4) 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: 30 June 2012 7:31
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro timings should be multiple based on date
changing

 

Hi Lalit,

Thanks for replying to my query.

Actually i needed when i am changing the dates the macro timings i.e.
4:00:00 should be multiplied like this 8:00:00, 12:00:00, 16:00:00 and this
timings will added to the total timings.

Examples:

   TimingsMacro timings   Total timings
 5:30:15 +  4:00:00   =   9:30:15 
 5:30:15 +  8:00:00   =  13:30:15
 5:30:15 + 12:00:00  =  17:30:15
 5:30:15 + 12:00:00  =  21:30:15

Please refer attached excel sheet i have mentioned date wise results so do
the needful.

Regards
Lokesh.M

On Fri, Jun 29, 2012 at 8:01 PM, Lalit Mohan 
wrote:

Hi Lokesh,

 

Please find the attached. Change the formula accordingly.

 

 

Regards,

Lalit Mohan

www.excelfox.com/forum

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: Friday, June 29, 2012 7:18 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro timings should be multiple based on date
changing

 

Hi All,

Please find the attached excel file, and i need total macro timings based on
date changes. 

Let me know for any clarification.

Regards
Lokesh.M

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
 

 

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures

RE: $$Excel-Macros$$ Re: IN TROUBLE

[Lalit Mohan]

Hi Azhar,

 

Try this revised with some changes hope it helps you:

 

Sub InsertColumnWithFormula()

Const lngNoOfColAs Long = 2

Dim varSheets() As Variant

Dim lngLoop As Long

Const strStartRange As String = "D1"





varSheets = Array("Sheet1", "Sheet2", "Sheet3")



Application.DisplayAlerts = False

Application.Calculation = xlCalculationManual

Application.EnableEvents = False



For lngLoop = LBound(varSheets) To UBound(varSheets)

With ThisWorkbook.Worksheets(varSheets(lngLoop))

If lngLoop = LBound(varSheets) Then

.Range(strStartRange).Offset(, (lngNoOfCol - 1) *
-1).Resize(, lngNoOfCol).EntireColumn.Copy

End If

.Range(strStartRange).Offset(, 1).Insert Shift:=xlToRight

End With

Next lngLoop



Application.CutCopyMode = xlCopy

Application.EnableEvents = True

Application.Calculation = xlCalculationAutomatic

Application.DisplayAlerts = True

End Sub

 

 

Regards,

Lalit Mohan

www.excelfox.com/forum

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajan_Verma
Sent: Saturday, June 30, 2012 10:29 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: IN TROUBLE

 

Just Group your all worksheet by selecting them with Ctrl key and work with
any one ,

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lalit_Mohan
Sent: 29 June 2012 5:03
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: IN TROUBLE

 

Hi Azhar,

 

Try this and change accordingly

 

Sub InsertColumnWithFormula()

Const lngNoOfColAs Long = 2
Dim varSheets() As Variant
Dim lngLoop As Long
Const strStartRange As String = "R1"


varSheets = Array("Sheet1", "Sheet2", "Sheet3")

Application.DisplayAlerts = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False

For lngLoop = LBound(varSheets) To UBound(varSheets)
With ThisWorkbook.Worksheets(varSheets(lngLoop))
.Range(strStartRange).Offset(, (lngNoOfCol - 1) *
-1).Resize(, lngNoOfCol).EntireColumn.Copy
.Range(strStartRange).Offset(, 1).Insert Shift:=xlToRight
End With
Next lngLoop

Application.CutCopyMode = xlCopy
Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
Application.DisplayAlerts = True

End Sub

 

Regards,

Lalit Mohan

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measu

RE: $$Excel-Macros$$ Replace data from another sheets by adding raw

[Rajan_Verma]

homework

 

 

Regards  

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Ashish Bhalara
Sent: 30 June 2012 9:21
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw

 

Dear experts,

 

Please suggest what should I do in that case, waiting for reply.

On Fri, Jun 29, 2012 at 7:23 PM, Ashish Bhalara  
wrote:

 

On Fri, Jun 29, 2012 at 7:20 PM, Ashish Bhalara  
wrote:

Dear experts,

 

I need a function or macro to replace data from another sheets by addition of 
raw, these addition of raw is depend on the record of another sheet. you can 
find attached sheet for better understanding. I can do it manually but there 
are thousands of record to process so its not possible to do this. 

 

Thanks & regards.

 

Ashish Bhalara

9624111822

PPlease do not print this email unless it is absolutely necessary. Spread 
environmental üawareness.♣♣♣

 

 

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com 
 





 

-- 

Thanks & regards.

 

Ashish Bhalara

9624111822

PPlease do not print this email unless it is absolutely necessary. Spread 
environmental üawareness.♣♣♣

 

 





 

-- 
Thanks & regards.

 

Ashish Bhalara

9624111822

PPlease do not print this email unless it is absolutely necessary. Spread 
environmental üawareness.♣♣♣

 

 

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ page setup - Reg

[Rajan_Verma]

HI

Group your all worksheets and  do page setup, will apply for all J

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of jmothilal
Sent: 30 June 2012 9:18
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ page setup - Reg

 

Dear any one

 

i want set all worksheets  in landscape with  top,bottom,left, right margin
0.5 inches.

 

Thanks with


 

-- 

J.Mothilal : Universal Computer Systems : # 16, Brindavan Complex :Otteri,
Vellore-2

 

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

[Muralidhar E]

Hi,

Can u guide the procedure how to run this code in my file.
I am fail to run the code.
Warm Regards,

Muralidhar E.

On Sat, Jun 30, 2012 at 10:25 AM, Muralidhar E wrote:

>
> Hi,
>
> Rajan,
>
> thanks alot.
> Warm Ragards,
>
> Muralidhar E
>  On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma 
> wrote:
>
>>  HI
>>
>> ** **
>>
>> HTH
>>
>> ** **
>>
>> Sub DisableCtrlD()
>>
>> 
>>
>> Dim blnflag  As Boolean
>>
>> Dim strPwd As String
>>
>> 
>>
>> strPwd = Application.InputBox("Enter the Password ", "Password")
>>
>> blnflag = Application.InputBox("To Enable Key Press 1 and To disable
>> press 0 ", "Password")
>>
>> 
>>
>> If strPwd = "GiveYourPwd" Then
>>
>> If blnflag Then
>>
>> Application.OnKey "^d", ""
>>
>> Else
>>
>> Application.OnKey "^d", "Test"
>>
>> End If
>>
>> End If
>>
>> End Sub
>>
>> ** **
>>
>> Sub Test()
>>
>> MsgBox "Disabled"
>>
>> End Sub
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E
>> *Sent:* 29 June 2012 10:08
>> *To:* excel-macros@googlegroups.com
>>
>> *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
>>
>>  ** **
>>
>> Hi gm experts,
>>
>>  
>>
>> is anybody solve my problem reg. disable ctrl+d option.
>>
>> Iam waiting for solution for the problem.
>>
>>
>>
>>  
>>
>> On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E 
>> wrote:
>>
>> Hi group,
>>
>>  
>>
>> Because of CTRl+D just fill down the data iam facing this problem, when i
>> want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not
>> observing it later it was effecting to the data.
>>
>> So i what i need is i want to *disable Ctrl+D with a passward* and
>> same time i want to *enable with a passward*.
>>
>>  
>>
>> I think it will usefull for others also.
>>
>>  
>>
>> Thanks in Advance.
>>
>>
>>
>>  
>>
>> On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma 
>> wrote:
>>
>> Do you have any add-in or macro in  personal.xlsb which  have any macro
>> assigned Ctrl+D??
>>
>> Because excel default Ctrl+D just fill down the data. 
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>>  
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E
>> *Sent:* 27 June 2012 3:18
>> *To:* excel-macros@googlegroups.com
>> *Cc:* ahmedhon...@gmail.com 
>>
>>
>> *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
>>
>>  
>>
>>
>> Hi,
>>
>>  
>>
>> But it will not come to the notice at the same time, it was accidently
>> going on, iam not observing it later it was effecting to the data.
>>
>>
>>  
>>
>> On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest 
>> wrote:
>>
>> Dear,
>>
>>  
>>
>> I think using Ctrl + Z will allow you to take back the action you
>> performed i.e Undo the last action ;-). This should help. If not, check
>> other experts advice. 
>>
>>  
>>
>> Thanks,
>>
>>  
>>
>>
>>
>>  
>>
>> On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E 
>> wrote:
>>
>>
>> Dear all,
>>
>>  
>>
>> Iam using Office 2007, when iam need to use Crl+F accidently iam hitting
>> Ctrl+D, iam loosing some data and iam unable to find the changes happening
>> to the data file.
>>
>> Iam want to disable Ctrl+D option with a passward and the same enable
>> with passward,  it should for that worksheet only.
>>
>>  
>>
>> Thanks in advance.
>> -- 
>>
>> *Thanks & Regards,*
>>
>>  
>>
>> *Muralidhar E.*
>>
>>  
>>
>> --
>> --
>> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>  
>>
>>
>>
>> 
>>
>> -- 
>>
>> Ahmed Bawazir
>>
>> *احمد باوزير*
>>
>>  
>>
>>
>>

Re: $$Excel-Macros$$ Re: Need excel formula

[sriram ji]

Dear Excel Guru,

Please find the attached file,

If ptp1 comes which date ptp generated that date should comes in D2 cell, I
want all colored cells for formula..

Thanks & Regards,
Sriram G (Chennai)




On Fri, Jun 29, 2012 at 12:37 PM, Lalit_Mohan wrote:

> Hi Sriram,
>
> Could you please explain excatly what you are looking for so that we can
> provide you the solution related to the query.
>
> Regards,
> Lalit Mohan
>
> On Friday, 29 June 2012 12:10:47 UTC+5:30, sriram ji wrote:
>
>>
>> Dear Excel Guru,
>>
>> Please find the attached file and help me
>>
>>
>>
>> Thanks & Regards,
>>
>> Sriram G
>> Chennai
>>
>  --
> FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Need formula.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

[Rajan_Verma]

HI 

 

First you need to give your password in code (Replace “GiveYourPwd” with your 
password”) , Press ALT +F 11 then Insert a Module , paste the code there, come 
to the worksheet and

Just Press Alt+F8 and select DisableCtrlD , 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Muralidhar E
Sent: 30 June 2012 10:48
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

 

Hi,

 

Can u guide the procedure how to run this code in my file.

I am fail to run the code.

Warm Regards,

 

Muralidhar E.

On Sat, Jun 30, 2012 at 10:25 AM, Muralidhar E  wrote:


Hi,

 

Rajan,

 

thanks alot.

Warm Ragards,

 

Muralidhar E

On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma  wrote:

HI

 

HTH

 

Sub DisableCtrlD()



Dim blnflag  As Boolean

Dim strPwd As String



strPwd = Application.InputBox("Enter the Password ", "Password")

blnflag = Application.InputBox("To Enable Key Press 1 and To disable press 
0 ", "Password")



If strPwd = "GiveYourPwd" Then

If blnflag Then

Application.OnKey "^d", ""

Else

Application.OnKey "^d", "Test"

End If

End If

End Sub

 

Sub Test()

MsgBox "Disabled"

End Sub

 

Regards

Rajan verma

+91 7838100659   [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Muralidhar E
Sent: 29 June 2012 10:08
To: excel-macros@googlegroups.com 


Subject: Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

 

Hi gm experts,

 

is anybody solve my problem reg. disable ctrl+d option.

Iam waiting for solution for the problem.



 

On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E  wrote:

Hi group,

 

Because of CTRl+D just fill down the data iam facing this problem, when i want 
to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not observing 
it later it was effecting to the data.

So i what i need is i want to disable Ctrl+D with a passward and same time 
i want to enable with a passward.

 

I think it will usefull for others also.

 

Thanks in Advance.



 

On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma  wrote:

Do you have any add-in or macro in  personal.xlsb which  have any macro 
assigned Ctrl+D??

Because excel default Ctrl+D just fill down the data. 

 

Regards

Rajan verma

+91 7838100659   [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Muralidhar E
Sent: 27 June 2012 3:18
To: excel-macros@googlegroups.com
Cc: ahmedhon...@gmail.com 


Subject: Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

 


Hi,

 

But it will not come to the notice at the same time, it was accidently going 
on, iam not observing it later it was effecting to the data.


 

On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest  wrote:

Dear,

 

I think using Ctrl + Z will allow you to take back the action you performed i.e 
Undo the last action ;-). This should help. If not, check other experts advice. 

 

Thanks,

 



 

On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E  wrote:


Dear all,

 

Iam using Office 2007, when iam need to use Crl+F accidently iam hitting 
Ctrl+D, iam loosing some data and iam unable to find the changes happening to 
the data file.

Iam want to disable Ctrl+D option with a passward and the same enable with 
passward,  it should for that worksheet only.

 

Thanks in advance.
-- 

Thanks & Regards,

 

Muralidhar E.

 

-- 
-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com 
 
 
 





-- 

Ahmed Bawazir

احمد باوزير

 




-- 

Thanks & Regards,

 

Muralidhar E.

 

-- 
-- 
FORUM RULES (986+ 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 answered.
 
2) Don't post a question in the thread of another member.

RE: $$Excel-Macros$$ Re: Need excel formula

[Rajan_Verma]

Try this :

 

=IFERROR(INDEX($H$13:$N$13,1,MATCH(D$13,$H14:$N14,0)),"")

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sriram ji
Sent: 30 June 2012 10:51
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Need excel formula

 

Dear Excel Guru,

 

Please find the attached file,

 

If ptp1 comes which date ptp generated that date should comes in D2 cell, I
want all colored cells for formula..

 

Thanks & Regards,

Sriram G (Chennai)

 

 

 

On Fri, Jun 29, 2012 at 12:37 PM, Lalit_Mohan 
wrote:

Hi Sriram,

 

Could you please explain excatly what you are looking for so that we can
provide you the solution related to the query.

 

Regards,

Lalit Mohan


On Friday, 29 June 2012 12:10:47 UTC+5:30, sriram ji wrote:

 

Dear Excel Guru,

 

Please find the attached file and help me 

 

 

 

Thanks & Regards,

 

Sriram G

Chennai

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
 

 

-- 
FORUM RULES (986+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

[Muralidhar E]

hi,

If strPwd = "GiveYourPwd" Then   i change here as 143

macros is running but for enabling ctrl+d it is not working.




On Sat, Jun 30, 2012 at 10:51 AM, Rajan_Verma wrote:

>  HI 
>
> ** **
>
> First you need to give your password in code (Replace “GiveYourPwd” with
> your password”) , Press ALT +F 11 then Insert a Module , paste the code
> there, come to the worksheet and
>
> Just Press Alt+F8 and select DisableCtrlD , 
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E
> *Sent:* 30 June 2012 10:48
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
>
>  ** **
>
> Hi,
>
>  
>
> Can u guide the procedure how to run this code in my file.
>
> I am fail to run the code.
>
> Warm Regards,
>
>  
>
> Muralidhar E.
>
> On Sat, Jun 30, 2012 at 10:25 AM, Muralidhar E 
> wrote:
>
>
> Hi,
>
>  
>
> Rajan,
>
>  
>
> thanks alot.
>
> Warm Ragards,
>
>  
>
> Muralidhar E
>
> On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma 
> wrote:
>
> HI
>
>  
>
> HTH
>
>  
>
> Sub DisableCtrlD()
>
> 
>
> Dim blnflag  As Boolean
>
> Dim strPwd As String
>
> 
>
> strPwd = Application.InputBox("Enter the Password ", "Password")
>
> blnflag = Application.InputBox("To Enable Key Press 1 and To disable
> press 0 ", "Password")
>
> 
>
> If strPwd = "GiveYourPwd" Then
>
> If blnflag Then
>
> Application.OnKey "^d", ""
>
> Else
>
> Application.OnKey "^d", "Test"
>
> End If
>
> End If
>
> End Sub
>
>  
>
> Sub Test()
>
> MsgBox "Disabled"
>
> End Sub
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E
> *Sent:* 29 June 2012 10:08
> *To:* excel-macros@googlegroups.com 
>
>
> *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
>
>  
>
> Hi gm experts,
>
>  
>
> is anybody solve my problem reg. disable ctrl+d option.
>
> Iam waiting for solution for the problem.
>
>
>
>  
>
> On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E 
> wrote:
>
> Hi group,
>
>  
>
> Because of CTRl+D just fill down the data iam facing this problem, when i
> want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not
> observing it later it was effecting to the data.
>
> So i what i need is i want to *disable Ctrl+D with a passward* and
> same time i want to *enable with a passward*.
>
>  
>
> I think it will usefull for others also.
>
>  
>
> Thanks in Advance.
>
>
>
>  
>
> On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma 
> wrote:
>
> Do you have any add-in or macro in  personal.xlsb which  have any macro
> assigned Ctrl+D??
>
> Because excel default Ctrl+D just fill down the data. 
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E
> *Sent:* 27 June 2012 3:18
> *To:* excel-macros@googlegroups.com
> *Cc:* ahmedhon...@gmail.com 
>
>
> *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
>
>  
>
>
> Hi,
>
>  
>
> But it will not come to the notice at the same time, it was accidently
> going on, iam not observing it later it was effecting to the data.
>
>
>  
>
> On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest 
> wrote:
>
> Dear,
>
>  
>
> I think using Ctrl + Z will allow you to take back the action you
> performed i.e Undo the last action ;-). This should help. If not, check
> other experts advice. 
>
>  
>
> Thanks,
>
>  
>
>
>
>  
>
> On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E 
> wrote:
>
>
> Dear all,
>
>  
>
> Iam using Office 2007, when iam need to use Crl+F accidently iam hitting
> Ctrl+D, iam loosing some data and iam unable to find the changes happening
> to the data file.
>
> Iam want to disable Ctrl+D option with a passward and the same enable with
> passward,  it should for that worksheet only.
>
>  
>
> Thanks in advance.
> -- 
>
> *Thanks & Regards,*
>
>  
>
> *Muralidhar E.*
>
>  
>
> --
> --
> FORUM RULES (986+ 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 answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions