Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional inserting content in new rows in other file/sheets
This is the very first time I will be using actual coding for VB instead of just recording it, so bare with me please. So what's the problem? Basically, there is a main excel file (book) containing the cell with dropdownlist and there are plenty (12) other excel files where conten needs to go to in new rows. What is selected in the dropdownlist refer to the file/book where the new row and its content should go into. Th content is currently placed in the columns after the dropdownlist i the same row. Lets say the dropdownlist contains the names (Steven, Manu and frank) Those names have also their own excel files called steven, manu an frank. Its the content that follows after the cell (in the followin columns) which needs to be inserted in to the other books specified b the dropdownlist. Perhaps for your ease, the cell is located in let' say C3 and content of D3, E3, F3, ... needs to be copied and paste into a new row in an existing sheet in another file called frank steven, ... depending on what you choose in the dropdownlist. I might have said three times the same, but as other forums haven' been able to help me so far ... Kind regards, Christopher Wilkinso -- cjwilkinso ----------------------------------------------------------------------- cjwilkinson's Profile: http://www.excelforum.com/member.php...fo&userid=3781 View this thread: http://www.excelforum.com/showthread.php?threadid=57372 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Inserting Rows | Excel Worksheet Functions | |||
inserting deleting rows?how do i get the other sheets to do the sa | Excel Discussion (Misc queries) | |||
Help on inserting rows and formatted content | Excel Programming | |||
inserting conditional rows | Excel Programming | |||
Updating, Deleting and inserting rows over two Excel Sheets | Excel Worksheet Functions |