User Profile
Jolange
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Multiple spreadsheet in email
Hi I have to send around 40 emails to different people each week, in each week have to put 1 page of a spreadsheet - different for each person is there any easy way to do it. The overall objective is to share each persons sales figures with them but not with anyone else and a shared message that is the main body of the email. I have been copy and pasting each one into each email but it takes forever and it's a brain drain boring job, any ideas? Thanks.788Views0likes1CommentRe: checking postcode is on a list formula
Bennadeau Thank you this is great but now i can only get a false result not a true even if i copy and paste somthing from the list, any suggestions please? Formula as i have it is =ISNUMBER(MATCH(F2Sheet2!BI2:Sheet2!D3190,0)) I was using YO126EY as a test and this is exactly how it is in the list i was given.4.7KViews0likes2CommentsRe: checking postcode is on a list formula
Hi Riny_van_Eekelen Thank you, got this one to work but now i am getting all false results even when i type the top item from the list, any ideas how to get true? I have even copied and pasted from the list to get it exact but still get false.4.7KViews0likes1Commentchecking postcode is on a list formula
I am trying to get a formula that will check an entry in column E is on a list and answer yes or no. This is a form where a postcode will be entered and if it is on a list of 3190 entries held on "Data1" sheet will enter yes into this cell. Can you help? I am pretty new to formulas an struggling. Thanks.4.8KViews0likes7Comments
Groups
Recent Blog Articles
No content to show