| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Compiling data
I have two worksheets that I need to combine. Sheet1 has usernames with
answer codes. Sheet2 has the same code and the answer. Many users on sheet1 have the same answer. How can automate this. I am thinking with Macros, but I have had trouble with using the find and replace in the macro. I want to try avoiding copying and replacing thousands of entries. Thanks for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling data from a particular location in similar workboooks | Excel Discussion (Misc queries) | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Linear Mode
