Copying Rows from Multiple Tables into One

**vlbridge** · 05-03-2011, 11:48 AM

Good morning!

I am new to this forum. I have been searching all morning for a solution to my problem, but have been unsuccessful. It may just be because I am not very familiar with VBA and Macros and I am not sure how to even begin.

I have an Excel File that is used to capture all of the maintenance issues that occur on our boats. I have a separate sheet for each boat. Column A in the sheets will state whether the issue is still "Open" or if it has been "Closed". Different people work on these different boats so I need the information separated by boat for the Engineers to keep track of their boats. (They are NOT computer savvy at all so I am trying to make this as user friendly as possible.) Every Monday, the department needs to go over these issues, so it would not be efficient to click through every tab. I would like to have two other sheets, one for "Open Issues" and one for "Closed Issues" that will automatically populate based on the information typed into the Boat tabs. Can anyone help me with this? I would greatly appreciate it. Thanks so much!

Have a great day!
Veronica

**watersev** · 05-03-2011, 12:30 PM

hi, Veronica, can you post sample workbook showing original data and the result you need to obtain

**vlbridge** · 05-03-2011, 01:06 PM

I have attached the file, but there is no data in it. I just created it this morning. You can see how it's laid out though. So if let's say "Mike Savoy" was on call for the weekend and the "Ave Maria" had a problem, he would go in and enter the information from the weekend onto the Ave Maria sheet. At this point, the issue would be considered "Open". So, this row should appear in the sheet called "Open Issues." When management is reviewing the open issues they just have to look at this one sheet. Well, the Ave Maria is "Ricky Mayon"'s boat. So, if he goes into the sheet for the Ave Maria he will see what issues need to be looked at. Once he takes action and resolves the issue, he will change the status to "Closed". The "Date Closed" field will automatically populate. Now, the row should be moved from the "Open Issues" tab to the "Closed Issues" tab. Let me know if you need more info. Thanks for your time!

**watersev** · 05-03-2011, 04:42 PM

please check attachment, activate sheet "Open issues" and "Closed issues"

**vlbridge** · 05-03-2011, 05:16 PM

Wow, that's perfect! Thank you!! I just wish I understood it a little better. Haha.. I guess I'll need to learn VBA. So, what is the proper etiquette to thank someone here? I know in other forums, a member's status is determined by other people's comments or ratings, etc. Let me know! Again, thank you. You are fantastic!