Adding Cells

Solved/Closed
DC - Mar 12, 2010 at 08:56 AM
rizvisa1
Posts
4479
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 replies

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
Please help!!
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
4479
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
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770 > 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
rizvisa1

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

Also, this is going to be completely from scratch.

Thanks.
0