Hi,
I have a set of data in a workbook named "Reports.xlsm". Please refer to the table below for details.
<tbody>
</tbody>
Now I want all these data to be pasted in a new workbook called "Count.xlsm" under the sheet name "Master Sheet". The above sheet is basically a template and we will be working on this sheet everyday after deleting the previous day's contents. So, for tracking the work we've done for a week, we need to consolidate the data mentioned above. Please refer to the table below for details of the master sheet.
<tbody>
</tbody>
This is how I want the master sheet to look. I was able to create a macro to copy paste the contents from the "Reports.xlsm" workbook to the next available blank row in the "Master sheet", but I don't know how to paste the Provider's name, Date and Device name for all the rows that have content in them in the master sheet (Please note that there is just one cell that contains the provider's name, date and device name in "Reports.xlsm" and I want these to be pasted for all the rows that contain content in the master sheet). It would be really helpful if you could help me with this. Thank you so much. It really means a lot!
I have a set of data in a workbook named "Reports.xlsm". Please refer to the table below for details.
| Provider | AAAA | |||||
| Date | 5/11/2016 | |||||
| Device 1 | ||||||
| S.No | Type | Content Name | Status | Notes | Tester | Link |
| 1 | abc | 123 | Pass | xyz | ||
| 2 | def | 456 | fail | xxx | ||
| 3 | ghi | 789 | Pass | yyy | ||
| 4 | jkl | 000 | Pass | zzz |
<tbody>
</tbody>
Now I want all these data to be pasted in a new workbook called "Count.xlsm" under the sheet name "Master Sheet". The above sheet is basically a template and we will be working on this sheet everyday after deleting the previous day's contents. So, for tracking the work we've done for a week, we need to consolidate the data mentioned above. Please refer to the table below for details of the master sheet.
| S.No | Type | Content Name | Status | Notes | Tester | Link | Provider's Name | Device Name | Date |
| 1 | abc | 123 | Pass | xyz | AAAA | Device 1 | 5/11/2016 | ||
| 2 | def | 456 | fail | xxx | AAAA | Device 1 | 5/11/2016 | ||
| 3 | ghi | 789 | Pass | yyy | AAAA | Device 1 | 5/11/2016 |
<tbody>
</tbody>
This is how I want the master sheet to look. I was able to create a macro to copy paste the contents from the "Reports.xlsm" workbook to the next available blank row in the "Master sheet", but I don't know how to paste the Provider's name, Date and Device name for all the rows that have content in them in the master sheet (Please note that there is just one cell that contains the provider's name, date and device name in "Reports.xlsm" and I want these to be pasted for all the rows that contain content in the master sheet). It would be really helpful if you could help me with this. Thank you so much. It really means a lot!
