I have attached the file. I have 2 worksheets
1) For state of ME col J =colum E*0.05
1) ME Withholding . I enter the data I ME Withholding daily. Later as required the JE colum is filled with the dates. It is left blank in some cases.
2) ME Processed. In this worksheet I enter the data from ME Withholding I copy the rows after I update rows with JE column, and those rows are pasted in ME Processed worksheet.
Later I select the data and run subtotal.
My question is
I would like to upload the rows from ME Withholding to ME Processed as soon I enter date in JE colum of ME Withholding . Is there any formula or macro for this ? Or is there any way this could be incorporated in MS Access database. ME Witholding
Note : I have one more file which is a has same structure as this file. That file is for CA only the percentage is .
For state of CA Col J has formula E*0.07