TravelingMan
New Member
- Joined
- Jun 8, 2015
- Messages
- 8
I have 4 tabs of different #'s 201, 202, 203, 204
In a master tab I am dumping data...
I have a suite column that has suite #'s and dates
Each of the 4 suites and their dates are in this master data list.
I am trying to get a macro that will loop through column and insert each suite and its corresponding dates into its numbered tab
I.e.
201
Date
Date
Date
Date
202
Date
Date
Date
203
Date
Date
Date
Date
Date
204
Date
Date
This would be separated into each corresponding numbered tab and
Suite numbered would be duplicated while dates would be put in the date column
Basically moving the data from column one 1 master sheet to corresponding columns and separating dates and suite numbers
In a master tab I am dumping data...
I have a suite column that has suite #'s and dates
Each of the 4 suites and their dates are in this master data list.
I am trying to get a macro that will loop through column and insert each suite and its corresponding dates into its numbered tab
I.e.
201
Date
Date
Date
Date
202
Date
Date
Date
203
Date
Date
Date
Date
Date
204
Date
Date
This would be separated into each corresponding numbered tab and
Suite numbered would be duplicated while dates would be put in the date column
Basically moving the data from column one 1 master sheet to corresponding columns and separating dates and suite numbers