mdasifiqbal
05-10-2017, 09:13 AM
Dear Friends
I have a receipt format for which I tried to record a macro for copy and paste of data to mater files named ''Bank_Log'' & ''Cash_Log'' from the Sheet ''Receipt'', Merged cell B9 has a dropdown with 5 options for first 4 option I want the data to be pasted from ''Receipt'' sheet to Sheet ''Bank_Log'' and when I choose the option "Cash'' the data should be pasted from ''Receipt'' Sheet to ''Cash_Log''. The data from Range B,C&D, F,G&H and J,K&L (13:22) should be stacked serially, there are chances that next receipt may contain fewer invoice count. Need your help to resolve the issue. highlighted cells in yellow are mandatory which needs to be copied and pasted in master sheets.
Thanks & Regards
Md Asif Iqbal
I have a receipt format for which I tried to record a macro for copy and paste of data to mater files named ''Bank_Log'' & ''Cash_Log'' from the Sheet ''Receipt'', Merged cell B9 has a dropdown with 5 options for first 4 option I want the data to be pasted from ''Receipt'' sheet to Sheet ''Bank_Log'' and when I choose the option "Cash'' the data should be pasted from ''Receipt'' Sheet to ''Cash_Log''. The data from Range B,C&D, F,G&H and J,K&L (13:22) should be stacked serially, there are chances that next receipt may contain fewer invoice count. Need your help to resolve the issue. highlighted cells in yellow are mandatory which needs to be copied and pasted in master sheets.
Thanks & Regards
Md Asif Iqbal