Hi everybody, my problem is the following. I am trying to develop a little system for a sales flash that will be inputed into a major cash flow.
My thing is this, i have a database which controlls stock in access, it has two tables, one table is a control table which has the original values of stock, the other one is the actual table with the actual stock.
I then insert the two tables into excel to work with them to set up my sales flash.
screenshot sales table.jpg
This first screenshot is the sheet with my two tables inserted and some calculations that i have done to collect total sales, revenue, profit....
screenshot main table.jpg
This is the main table, it is going to have some columns for each week so that the weekly values are the ones displayed for sales, profit and share of sales, the problem is that i cant make it to update automatically if the dates are between xx/xx/xxxx and yy/yy/yyyy, is there a posible way for doing this with a macro?
Regards, axtrix
Bookmarks