Hi Guys
Hoping someone can help me with this one!!!
Attached is a sample of the workbook I am working on (original has over 3000 entries and more get added weekly)
What I have is a main spreadsheet (which holds all the information) and what I need to do is link this to other spreadsheets (so basically instead of having 10 workbooks containing similar information we have one and when you update this it will update everywhere else within that workbook (i.e change of address)
Currently the column I am working on is the Newsletter column (Column Q) what I need is a way to copy information from "Main" to "In Brief (Post)" if Column Q has a "P" and again to "In Brief (Email)" if column Q has an "E" and do nothing if Column Q has a "No" in it.
"Main" is an ongoing spreadsheet and names and addresses will be added continually.
I look forward to any comments, assistance and suggestions
Thanks
Bookmarks