Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW CAN I INSERT DATA BTW TWO WORKBOOK
Master!. i know this is hard to understand what I'm trying to do but I will
appreciate your taught and help to solve this. My humble pleasure to you all. I have a large two workbook (destination.xls and source.xls), that track training of employee. The source.xls is link to the database such a way that whenever i open, it pull Automatic update from the database. Manager has list of employee under him that have undergone the training and these names sometimes occur more than one time because they have two or more training. I am trying to set up way that after update pulled by source.xls from the database should Automatically copies to Destination.xls on a particular rows and also only pick one name at a time if they appear more than one time"maybe pick the first occured of each name" and cordinate the name by Manager. For example "SOURCE.XLS" A B C D A1 EMPLOYEE ID COURSE NAME MANAGER Kim Bell 002 Sales Training Brian Kim Bell 002 Safety Training Brian Lee Paul 003 Light Training Mark Lee Paul 003 Sales Training Mark. "DESTINATION.XLS" B C D B11 MANAGER EMPLOYEE ID BRIAN Kim Bell 002 MARK Lee Paul 003 I mean the names should appear on the destination.xls automatically according to thier MANAGER and each name should appear once on the destination.xls "sheet1" even if they appeared 10times in the source.xls. The COURSE NAME ROW is neccesary and it can be scrap out if it will prevent us to achieve what we want. Please your taught and help will be much more welcome and appreciate your time. Thank you and look forward to hear from you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW CAN I INSERT DATA BTW TWO WORKBOOK
I can think of some ways to pull student names from source to destination a)
by reference to manager name and b) getting just one instance of each student. I can even think of ways to do it using worksheet functions rather than via a VB macro. But the nature of a worksheet function is to go out and get data and display it in its own cell, whereas I think you're saying you want the source sheet to PUT THE DATA in the destination sheet. Worksheet functions can't do that. You can put functions in the destination workbook that will look up the data in the source workbook and display it as you want it; but they won't know to go get the data automatically whenever source.xls is updated, only when destination.xls is updated...and maybe when the user remembers to tell destination.xls to update its information. If you really want source.xls to be responsible for updating destination.xls, and if you know someone won't have destination.xls open when it happens, then you'll have to do it using a VB macro. That means a) you have to know something about programming, or be willing to learn, and b) you'll have to transfer this question to the other forum, Excel Programming. Feel free to ask me more questions, either here or by email. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert vba code to new workbook | Excel Worksheet Functions | |||
match and insert from one workbook to another | Excel Worksheet Functions | |||
workbook won't let me insert new worksheet | Excel Discussion (Misc queries) | |||
How can I have data auto insert into another pg in workbook? | Excel Worksheet Functions | |||
can't insert row in shared workbook | Excel Worksheet Functions |