Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Multisheets, submit button to update database sheet
Greetings,
Anyone tell me the best way for this outcome? In Excel i have two worksheets (T)=data field sheet (X)Datebase sheet (T) is the only sheet where a user inputs data. would like a submit button on (T) so that when all inputed data from all rows in column A (T) is submitted it will then insert a new column B in (X) I guess this is visual basic type stuff not sure though, any help is appreciated. joe |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Multisheets, submit button to update database sheet
This will copy and insert a row before column B:B in sheet X
placing the latest data to the left of previous data. There is also a Clear contents for column A:A in sheet T after data has been inserted, just remove the " ' " in front of the 'Selection.ClearContents to activate it. This is a recorded macro ( you could do it yourself, by turning on the record macro button while you do what you want done, then assign it to any button or autoshape) Sub submit() Columns("A:A").Select Selection.Copy Sheets("X").Select Columns("B:B").Select Selection.Insert Shift:=xlToRight Sheets("T").Select Columns("A:A").Select Application.CutCopyMode = False 'Selection.ClearContents Range("A1").Select End Sub " wrote: Greetings, Anyone tell me the best way for this outcome? In Excel i have two worksheets (T)=data field sheet (X)Datebase sheet (T) is the only sheet where a user inputs data. would like a submit button on (T) so that when all inputed data from all rows in column A (T) is submitted it will then insert a new column B in (X) I guess this is visual basic type stuff not sure though, any help is appreciated. joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Submit Button? | Excel Discussion (Misc queries) | |||
How do I create a submit button to an email address in excel? | Excel Discussion (Misc queries) | |||
Submit Button | Excel Worksheet Functions | |||
How do you set up a submit button to attach worksheet in email? | Excel Discussion (Misc queries) | |||
Form with submit button | Excel Worksheet Functions |