| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
"Copying" info between workbooks
Hi,
A B C D PRODUCT CODE SUPPLIER DESCRIPTION STOCK QUANTITY BD1245LK PK02 NOTEBOOKS 5 JL5589X SD01 COPY PAPER 8 Above is an example of my very basic STOCKSHEET, excel 2003. I have about 200 rows of information, all different suppliers. What I want to do is use column b to make up a new workbook according to supplier only, with the corresponding info in the row all being copyied across. Also, as I update, change and add new stock items to STOCKSHEET, I want the workbook containing the supplier info to update as well. Can anyone help? Thank you. -- Kind regards, Sarah |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
| Retrieving info from "child" to a "parent" document | Excel Discussion (Misc queries) | |||
| problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
