ailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Tuesday, July 05, 2011 6:30 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ select row which have specified data
hi rajesh
i used formulas in sheet 1 , to get data from sheet 2
just enter your data in sheet 2,
Hi Ankur
Thanks for the formula, but the values in the sheet 2 will change
daily and I have to keep the data in sheet 1 permanently. that is why
I am asking for code.if any idea pls tell me how can we do the same
thing with a code.
Regards
Rajesh Kainikkara
On 7/5/11, ankur wrote:
> *hi rajesh
>
*hi rajesh
i used formulas in sheet 1 , to get data from sheet 2
just enter your data in sheet 2, it will be displayed against the date in
sheet 1
may this may help u
find attached file
*Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm
try this
Sub test()
Dim i As Long
For i = 2 To Sheets(1).Range("a65356").End(xlUp).Row
If DateValue(Sheets(1).Cells(i, 1).Value) =
DateValue(Sheets(2).Range("a1").Value) Then
k = Sheets(2).Range("iv2").End(xlToLeft).Column + 1
For j = 2 To 11
Sheets(2).Cells(j, k).Value = Sheets(1).Cells(i, j).Va
Hi Experts,
Please find the attached file & tell me the code how to select the
date value in "sheet2" cell "A1" in Sheet 1. After selecting the row
then all the data in sheet2 range("B2:B11") have to copy & paste in
the sheet1 colomns("B:K").
Regards
Rajesh Kainikkara
--
--
