I appreciate this was a long time ago but how could you mod this to find next blank row and then paste? as I have several users submitting data to a mastersheet
Sir how can modify your instructions to open a file (xls) insert text in range (H7) and in range H36 ( "PA I D" & "_" & (date()+45). and save the file as xls and pdf.Thank you
I appreciate this was a long time ago but how could you mod this to find next blank row and then paste? as I have several users submitting data to a mastersheet
How do you do this by simply referring to another worksheet within the workbook?
Sir how can modify your instructions to open a file (xls) insert text in range (H7) and in range H36 ( "PA I D" & "_" & (date()+45). and save the file as xls and pdf.Thank you
Is it possible to write to this workbook without opening the workbook, saving and then closing every time?
what about a opened book. How to refresh it without close and open it again?