Dear All,
I have here one excel file called ( Daily_PRICING .xls ), located on my C Harddrive.
This File ( workbook ), contain 4 Worksheets , as following:-
Sheet-1 - For Our First Product, which is PROD_1
Sheet-2 - For Our Second Product, which is PROD_2
Sheet-3 - For Our Third Product, which is PROD_3
Sheet-4 - For Daily Report
The First sheet which is called ( PROD_1 ) , have 6 colums, which are :-
1- Date
2-Low Price
3-High Price
4-Average Price
5-Average Price Market
6-Change.
On every day morning, i used to enter the low price, high price and then i got automatic the others ( Average Price-Average Price Market-Change ).
The One which i need your Help is in the Sheet No 4.
Sheet No 4, we need to send it everyday, and it should have the following :-
1- Product Name
2-Date
3-Current Price.
I want only to enter the Product Name , and then automatically, it needs to read the Date Automatically, from the date which i enter it before, and then on the current price, it will take the Avergae for that day.
I want to make it automatic.
Can you please tell me how to do it, either manually, or using macro.
waiting for your help.
Bookmarks