Dear Friends,
I need help in resolving one issue of Data filtering and copying to another Sheet. I would thank in advance for the help.
Problem : (a) I have a sheet Say Sheet1 having some 20 plus columns of data up to approximately 100 rows. But all the rows are not filled serially. Column "B" which I need to make the reference of filtering data. So the Range I need to filter is B2:B100.
(b) Now I need to have a code that should filter the filled rows in the Range (B2:B100) excluding the empty rows to another say sheet2 and paste them from Range B6 on wards.
(c) Then I need to apply the serial number to the the pasted data in column A (A6 as 1, A7 as 2 and so on till available data in column B in sheet 2. That means, First filter the data (filled rows) within the range B2 to B100 from Sheet 1 and copy_paste in Sheet2 and give the serial number in Column A of sheet 2 to the rows pasted from Range B on wards. This is needed to be done from a user form command button say CommandButton1.
Kindly help me out. Awaiting an early reply.
Thanking you all.
Regards,
nm766