LinkBack URL
About LinkBacks
How to automatically paste all the datas in rows of one sheet to be copied on another sheet if the value in the sheet matches? I want only those with ORDER IN Status to be copied on another sheet? PLease help......
How to automatically paste all the datas in rows of one sheet to be copied on another sheet if the value in the sheet matches? I want only those with ORDER IN Status to be copied on another sheet? PLease help......
Last edited by heiderayos; 09-15-2014 at 04:47 AM.
Hi heiderayos, welcome to the forum. Is hard to read and key in your value into excel and test.
One of the Forum Rule
Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Please help , i want the datas from Sheet one to be copied automatically on sheet only if the value matches as ORDER IN
Why not just use a filter on column G in sheet 1 and select the data ORDER IN?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Do you mean if "Sheet1" data is marked as "ORDER IN" then copy it to "Sheet2"?
YES Please
Then please use oeldere suggestion at post #4, simple and fast.
In case you don't know.
Excel 2007:
Please delete the 2nd row (Blank row can't filter), then
1. Select the 1st row
2.Go to Home> Sort&Filter > Filter
3. Click on the "ORDER IN" arrow
4. Tick only "ORDER IN"
All the "ORDER IN" will list down. Copy all and paste to another sheet.
The aim is not look back on sheet one... all those that marked with order IN on sheet will be seen on sheet 2
You don't add, why you don't want to filter.
So another approach, use the filter and copy the (filtered) data to sheet 2.
Don't "look back" on sheet one, is quite weird.
No so sure sheet 3 function fulfill your requirement?Haha
Ive seen the link you have given,,, Thank you so much... yes I can filter but there are more than one person to enter the data they dont want to go back on sheet 1 to see which inquiry order comes in... Thanks again!
So the file in my post#11 is okay for you?
The sheet3 return everything that match with the word "ORDER IN", same as you doing filter in sheet1.
PS: To retrieve more results, pls drag the function to the row you want.
I have tried it.. But when i insert {} the value dont come
You don't have to add them manualy.
use is CTRL+SHIFT+ENTER to confirm your formula.
Array formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Last edited by oeldere; 09-15-2014 at 07:19 AM.
Ok Thanks a lot
I cannot make it.... This is whole file... The value comes out is -
Thanks a lot...I made it...
Okay, "-" indicate can't match any data, you may change "-" to "", so it will show BLANK when can't match any data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks