Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate Cut & Paste Rows to different tab in Workbook
I have an excel workbook that has 2 tabs with almost identical spreadsheets
(one for a log of information, one for tracking data). The entire formatting of the spreadsheets is identical, the only difference is the data that is inside the spreadsheet. This spreadsheet deals with a product (natural gas) that our business group buys. What I need is a macro that will do the following: When we first hear about the availability of natural gas through a certain well, we log in the name of the well (all this is irrelevant, but I'm just trying to paint the scenario right) and all the data that pertains to it. If our group decides to buy this gas, they will enter a date in the column titled "Date of First Sales". At this point in time, they are manually cutting that row, and pasting it on the 2nd tab on the next available row, then going back and deleting the now empty row. I want to create a macro that will automatically cut this row, paste it on the next tab in the next available row, then delete the now empty row when the user enters a date in "Date of First Sales". I'd need to set it up where it will send it to the next tab when they actually leave that row, and then give them a pop up message alerting them that their data has been moved to the next tab, just so they dont wonder where it went. Here's the problem though... my spreadsheet looks something 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 This is the way both the first and second tabs are set up. The difference is that the first tab wont have the date. When the date is entered, it needs to move to the 2nd sheet. My problem I'm wondering about is how to make excel know that if a date is entered under the section titled "WELL TYPE 2 INFORMATION" then it knows to move it to "WELL TYPE 2 INFORMATION" on the other tab, and will know which available row to use. The same for WELL TYPE 1 INFORMATION and WELL TYPE 3 INFORMATION. Also, I need the row to keep the correct formatting (color, borders, etc). I do hope this makes sense and that someone can help me with it. Sorry for being so wordy about trying to explain it. Any help is greatly appreciated! Sincerly, Stacie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate copy / paste | Excel Discussion (Misc queries) | |||
automate copy and paste | Excel Discussion (Misc queries) | |||
Automate Cut & Paste | Setting up and Configuration of Excel | |||
Any (clever) way to automate ROW:COL in copy/paste??? | Excel Worksheet Functions | |||
Automate cut/paste functions - Help! | Excel Discussion (Misc queries) |