| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering data on differnent sheets in WB
Does anyone have any suggestions for: I have a spreadsheet with approximately 100 rows of data, however thi varies each week. Column E is various account numbers WITH DUPLICATES I would like: A Macro that would look at column E on workbook 1 and ener enter th value on workbook 2- cell A1. Each account number in column E workbbo 1 would be input on a different sheet on workbook two without enterin duplicates. Any help would be greatly appreciated -- STEVE ----------------------------------------------------------------------- STEVEB's Profile: http://www.excelforum.com/member.php...nfo&userid=187 View this thread: http://www.excelforum.com/showthread.php?threadid=46830 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Entering data on differnent sheets in WB
excel 2003
Help Advanced Filter - Unique records "STEVEB" wrote: Does anyone have any suggestions for: I have a spreadsheet with approximately 100 rows of data, however this varies each week. Column E is various account numbers WITH DUPLICATES. I would like: A Macro that would look at column E on workbook 1 and ener enter the value on workbook 2- cell A1. Each account number in column E workbbok 1 would be input on a different sheet on workbook two without entering duplicates. Any help would be greatly appreciated! -- STEVEB ------------------------------------------------------------------------ STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872 View this thread: http://www.excelforum.com/showthread...hreadid=468306 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying workbook formating to a differnent workbook | Excel Worksheet Functions | |||
| transfering data in another column entering more sorted data | Excel Worksheet Functions | |||
| entering same formula in multiple sheets | Excel Worksheet Functions | |||
| Entering data on template and then data going to a spreadsheet. | Excel Discussion (Misc queries) | |||
| Excel password but cant hide the sheets before entering password | Excel Programming | |||
Hybrid Mode
