Excellent improvisation Excel Beginner. Love it!
On Sun, Nov 25, 2012 at 10:53 AM, >>Excel Beginner<< <
excelbegin...@gmail.com> wrote:
> Hi Rajan sir,
>
> Please find the attachment. I had been given to another
> solution.
>
>
>
>
>
> *Regards,*
> *
> *
> *Excel Beginner*
> *
>
Hi Rajan sir,
Please find the attachment. I had been given to another
solution.
*Regards,*
*
*
*Excel Beginner*
*
*
On Sat, Nov 24, 2012 at 10:11 AM, Rajan_Verma wrote:
> *HI,*
>
> *As per your formula if you have 50 Rows you need 50 Index to do the same.
> *
>
> * *
>
> *Go
On Saturday, November 24, 2012 8:47:54 PM UTC+5:30, era_kar wrote:
>
> Hi,
> One way is finding the matching cells, by copying sheet3 in sheet1 and run
> the program.In column "H" Available are matching cells.Then filter
> the blanks selecting upto 14 rows. you will get what you want.
> - Karu
Hi Guys,
Find attached a simple web query that is currently being refreshed every
minute. For the life of me, I am unable to figure out how to have new
"refreshed" data placed directly below the previous data. In anycase, I
realized that this would not solve all my issues.
Here is what I am ult
Hi,
One way is finding the matching cells, by copying sheet3 in sheet1 and run the
program.In column "H" Available are matching cells.Then filter
the blanks selecting upto 14 rows. you will get what you want.
- Karunanithi R
From: Prabhu
To: excel-macros@goo
Another shorter programming solution would have been to autofilter column B
and copy visible cells into a table and do the same thing and
let CopyDataToTxtFile do the same thing. am I wrong?
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) U
Hi Ganesh
You can try that
Create a module and copy paste into it
Sub CopyMergeTxtFiles()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
.Calculation = xlCalculationManual
.EnableEvents = False
End With
Dim ws As Worksheet
Dim i As Long, j As Long
Dim lastr As
Hi Friends,
I have to compare two sheets and copy the unmatched rows to the 1st sheet.
Example need compare sheet3 column A in to sheet 1Column A and copy the
unmatched items in Sheet 3 and to be pasted in bottom of Sheet 1.
Note: Need to compare Sheet 3 to Sheet 1 not Sheet 1 to sheet 3
when
