Hi

Respected Sir/Mam.

Hopefully you are doing well.

Actually I have facing this problem during Excel Macro.

I have made Excel Dashboard for stock Management system.

I runs Macro and copy 4 cells purchasing data, then go to purchases sheet and paste that data. then i stop the macro and assign that macro to the Purchase Entry button which is found in the dashboard sheet. I have two buttons on dashboard i.e Purchase Entry, Sale Entry.

Problem is arrising when i Enter all purchases data and by mistake if i click to Sale Entry Button, that All purchasing record goes to Sale Sheet and vise versa.

I need yours kind support please.