Previous Topic Next Topic

Adding Cells

Solved/Closed
DC - Mar 12, 2010 at 08:56 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 15, 2010 at 01:55 PM
Hello,

I am trying to build a macro that allows me to input a number on Sheet1 and then on Sheet2, add that number of Cells.

Example.

Sheet1 Data:

Number of Classes 2 would be inputted in B5
Number of Benefits 3 would be inputted in B6
Number of Groups 4 would be inputted in B7

Then on Sheet2:

Cell Inputted in cell
A1 Class1
B1 Class2
C1 Benefit1
D1 Benefit2
E1 Benefit3
F1 Group1
G1 Group2
H1 Group3
I1 Group4

These numbers would be an input from an associate
completing this spreadsheet.

3 responses

Answer 1 / 3
DC
Mar 12, 2010 at 09:00 AM
I forgot to specify that after those 3 numbers are entered on Sheet1, I want Sheet2 to update with a button on Sheet1.

So the Actor would enter the data on Sheet1
Click on the button
Sheet2 would update with the requested number of fields

Thanks in advance!!!!!!!!!
0
Answer 2 / 3
DC
Mar 12, 2010 at 01:16 PM
Please help!!
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 12, 2010 at 01:35 PM
So the user input will be always in cell B5, B6 and b7 and only based on these three cells, sheet2 will have rows added.

Do you have a sample work book or looking for every thing from scratch?
0
DCecil07 Posts 30 Registration date Monday March 15, 2010 Status Member Last seen September 15, 2010 > rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022
Mar 15, 2010 at 11:33 AM
Could you help me out with this one?

https://ccm.net/forum/affich-284298-adding-cells

I responded to your questions. Thanks in advance!!!!!!!!!!!
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766 > DCecil07 Posts 30 Registration date Monday March 15, 2010 Status Member Last seen September 15, 2010
Mar 15, 2010 at 01:55 PM
Please upload what you have so far at some share site like https://authentification.site
0
Answer 3 / 3
DC
Mar 15, 2010 at 06:38 AM
rizvisa1

You are correct on the inputs of B5, B6 and B7.

Also, this is going to be completely from scratch.

Thanks.
0

Similar discussions

Ig stories from close friends to public
Darren -
zara -

31 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response