Please Help, this should work.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to enter a number into a cell and have a table or new
spread sheet pop up based on the number that was entered. For example, if I
enter a "4" in a cell I want a 1x4 table or spread sheet to pop up. I would
then enter a value in each of the new four cells then the sum of those values
would be placed in the cell immediately to the right of the "4" that was
entered initailly. This has got to work. If it can't please suggest an
alternative. Thanks.
 
How about an inputbox with four numbers separated by a space
then parse that and sum the values.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I make a new spread sheet pop up, based on an entry in a c. 1
value changes after hitting Tab or Enter button 2
problem with fractions to decimal 1
Change all text on Spread sheet 1
how to continue writing in a single cell? 3
color formula 1
Help to create a macro 2
Formula help please 2

Back
Top