Search results

This has been altered since yesterday when that was posted and I haven't had a reply to the question so I thought I would ask it again

Hi I am trying to create a form where the user will be able to move machines from building to building depending on the building, floor and zone they choose. It will also look at the month to determine from when the move needs to happen. It will then reference one of the three tables that...

hi there i am looking at using a button on the home page of my work book and wanted one to open a form that i have created but cannot figure out the syntax for it. so far i have this Public Sub callform() openform End Sub and this Public Sub callform() Run ("UserForm_Initialize")...

what I want the form to do is have the user enter a serial number, building, floor and zone into the floor and a month in which it will be moved from. The form will look at the serial number, look at the tables created to see how many meter reads it has and then move that to the appropriate...

https://www.dropbox.com/s/oo1dlsyw87vlyru/Moving%20form.xlsm?v=0mwns i think that works, if not i can email you it

could someone please help me, what I am looking at doing is producing a form that will move machines according to their serial number to different buildings based upon months. I know the basic procedure for this using macros, but I am unfamiliar with forms in excel. If anyone could help that...

Thank you, now works perfectly! Rob

Hi, this is being run in the ProjectBook1.xlsm workbook trying to copy into the Leatherhead_Greenford MASTER_TEST.xlsx workbook the statement which gives the error is Set To_Sheet = ActiveWorkbook.Worksheets(sheet_name) Thanks Rob

Thanks for your reply, I may be being very stupid with this but when I run the code, it comes up with this error Run time error '9' Script out of range Any idea on how to resolve this? Thanks Rob

Hi I am trying to create a macro that will work by looking at a cell to determine the month, then copy the information into the relevant month on another workbook. This is what I have so far: Sub transfer() ' transferring Macro If ("E3") = "Jan" Then...

thanks, I seem to have done it now

Hi I have managed to work out most of what I am trying to achieve through my own knowledge and by reading forums such as this but I cannot find what I am looking for unfortunately. Basically I want to have a macro that will copy the information from a form to a different workbook but...