| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search & insert
Hi
I'm new to programming in Excel and have some problems. I have an excel sheet in workbook1 where in cell A1 I have a name eg. Jhon Jonsson. In cell c4 I have an estimated workload eg. 75% and in cell C5 real workload eg. 100%. In cell F2 I have a week number eg. 50. I want excel to search for the name in coloumn A range 16 to 35 in another excel workbook2. After that is has to find the week number in row 15. If it finds a match it should input the estimated workload from workbook1 into the corrisponding field in workbook2 and the real workload in the corrisponding field. The layout of workbook2 is like this: Est. Workload Actual workload Est. Workload Actual workload Week 1 2 John Johnson name2 name3 etc. Could you help? Br Ticotion |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA to Search, Insert Column and Sum | Excel Programming | |||
| Search and Replace end of Line and Insert Alt-Enter | Excel Discussion (Misc queries) | |||
| search for worksheet, insert new if doesn't exist | Excel Programming | |||
| Cell Text Search & Insert Value in Next Column | Excel Programming | |||
|
Search & Replace to insert alt+ |
Excel Discussion (Misc queries) | |||
Threaded Mode
