Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro within a macro and Macro Prompts
Is there any way to create a macro that prompts users for certain information
or requests users to do a specifice task? I'm asking because I need to create a macro that compiles data from multiple files then sorts/organizes said data. The problem is that neither the file naming nor the layout of the data within the spreadsheet is standardized (i.e. Net Income may be found in cell J52 on "Q01-05 Net Income.xls" and N87 on "Q2-2005 NI.xls"). Also, is it possible to run a macro within a macro? I guess that would just be extra steps within one big macro, but if possible I'd like to break steps down into individual macros and then just have one master macro. Thanks in advance comparini3000 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro within a macro and Macro Prompts
for prompts have a look at INPUTBOX. As to multimacros
sub mymastermacro() do something call macro1 call macro2 etc end sub -- Don Guillett SalesAid Software "comparini3000" wrote in message ... Is there any way to create a macro that prompts users for certain information or requests users to do a specifice task? I'm asking because I need to create a macro that compiles data from multiple files then sorts/organizes said data. The problem is that neither the file naming nor the layout of the data within the spreadsheet is standardized (i.e. Net Income may be found in cell J52 on "Q01-05 Net Income.xls" and N87 on "Q2-2005 NI.xls"). Also, is it possible to run a macro within a macro? I guess that would just be extra steps within one big macro, but if possible I'd like to break steps down into individual macros and then just have one master macro. Thanks in advance comparini3000 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro within a macro and Macro Prompts
thank you very much don. i have one more question...
if i have a list in column A...say it goes from A2 to A16. if the user puts in a value in cell A1 what should i do to have the macro cut the value in A1 and move it to A17? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro within a macro and Macro Prompts
If you mean automatically, then
right click sheet tabview codeinsert this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$A$1" Then Exit Sub Application.EnableEvents = False lr = Cells(Rows.Count, "a").End(xlUp).Row + 1 Target.Cut Cells(lr, "a") 'or 'Range("a" & lr).Value = Target 'Target = "" Application.EnableEvents = True End Sub -- Don Guillett SalesAid Software "comparini3000" wrote in message ... thank you very much don. i have one more question... if i have a list in column A...say it goes from A2 to A16. if the user puts in a value in cell A1 what should i do to have the macro cut the value in A1 and move it to A17? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) |