Previous Topic Next Topic

Adding Cells

[Solved/Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 -
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 replies

Answer 1 / 3

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!!!!!!!!!
Answer 2 / 3

Please help!!
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
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?
Report
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010
 >
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
Could you help me out with this one?

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

I responded to your questions. Thanks in advance!!!!!!!!!!!
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768 >
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010
Please upload what you have so far at some share site like https://authentification.site
Answer 3 / 3

rizvisa1

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

Also, this is going to be completely from scratch.

Thanks.
Ask a question