Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Cell value from one worksheet to another, then delete.
I know I've asked alot already, and I really am greatful for all the
help. I'd like to promise This is the last time, but I can't... this is a big project for me and being a newbe to this vba and excel for that matter I'll most likely be bothering you guys again....Sorry :) But I am learning........... "LOOK BOB I ONLY POSTED IN THE PROGRAMMING GROUP :D" Thanks again for all the help you have all given me so far and yet to come :) Here's my new problem I have a user form with two combo boxes. Combo box 1 reads EmpData!A1:A100 Combo Box 2 reads EmpData!B1:B100 Then a Cmd Button I have two work sheets one with data and one with a blank form to be printed. I need to be able to pick either a empolyee Number (Combo box 1) or a Employee Name (Combo Box 2) And then click on the Command button and have the Excel find the matching row and then copy the cells from the row in the Empdata worksheet the Proper cell in the EmpPrt worksheet. ie. Combo Box 1 = 4500 find the cell between A1 and A100 that matches 4500 ( Say A49) Then copy EmpData!A49 to EmpPrt!D10 Then EmpData!b49 to EmpPrt!k5 Then EmpData!c49 to EmpPrt!A25 ect........ Then Print the Page and return it to a Blank Form. I tried using a marco, but it's long and the command button doesn't always run it... :( Thanks for the help Wally. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell value and delete white spaces at the end? | Excel Discussion (Misc queries) | |||
Cannot Move, Copy, Insert, Rename, or Delete a Worksheet in Any Wo | Excel Discussion (Misc queries) | |||
checkbox to copy and delete content of a cell | Excel Discussion (Misc queries) | |||
copy paste delete cell contents | Excel Discussion (Misc queries) | |||
macro to copy and edit then delete a worksheet | Excel Discussion (Misc queries) |