|re: "Does this help clarify what I'm looking to do?"|
Yes, to a certain extent, but there is still something confusing, at least to me.
You have clearly described the 2 tables that you currently have in Sheet 1 and Sheet 2, but then you said you "need to create a new row to make a table that looks like this in Sheet1 Workbook2"
I have a couple of questions...
1 - Does the table in Sheet1 Workbook2 already exist? Do you just need to add more rows to that table? If so, how would the VBA code know what rows already exist and what rows need to be added?
2 - In your first table I see a "2" under Room B/Walk In, yet I only see 1 row for Walk In in the Sheet1 Workbook2 table. Is this one of the situations where you need to add another row for the 2nd Walk In or are the 2 entries for Room B on Sheet1 Workbook2 what you want the end result to be?
In other words it's not clear to me if the Sheet1 Workbook2 table is a before or after picture.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.