| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In a excel/VB macro I am trying compare cells in different workshe
I have two worksheets in a excel workbook. I am trying to write a macro,
using an IF statement, comparing one cell in one sheet to a cell in the other worksheet to determine what to do next? If they are equal, I want to copy some data and paste in in the other sheet. If they do not, go to the next cell and repeat test until all are satisfied. Basicall one sheet is a data input screen by individuals names. I would like to enter data, find that individual on the other sheet (a composite of all data) and paste the data. Does this make sense? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a cell's value to copy another cells info to another workshe | Excel Worksheet Functions | |||
| Updating linked cells within a workbook, from worksheet to workshe | Excel Discussion (Misc queries) | |||
| Create a template, on close, save those cells into another workshe | Excel Worksheet Functions | |||
| How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
| macro to compare multiple cells to determine value | Excel Worksheet Functions | |||
Threaded Mode
