Hi everyone,
This is my first time here and I'm a self-admitted newbie at Excel. I think this might be a simple problem but I really, really, really don't know how to proceed. Any help would be great. Honestly. I'm using Microsoft Excel 2010.
Now in my Sheet 1, I have created a Table with data which I refer to as Master database.
It looks like this:
Date Last Name First Name Email Mobile Number
And it has all the entries below (upto 2000).
Now basically this is input from consumers and sometimes we either have a entry for E-mail Address or for Mobile Number and sometimes it's blank. Now I am creating two other tables on a different sheet, same workbook.
One is called SMS database. One is called E-mail database.
Now whichever entry in my Master database has a mobile number (meaning it is not left blank in the mobile number column), I want all of that information to be automatically picked up from the Master database onto this SMS database sheet.
And similarly, any entry with text in e-mail address column, I want that whole info including Date, Names etc) to be copied onto the sheet Email database.
And I want this to keep happening automatically in the other two sheets everytime I fill out a Master dabatase.
Can anyone help me please?!
Thanks in advance!
This is my first time here and I'm a self-admitted newbie at Excel. I think this might be a simple problem but I really, really, really don't know how to proceed. Any help would be great. Honestly. I'm using Microsoft Excel 2010.
Now in my Sheet 1, I have created a Table with data which I refer to as Master database.
It looks like this:
Date Last Name First Name Email Mobile Number
And it has all the entries below (upto 2000).
Now basically this is input from consumers and sometimes we either have a entry for E-mail Address or for Mobile Number and sometimes it's blank. Now I am creating two other tables on a different sheet, same workbook.
One is called SMS database. One is called E-mail database.
Now whichever entry in my Master database has a mobile number (meaning it is not left blank in the mobile number column), I want all of that information to be automatically picked up from the Master database onto this SMS database sheet.
And similarly, any entry with text in e-mail address column, I want that whole info including Date, Names etc) to be copied onto the sheet Email database.
And I want this to keep happening automatically in the other two sheets everytime I fill out a Master dabatase.
Can anyone help me please?!
Thanks in advance!
