Hello,
Antony helped me with this macro in first place, think this was 8-10 month ago.
all worked fine.
but now we need to change something and i can't figrue out how.
is there anyone up to and can have a look and help me please?
What i want to get running is if i push on the button Pick is that the macro checks if in field F7 a "batch" is selected if not messagebox should come up please select a batch.
if field H7 (picker) is not filled in with a name then messagebox comes up please fill in a picker name
if field J7 (Time) is not filled in a messagebox comes up please fill in the pick start time.
if all fields in line 7 (F7, H7, and J7) are filled in the macro should search for all fields in the sheet with a batch number in column F (start search from row12) and replace the batch numbers (for example B1 with the name in field H7 and the time in filed J7) the name should go in column F start row 12 (Picker) and the time in cloumn G (start) start row 12 for that batch number.
can someone help me please?
PPP report empty.xlsm
thank you in advance
Arthur
Bookmarks