witsonjoyet
New Member
Greetings of the day,
Since 2 weeks i am trying to solve one macro but failed to do so. Actual problem is in my excel book sheet 1 contains one standard format of Delivery Challan (For those items are going out from my company , i need to make a list of items and nos have to give the print to customer and get the sign from him). in sheet 2 i have the sale quantity for the same items. Daily i have to give prints for the items and as well as the same no of items have to be shown in sheet to according to the date.
Say if today i have sold 200 pizzas , then in today's date i have to give one delivery challan, and as well as i have to enter the 200 pizzas in sheet 2 in today's date column. for tomorrow simply i change the date in sheet 1 and insert the no of pizzas and i can give the print. but the problem is how can i select that date in sheet 2 to enter the no of items automatically?
In sheet 1 if i select 7/10/2014 then the same date column should be selected in sheet 2 only.
Would you please give me the macro for this ? as i have given simple example but i have to prepare the data for more than 230 items every day
Regards
Witson
Since 2 weeks i am trying to solve one macro but failed to do so. Actual problem is in my excel book sheet 1 contains one standard format of Delivery Challan (For those items are going out from my company , i need to make a list of items and nos have to give the print to customer and get the sign from him). in sheet 2 i have the sale quantity for the same items. Daily i have to give prints for the items and as well as the same no of items have to be shown in sheet to according to the date.
Say if today i have sold 200 pizzas , then in today's date i have to give one delivery challan, and as well as i have to enter the 200 pizzas in sheet 2 in today's date column. for tomorrow simply i change the date in sheet 1 and insert the no of pizzas and i can give the print. but the problem is how can i select that date in sheet 2 to enter the no of items automatically?
In sheet 1 if i select 7/10/2014 then the same date column should be selected in sheet 2 only.
Would you please give me the macro for this ? as i have given simple example but i have to prepare the data for more than 230 items every day
Regards
Witson