Hi guys,
For example i have in sheet 1 - cell C4=ABC15102 and in cell D4=ABC2471. I want when is written something in D4 the text to be copied in another cell from sheet 2.
And when you have the same text in sheet 2 to give a error or highlight text and announce you that.
Do you have any ideea of how to make such statement?
Thanks in advance
Hi Ionko welcome to the forum.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thank you sir. I had the impression the attachment fille is there. @Sorry i cannot use the original data, but i hope the example is ok.
Try in sheet File nr
B2=IFERROR(INDEX(MAIN!A:A,MATCH('File nr'!A2,MAIN!B:B,0)),"") and drag down!!
Thank you sir. I m trying now to highlight if the same file nr is in two different cells shown
Hei Shukla, if to this B2=IFERROR(INDEX(MAIN!A:A,MATCH('File nr'!A2,MAIN!B:B,0)),"") i want to highlight the file nr that is not assigned to a doc nr.
Should be in a different cell? Or i can do it with ANDIF?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks