Log In
Register
Home
New Member
March 4, 2019
Offline
hi guys
I have a problem in excel , and i cant solve it myself, so can you give me hand ? i appreciate you ,
in the file that i attached to this mail i explain the thing that i want :
i have 2 worksheets . "bills" & "result".and every worksheets that i have infact have many tables and entries. i need a macro that search the first worksheet column "C" , and match it with the text that i write in the textbox. and copy and paste all entire rows data that matches , in a new worksheet like "result". if u can't undrestand me , sorry for my weak grammer. and you will find how that i want if you see the file .
in this case , i need to copy all of rows that the text in "name"'s column is "bahram", in "result" worksheet.
thanks ,
VIP
Trusted Members
June 25, 2016
Offline
Hi Bahram
Give this a try. Please note that I am using Advanced Filter with VBA.
You can refer here for more info on Advanced Filter https://www.myonlinetraininghu.....ed-filters
I did notice your data is not in a tabular format and it may cause a problem when extracting data.
I suggest that you always have your data in a tabular format.
You can refer here for more info https://www.myonlinetraininghu.....ata-format
Good luck.
Sunny
New Member
March 4, 2019
Offline
Hi ,
Thank you very much ,
Very nice and this is exactly what i want. Great job
one more question , if i want to print the "result" worksheet , after i run this macro , what should i enter ?
thank u again
VIP
Trusted Members
June 25, 2016
Offline
Just add this line before the End Sub
Sheets("Result").PrintOut
or if you want to preview then
Sheets("Result").PrintPreview
Just make sure that you have already done the page setup on the Result sheet.
Sunny
1 Guest(s)
