VBA macro for button to transfer data from one sheet to another.

**coolhit** · 07-19-2009, 02:24 PM

Hi,

Could i please ask for assistant. I am newbie to macro and learning quickly.

I have 3 sheets.

sheet = Main Menu
sheet = Consumables In AM Rack
sheet = Consumables Used From AM Rack.

User enters a location in Main Menu sheet (vlookup lookup code and qty).

Then press the button "Transfer From STORAGE to USED". (black button)

This is where i need help. When the button is pressed i want to copy date& Authorised By(yellow box) to consumables used from AM Rack sheet. Delete the code & qty from from the Consumables In AM Rack and copy it to Consumables Used From AM Rack.

I have gone through this forum couldn't find anything that resiamble my problem

Any assistant would be appricated.

**royUK** · 07-19-2009, 04:27 PM

Take a look at the code in the Contcts form example

http://www.excel-it.com/vba_examples.htm

**coolhit** · 07-20-2009, 04:03 PM

Hi please could some assist me.

I have been trying to write macro hole day but not getting anywhere.

if someone can assit me i would mot appricate.

many thanks