Hi
I have a column say A contained the following values
abc
abc
abc
abc
xyz
xyz
I want to copy the value from A column and past it on "newworkbook" based on condition like
IF CELLS(1,1).VALUE="abc" THEN
copy the rows only contain "abc" and past on "newworkbook"
Can anyone help me thanks
Asif
Not sure if "newworkbook" is actually a new workbook or just a different sheet name. Since you didn't indicate a sheet name for a New Workbook I will assume you meant a different sheet name. If the former then you will just need to change the copy line to reflect the accurate paste location (i.e. Workbook.Worksheet.Range)
Please Login or Register to view this content.
If you are happy with my response please click the * in the lower left of my post.
Another option
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks