Hi David,
many thanks for your answer. where i should insert your line?
regards
Fede
On 30 Lug, 01:24, Dave Bonallack wrote:
> Hi,
>
> Try this line of code:
>
> Cells(ActiveCell.Row, Columns.Count).End(xlToLeft).Offset(0, 1).Select
>
> Regards - Dave.
>
>
>
> > Date: Thu, 29 Jul 2010 05:27:59 -
Hi,
The Recd Date and Completion date is differs for each employee. So you
mean to say that date range has to be generated for each employee.
Could you suggest the format in which you want this to be done ?
Regard
Vasant
> Hi Vasant,
>
> This works great. Thanks for your help. Need a small cha
You're welcome.
However, both works. 1st one is having reference of the text, and in second
one, text is within the formula. That's the only difference.
AJ
On Thu, Jul 29, 2010 at 1:42 AM, sudarshan rampe wrote:
> thanks abishek the second one worked out..
>
>
--
No Problem.
Dave.
Date: Thu, 29 Jul 2010 16:41:18 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Index match with 3 criteria
To: excel-macros@googlegroups.com
Thank you so much. I just couldn't see it. I hate when that happens.
From: Dave Bonallack
To: "excel-m
Thank you so much. I just couldn't see it. I hate when that happens.
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Thu, July 29, 2010 4:38:54 PM
Subject: RE: $$Excel-Macros$$ Index match with 3 criteria
Hi Nadine,
Have a look at the formula
I sent this email this morning and haven't heard back. I really really hope
someone can help with this because I truly have no clue on how to make this
work
and really need it to. I know I could do a concatenation cell in each sheet
and
search that way but I'd really like to keep it cleaner.
Hi Nadine,
Have a look at the formula. The $M$2:$M$5 shoukd be $R$2:$R$5
Regards - Dave.
Date: Thu, 29 Jul 2010 07:28:24 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Index match with 3 criteria
To: excel-macros@googlegroups.com
This worked originally but for some re
Hi,
Try this line of code:
Cells(ActiveCell.Row, Columns.Count).End(xlToLeft).Offset(0, 1).Select
Regards - Dave.
> Date: Thu, 29 Jul 2010 05:27:59 -0700
> Subject: $$Excel-Macros$$ create macro to find first empty row
> From: federico.mazz...@ikea.com
> To: excel-macros@googlegroups.co
Thanks a lot stuart...
Actually i have a excel file in which there are names written of all the
operators and each operator will have a excel file.
In the macro code it will select a file usin the application.open method
then it will calculate the data accordin to the criteria specified. Afte
i need to create a macro which put the cursor in the first empty cell
in the same row of the actual active cell. i tried to use a for cycle
but it doesn't work, could you please help me?
Dim sh As Worksheet
Dim lColonna As Long
Dim row As Range
Set sh = Worksheets("sheet1")
ActiveCell.Offset(-1, 1
please find the attached sample data...
and the website :-
http://www.melissadata.com/lookups/phonelocation.asp?number
I want to extract zipcodes(primary) from a webpage on the basis of phone
numbers and paste it into the excel sheet in the next cell front of the
corrsponding phone numbers.
If t
plz provide us some samle data and the website where to upload the data.
regards,
simran
On Thu, Jul 29, 2010 at 2:48 PM, Manoj kumar wrote:
> Guys,
>
> Can anyone help me on this?
>
>
>
> Thank You...
>
>
>
>
> On Mon, Jul 26, 2010 at 11:22 AM, Manoj kumar <
> manoj.vishwakarma...@gmail.com> wr
Hello All,
I have a collumn called problem, in that collum i recieved a mapped value
but it is doing it wrong.
I need the formula to get the highest value in "*Kgs*" Column (criteria same
*date*, same *code_number)*.
Based on the *Kgs *Maximum value, it has to get the "*code*" on the left
side
Guys,
Can anyone help me on this?
Thank You...
On Mon, Jul 26, 2010 at 11:22 AM, Manoj kumar <
manoj.vishwakarma...@gmail.com> wrote:
> Hi,
>
> I need to open an internal webpage after a phone number is entered into a
> spreadsheet then submit these details on the webpage and the result is
Hi,
Can u check this this can be helpor not
On Wed, Jul 28, 2010 at 11:21 PM, Ahmed Honest wrote:
> Dear All,
>
> Please find attach the sheet wherein I need the Data from "Tracking Sheet"
> should go the each individual sheets the data.
>
> Please see attach file for more understanding.
>
>
thanks abishek the second one worked out..
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://
Hi,
In the below code I have vba code which get student wise report using
pivot table. Here I need chart with report also.
Thanks in advance.
Sub pivot2_creation()
Dim pvt_che As PivotCache
Dim pvt_tbl As PivotTable
Set Rng = Sheet1.UsedRange
Set pvt_che = ThisWorkbook.PivotCaches.Create(xlDatab
Hi,
You can use below formula in H4 cell
=IF(ISERROR(D10/G10),"",(D10/G10))
Thanks,
Noorain Ansari
--
Date: Wed, 28 Jul 2010 21:08:00 +0300
Subject: $$Excel-Macros$$ Help: Creating formula using VBA
From: janetdicks...@gmail.com
To: excel-macros@googlegroups.com
>
>
Hi Dave,
Much appreciation every works perfect.
Hug & Love
On Thu, Jul 29, 2010 at 7:08 AM, Dave Bonallack
wrote:
> Hi,
> In H4 enter:
> =IF(G4=0,"",D4/G4)
>
> And similarly for other cells that contain a division operator
> Basically we are saying, if the denominator = 0 then nothing, otherwi
=CONCATENATE(A1," ",TEXT(DATE(YEAR(TODAY()), MONTH(TODAY())+1,
DAY(TODAY())),"mmm-yy"))
A1 is the cell value where your text is stored.
OR
=CONCATENATE("Dr.X, may verify the particulars furnished above and inform
whether any changes before the pay bills are prepared for the month of
",TEXT(DATE(
20 matches
Mail list logo
