• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to get row address and row numbers after filter of visible cells

Ratan Bhushan

Ratan Bhushan

Member
Hi team

I am running a macro where I have to filter data few times.
Everytime I filter data, I need to count how many rows are there and what are their row address to use them

What code I can write to get the count and address of visible rows.

Please help.

Thanks
Ratan
 
Hi Ratan,

Do want the count and row number in your macro to use for some other part? Can you upload a sample file with your macro in it.

Regards,
 
I want the count of visible rows after filter and repective rows address or numbers. I cant upload the sample file. Office data there is....
 
Somendra Misra said:
Just create a dummy file with the same number of columns and may be 100 rows of data.

Regards,
Click to expand...

Somendra Misra said:
Just create a dummy file with the same number of columns and may be 100 rows of data.

Regards,
Click to expand...
Please run last two codes:remove duplicates

Here I want when the data is filtered, I want column w in work where if a cell in w column is blank then put the value of other visible cells in w column
 

Attachments

Ratan Bhushan said:
Please run last two codes:remove duplicates

Here I want when the data is filtered, I want column w in work where if a cell in w column is blank then put the value of other visible cells in w column
Click to expand...
Well I did not understand, your this comment is very different from your last requirement. Can you explain what you exactly want to do?

Regards,
 
In column A you will be seeing the cells in red colur. I shalll use them as criteria to filter the data. When I filter the data I shall get two different rows. Where in column W I will check if both rows have data or not.
In where there will be no data, I will copy from the other row and paste it there. then I delete the other row where the data was already in column w.
 
Somendra Misra said:
So you want to do this for each duplicate of column A? And I hope there will be max 2 entries per item in column A. Kindly, confirm.

Regards,
Click to expand...
Yes sir
every day I have to prepare this report
every day there shall be arounbd 50 -60 rows, out of which 25-30 will remain as we have to copy the data from the cells which has value into blank cell of W column.
Every time maximum there is only 2 records.

Can it be dynamic if we may encounter 3 or 4 records of same code.
 
You must log in or register to reply here.
Back
Top