rocketman70443
New Member
- Joined
- Dec 11, 2010
- Messages
- 37
http://www.mrexcel.com/forum/showthread.php?t=552168
This post is a result of the above posting in the Access forum. I decdied for now to attack the source data before being imported into the database.
I have a spreadsheet that has the category sales for each customer. If a customer didn't buy from a category, the record doesn't exist. There is no zero, no null, there simply isn't a line that has the customer name & that category.
What I want to do is add that line in.
To keep it simple, my sales sheet columns are:
A: Customer ID
B: Category
C: Category Sales
The category array goes from a1:b22, in a spreadsheet called CATID.xls. But I can move it into the workbook with the sales data, or even onto the same sheet, if needed.
Is there anyway I can do this?
This post is a result of the above posting in the Access forum. I decdied for now to attack the source data before being imported into the database.
I have a spreadsheet that has the category sales for each customer. If a customer didn't buy from a category, the record doesn't exist. There is no zero, no null, there simply isn't a line that has the customer name & that category.
What I want to do is add that line in.
To keep it simple, my sales sheet columns are:
A: Customer ID
B: Category
C: Category Sales
The category array goes from a1:b22, in a spreadsheet called CATID.xls. But I can move it into the workbook with the sales data, or even onto the same sheet, if needed.
Is there anyway I can do this?
