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.

Adding Cells
Excel arrow keys not moving cells - Guide
Excel macro to create new sheet based on value in cells - Guide
Based on the values in cells b77 ✓ - Excel Forum
Arrow keys scrolling in Excel ✓ - Excel Forum
Copy cells from one sheet to another - Guide

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!!!!!!!!!

Answer 2 / 3

DC
Mar 12, 2010 at 01:16 PM

Please help!!

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?

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!!!!!!!!!!!

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

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.

Similar discussions

help me to add particular cells

Ig stories from close friends to public

Fill adjacent cell with number from text answer

Condition formatting on changing cell color based on another cel

Excel function question

Similar discussions

Subscribe To Our Newsletter!