im2bz2p345
Board Regular
- Joined
- Mar 31, 2008
- Messages
- 226
Hi all,
I have a very large spreadsheet and I made a small example from it:
Sheet1
<COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 36px"><COL style="WIDTH: 194px"><COL style="WIDTH: 36px"><COL style="WIDTH: 143px"><COL style="WIDTH: 36px"><COL style="WIDTH: 116px"><COL style="WIDTH: 36px"><COL style="WIDTH: 116px"><COL style="WIDTH: 64px"><COL style="WIDTH: 83px"><COL style="WIDTH: 64px"></COLGROUP><TBODY>
</TBODY>
In this example, I only have four facilities, but in my original file there are a ton (30+). In J2, this is what I need a formula or macro to do: search the entire row (A2:H2). If a value is found, copy the value (wherever it's found), then paste it in J2 & K2.
In J3, it would would search A3:H4, it would find the a value in C2 & D2, so it would need to copy those values in J2 and K2.
I can't do a simple =IF(ISVALUE()) because of sheer size of my original spreadsheet - as stated earlier there are 30+ facilities (there is information past column AD).
Hope there is someone that can help me out! Thanks in advance.
~ Im2bz2p345
I have a very large spreadsheet and I made a small example from it:
Sheet1
* | A | B | C | D | E | F | G | H | I | J | K |
1 | Facility1 | Facility2 | Facility3 | Facility4 | * | What I need | * | ||||
2 | 600 | Nursing Admin - Adult | 600 | Nursing Admin. | 600 | Nursing Admin. | 600 | Nursing Admin. | * | 600 | Nursing Admin. |
3 | * | * | 601 | Nursing Supervisor | * | * | * | * | * | 601 | Nursing Supervisor |
4 | 602 | Nursing Admin - Childrens | * | * | * | * | * | * | * | 602 | Nursing Admin - Childrens |
5 | 603 | Nursing Interns | * | * | * | * | 603 | Nursing Interns | * | 603 | Nursing Interns |
<COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 36px"><COL style="WIDTH: 194px"><COL style="WIDTH: 36px"><COL style="WIDTH: 143px"><COL style="WIDTH: 36px"><COL style="WIDTH: 116px"><COL style="WIDTH: 36px"><COL style="WIDTH: 116px"><COL style="WIDTH: 64px"><COL style="WIDTH: 83px"><COL style="WIDTH: 64px"></COLGROUP><TBODY>
</TBODY>
In this example, I only have four facilities, but in my original file there are a ton (30+). In J2, this is what I need a formula or macro to do: search the entire row (A2:H2). If a value is found, copy the value (wherever it's found), then paste it in J2 & K2.
In J3, it would would search A3:H4, it would find the a value in C2 & D2, so it would need to copy those values in J2 and K2.
I can't do a simple =IF(ISVALUE()) because of sheer size of my original spreadsheet - as stated earlier there are 30+ facilities (there is information past column AD).
Hope there is someone that can help me out! Thanks in advance.
~ Im2bz2p345