nakedbamboo
Technical User
I have a question about MS Excel. I want to create a spread sheet that is interactive and flexible with a user. Want I want is to prompt a user for data input and have it create a new ROW with the data under a certain section.
First I do not know how to prompt users for data. Second I am having difficulty with the new ROW thing. I can record a macro to add a new ROW with no problem, but then if I have a macro do the same thing in a lower section the line numbers have messed up and things get out of synch. Is there anyway to edit a macro with another macro? Such as "if this macro runs, add a letter to the ROW to start from in the macro lower down the page".
Maybe I am thinking about this all the wrong way. Any suggestions?
First I do not know how to prompt users for data. Second I am having difficulty with the new ROW thing. I can record a macro to add a new ROW with no problem, but then if I have a macro do the same thing in a lower section the line numbers have messed up and things get out of synch. Is there anyway to edit a macro with another macro? Such as "if this macro runs, add a letter to the ROW to start from in the macro lower down the page".
Maybe I am thinking about this all the wrong way. Any suggestions?