Can anyone help me with the above post please
:-(
Rash
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Please Attach There is No Attachment...
*Best Regards,*
*Venkat*
*
*
On Mon, Jul 18, 2011 at 11:48 AM, Rsh rashmiv.ni...@gmail.com wrote:
Please help me in reducing the code in the attachment above..
Thnx in advance
--
Thank a lot Anish, It is working fine.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Anish Shrivastava
Sent: Friday, July 15, 2011 5:28 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Multiple excel
Dear Noorain,
Really helpful solution. thanks a lot.
one question to you, is there any process to select two groups at a time?
cause I have a large database 15 customer groups from where I have to select
only Distributor Super Stokist only.
please reply
Thanks in advance
Kalyan
On Mon, Jul
Samuel,
It was my assumption that your sheet would be the same as my example sheet
which I used for macro. However, I feel sorry that it didnt help you.
Anyways, I will give you another macro which will search in each cell on the
sheet and if it finds a value then it will populate cells address
Hi Experts,
I need formula or macro to concatenete the rows by mail id or reps. Attached
the sample file.
Thanks in advance.
Regards
Anr
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Hi Experts,
I need formula or macro to concatenete the rows by mail id or reps. Attached
the sample file.
Thanks in advance.
Regards
Shiek
--
Regards,
Shiek
--
--
Some important links for excel users:
1.
Hello,
I have a worksheet that is updated by multiple users. When a user
updates a cell to a certain value, I would like excel to send me an
email notification that the cell has changed. I have the code to check
for the event:
Private Sub Worksheet_Change(ByVal Target As Range)
If
Select B4 and Run the Code
Sub CreateCode()
On Error GoTo Err:
Dim rng As Range
Dim cell As Range
Set rng = Application.InputBox(Select the Range of Client Name, , , ,
, , , 8)
i = 1
For Each cell In rng
If WorksheetFunction.CountIf(rng.Cells(1, 1).Resize(i, 1),
You this
=MROUND(C1,10)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sharad jain
Sent: Sunday, July 17, 2011 5:22 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Simple Code
Hi Guys,
Can someone please send me a simple code
If you have any GmailID Use the mention Codes
Function fcnSendPage()
'Dim cdoMessage
Set cdoMessage = CreateObject(CDO.Message)
With cdoMessage.Configuration.Fields
.Item(http://schemas.microsoft.com/cdo/configuration/sendusing;) =
2 'Send using the network (SMTP over the
Use
Application.Vlookup(LookupValue,LookupRange,Col,Type) in codes
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prathima R
Sent: Sunday, July 17, 2011 12:03 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ to find particular column and
You can always use the intended cell.FormulaR1C1 to do the trick.
something like
Cells(1,A).FormulaR1C1 = =Vlookup(
TM
On Jul 19, 12:03 am, Rajan_Verma rajanverma1...@gmail.com wrote:
Use
Application.Vlookup(LookupValue,LookupRange,Col,Type) in codes
From:
Hi Prathima
Assuming your Data 1,2 3 columns contain data
Try :
Sub test()
Dim LR As Long
Sheets(Summary).Select
Set Found = Sheets(Summary).Rows(1).Find(what:=Data 1, LookIn:=xlValues,
lookat:=xlWhole)
LR = Cells(Rows.Count, Found.Column).End(xlUp).Row
Found.Offset(, 1).EntireColumn.Insert
Hi
For Vlookup you can use static Name range which is predetermined
RANGE
=SBUMapping!$A$1:$D$789
OR
dynamic Name range range which resize dynamically
RANGE
=OFFSET(SBUMapping!$A$1,0,0,COUNTA(SBUMapping!$A:$A),COUNTA(SBUMapping!$1:$1))
Thanks
Mahesh
On Mon, Jul 18, 2011 at 11:05 PM, Mahesh
I have a spreadsheet I need to have multiple items summed at the first
blank row available...the following macro works great for Column 4 as
shown below, but I need to have it run through multiple columns up to
20...I tried using an array using a for next loop on the array, but
couldn't get it
try this
Sub enterTotals()
lastcol = 20
For i = 4 To lastcol
For Each rngArea In Columns(i).SpecialCells(xlCellTypeConstants,
xlNumbers).Areas
With rngArea.Offset(rngArea.Rows.Count).Resize(1, 1)
.FormulaR1C1 = =SUM( rngArea.Address(1, 1, xlR1C1) )
Hi Rajan,
In Report sheet C column Purchases has to taken from purchases sheet
against particular part number mentioned in the column A and total qty
purchased.It may me more then one line items.
Similarly Closing stock and Sales also we have to take total cl stock and
total sales against
Hi Daniel
Thanks for a great result. Not quite there yet. When double click the
comment box doubles it size. When cursor is moved away from that cell and
then back to that cell the double size is still there sometimes. Sometimes
it does go back to normal but not all the time.
So when the
From:iGATE Global Solutions supreet.sa...@igatepatni.com
Date: 18 Jul 11 20:41:03
Subject: iGate Patni hiring Senior Team Leads for WFM-Forecasting_Bangalore
location
To: venkatesa...@in.com
Job Location: Bengaluru/Bangalore
Dear Candidate,
We have few openings in BPO division.Please find
20 matches
Mail list logo
