2 parts to this question:
2 Workbooks
Copies Data from wb1 to wb2
make changes in wb2 and override this information in wb1 -- (This part I got)
This part seems confusioning and i thought a loop would be way to go, but not sure how to begin.
Data which is copied back is as follows in Column:
Cell 1: First Name
Cell 2: Lst Name
Cell 3: Address
Cell 4: City
Cell 5: xxx
Cell 6: Credit Card info
Cell 7: xxx
Cell 8: Nights
Cell 9: num of people
Cell 10: Num of Rooms
Cell 11: Rate
Cell 12: xxx and so on I have a total of 24 items being copied back
If nights = 2, copy First name to the right cell1.offset(0, 2), same with last name.
If nights = 3, copy First name to the right cell1.offset(0, 2),
and copy First name to the right cell1.offset (0, 4) same with last name.
If nights = 4, copy cell1.offset(0, 2) & cell1.offset(0, 4) and & cell1.offset (0, 6)
If the offset cells are not blank then provide some sort of message and resume to the next set of offset cells.
Part 2 is even more confusing to me:
Depending on Number of Rooms:
If there are 2 rooms I need to copy the information to another room which I will have to choose that cell manually which now will be my active cell, the rate, number of people, etc maybe different so I will have to modify that in wb2 and copy all that back to my active cell in wb1.
2 Workbooks
Copies Data from wb1 to wb2
make changes in wb2 and override this information in wb1 -- (This part I got)
This part seems confusioning and i thought a loop would be way to go, but not sure how to begin.
Data which is copied back is as follows in Column:
Cell 1: First Name
Cell 2: Lst Name
Cell 3: Address
Cell 4: City
Cell 5: xxx
Cell 6: Credit Card info
Cell 7: xxx
Cell 8: Nights
Cell 9: num of people
Cell 10: Num of Rooms
Cell 11: Rate
Cell 12: xxx and so on I have a total of 24 items being copied back
If nights = 2, copy First name to the right cell1.offset(0, 2), same with last name.
If nights = 3, copy First name to the right cell1.offset(0, 2),
and copy First name to the right cell1.offset (0, 4) same with last name.
If nights = 4, copy cell1.offset(0, 2) & cell1.offset(0, 4) and & cell1.offset (0, 6)
If the offset cells are not blank then provide some sort of message and resume to the next set of offset cells.
Part 2 is even more confusing to me:
Depending on Number of Rooms:
If there are 2 rooms I need to copy the information to another room which I will have to choose that cell manually which now will be my active cell, the rate, number of people, etc maybe different so I will have to modify that in wb2 and copy all that back to my active cell in wb1.
