Hi,
I have am in purchasing and am currently working on a way to automate some of my looking up duties. I do not know how to attach the spread sheet I am having trouble with on this forum so I will try to explain as best I can.
I have created a spreadsheet that has product numbers on the y-axis, and dates on the x-axis. This spreadsheet is populated by purchase orders (i.e. product number 2 is due on Jan 3, 2006). I want to referance the dates to another spreadsheet that has product numbers, how much is scheduled and how much we have in stock. I want to add a column that will have the dates the P.O.'s are due.
I can not wrap my head around how to referance the date cells. The date cells would be the cells at the top of (x-axis) my spreadsheet whenever a cell has a non 0 number in any of the fields. Any help would be appreciated.
P.S.: I would like to learn about Macro's, I have taken a course at the local college but they tell me I will not lear about it until I have taken three other courses and even then I will not be able to edit any macro's that I make. Can someone point me to a good book or other resourse on the subject of Macro's? I see some books on this site do any of them show you how to build and work with Macro's?
Thanks.
Cool Kyle.
I have am in purchasing and am currently working on a way to automate some of my looking up duties. I do not know how to attach the spread sheet I am having trouble with on this forum so I will try to explain as best I can.
I have created a spreadsheet that has product numbers on the y-axis, and dates on the x-axis. This spreadsheet is populated by purchase orders (i.e. product number 2 is due on Jan 3, 2006). I want to referance the dates to another spreadsheet that has product numbers, how much is scheduled and how much we have in stock. I want to add a column that will have the dates the P.O.'s are due.
I can not wrap my head around how to referance the date cells. The date cells would be the cells at the top of (x-axis) my spreadsheet whenever a cell has a non 0 number in any of the fields. Any help would be appreciated.
P.S.: I would like to learn about Macro's, I have taken a course at the local college but they tell me I will not lear about it until I have taken three other courses and even then I will not be able to edit any macro's that I make. Can someone point me to a good book or other resourse on the subject of Macro's? I see some books on this site do any of them show you how to build and work with Macro's?
Thanks.
Cool Kyle.