User Profile
Jase-R
Copper Contributor
Joined 11 months ago
User Widgets
Recent Discussions
Automatically highlight a cell in the column of one sheet if it doesn't appear in other sheets
I am wondering if anyone can help me I have customer names with supply requests that I copy from a daily report. I have two other sheets that reference the names exactly to automatically fill sheets for printing. The issue is if we have a new customer coming in I would like that cell to highlight to show that the name doesn't exist in the other sheets ie. Sheet 1 has unqiue customer names in column d, If that name does not appear in any cells in sheet 2 and sheet 3 I would like it to automatically fill the cell yellow. Any help would be greatly appreciated 🙂 JasonSolved838Views0likes5CommentsHelp with automating data in a table from one sheet to another
Hello all, I am trying to automate data based off a table that gets generated daily. As the cells I am trying to autofill will have the information come off variable rows daily I am wondering if anyone could help. Essentially it would be having a cell look for a matching name on column D in another sheet. If it finds that name then it would pull the numerical value from column G from the corresponding row where that data in column D was matched from. I am fairly new to formulas in excel so any advice will be greatly appreciated. Apologies if my terminology seems vague. Thanks in advance!Solved710Views0likes2Comments
Groups
Recent Blog Articles
No content to show