Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Coding Help
Hi Everyone:
I need some help with VBA coding: Here is what I need: Search all sheets in Workbook1 in Column B. Cell A1 in "TEST SHEET" is "XXX" If Column B of All Sheets doesn't have "XXX" in it, Then copy Cell A1 of those sheets to Column A of TEST SHEET, starting with Row 2. I tried using the "<" but it doesn't do what I want it to do. It copies Everything else when i doesn't match, but I need is if "XXX" Not EXIST, just copy Cell A1 of that sheet to TEST SHEET. Hope I explain myself well. Thanks in advance. Neon520 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to fix the coding? | Excel Worksheet Functions | |||
Coding | Excel Programming | |||
"=ROW()-1" type of coding doesn't appear in a filter / is there coding that does? | Excel Programming | |||
Implant macro coding into ASP coding | Excel Programming | |||
Could someone help me with some coding | Excel Programming |