#1
|
|||
|
|||
If a cell equals amount in column B.
I am trying to do the following. I have no idea how to do this. I am sort of new to excel, and I am not even sure I am asking the question right, or if this can even be done.
1) If a cell equals 111 in column B, row 2, then list Row A:3 through H:3 in a list, on Sheet 2. 2) If a cell equals 222 in column B, row 3, then list Row B:3 through H:4 in a list, on Sheet 3. 3) If a cell equals 333 in column B, row 3, then list Row A:3 through H:3 in a list, on Sheet 4. 4) If a cell equals 444 in column B, row 5, then list Row B:3 through H:4 in a list, on Sheet 5. Let's Say: 5) If cell equals 111 in column B, row 27, then it would list Row A:3 through H:3 in a list, on Sheet two below # 1, as the data needs to be preserved in a list from previous entry 1). This goes on or 211 rows. I want it to keep the Row Data 'as is' when it moves it to the New Sheet. Thanks! |
#2
|
||||
|
||||
You want a macro to create and populate as many as 211 worksheets?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
If column B cell is a certain value then copy and paste the value to column A | Snaybot | Excel Programming | 1 | 12-01-2015 07:10 PM |
Cell equals zero or another cell in IF statement | dirtboy | Excel | 3 | 06-20-2014 01:44 PM |
keep each item/cell in column A associated with a group in column C | ht889 | Excel | 1 | 02-25-2014 12:36 PM |
Naming a cell then linking with a certain amount of charachters looses content. | shabbaranks | Excel | 1 | 12-27-2011 01:06 AM |
How can I delete the content of a cell in column if the cell value is more than 1000? | Learner7 | Excel | 2 | 06-27-2011 05:44 AM |