| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mass update in Excel based on values in different sheets
Hi,
I have a problem. I have 2 sheets in a spreadsheet, "sheet1" and "sheet2", in sheet 1 i have 2 columns A and B, in Sheet2 i have also 2 columns A and B. Sheet1.column A is a customer number. Sheet2.column A is also a customer number. Sheet1column b is empty. I need to fill this empty column with sheet2.column B, when each cell in sheet 1 and 2 column A are equal. What is the best way to do this with VB or directly in Excel. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create New Sheets and Name Them Based on Values in another sheet | Excel Discussion (Misc queries) | |||
| Mass Changing whole sheets individual cell references | Excel Discussion (Misc queries) | |||
| Mass Update! (Excel 97) | Excel Discussion (Misc queries) | |||
| How do I mass update formulas? | Excel Discussion (Misc queries) | |||
| 2 files, mass update comments between files | Excel Worksheet Functions | |||
Threaded Mode
