Help.. New to VBA... Macro1 to Input Macro2 to Transfer... but happening at once! Help!

[jessica81]

New to the VBA scene and I need a simple solution to my problem. I wrote two macros, made two buttons and attempted to assign the macros to each. My intent was to have a INPUT macro where you are prompted by input.boxes to do the data entry on a sheet named "cover" then I created another that is supposed to cut and paste (transfer data button) your info to the database. HOWEVER the 1st macro is prompting you as it should, but in stead of filling the cells on "cover" its populating the data base. How do i correct. Macro1 doesn't reference the database or Macro2 at all, so Im not sure how its happening.

[InvisibleMan]

Unless you explicitly specify the workbook and worksheet, the code will default to working on the active sheet in the active workbook.