Hi all
i am looking for a macro that will ask the user to select a cell , macro should go forward if its a number
i know how to ask a user to select a cell (inputbox), but i donot how to get the following information
Code should run when only one cell is selected and on selection of multiple cells asks user to select only one cell
so lets say the user selected E2
The Code should automatically the day whic is fri, get order no (3751), get item name(screw)
and then paste it in non empty row in J column in this following order
day, order no , value of e2, item name
[ATTACH]n1223659[/ATTACH]
Regards
sobi