Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button to move rows to other tab
I've got a spreadsheet where I've created a button and when it's clicked it
will move the current row to the appropriate tab and insert it there instead of replacing it. It also deletes the old row. Now, for my question regarding this: My spreadsheet is divided up into 3 sections. For the sake of simplicity, I'll just call them Well Type 1, Well Type 2 and Well Type 3. They are laid out like this: WELL TYPE 1 INFORMATION Smith #1 County ST 1/13/05 Jones #2 County ST 1/14/05 WELL TYPE 2 INFORMATION Brown #3 County ST 1/16/05 WELL TYPE 3 INFORMATION Haynes #6 County ST 1/17/05 Currently, under the last row of information under each section, there is an add button that when clicked will add a new row (formatted as necessary with borders and background cell color) under the specified section. My workbook has 2 tabs, Western, and Tracking. Both of these tabs look exactly the same (just like shown above), the only difference is the data that exists in each section. My question is this: now that I've got it set up to move the rows and delete the old row, and it's working fine, how do I make excel move it to the right section? If they click on a cell that falls under Well Type 2, and hit the Move Row to Tracking Tab button, how can I make excel know to move it under the Well Type 2 section of the Tracking Tab? How can it look for a section title and know to insert it under that section? Also, if it inserts the row, will it keep the appropriate formatting??? I'm not all that great with vba, but am learning quickly. Any help is greatly appreciated! Stacie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Button to move from one chart to another | Charts and Charting in Excel | |||
Can a Button move when scrolling | Excel Discussion (Misc queries) | |||
Why do I have to hit the TAB Button a few times to move to next c. | Excel Discussion (Misc queries) | |||
Button to move row and delete old row | Excel Programming | |||
move the cursor to a button | Excel Programming |