ElBillions
New Member
- Joined
- Feb 15, 2021
- Messages
- 6
- Office Version
- 2007
- Platform
- Windows
Hello great minds, I need your assistance.
I'm a cost Control Engineer and I stumbled on this awesome site while searching for assistance online.
I'm working with a workbook that has many worksheets with different names. Each is named according to the equipment that has the information in it.
However, each worksheet has the same kind of table in it. Table headings are equipment tag, Jr number, manpower, duration etc.
I'm new with VBA's and haven't been able to write a code but I need a VBA to copy information from cell B2, C2, D2, E2, F2, I18, L2 and S18 from each worksheet and paste them in cells B2, C2, D2, E2, F2, G2, H2 I2 of a particular worksheet called TRACKER in the same workbook.
The copied info should be pasted such that data from each worksheet takes a row and the next worksheet takes the next blank row etc.
Since I create new worksheets daily, I will like the VBA to update TRACKER worksheet daily.
Kindly assist with this as it would really make my work easier.
Thanks.
I'm a cost Control Engineer and I stumbled on this awesome site while searching for assistance online.
I'm working with a workbook that has many worksheets with different names. Each is named according to the equipment that has the information in it.
However, each worksheet has the same kind of table in it. Table headings are equipment tag, Jr number, manpower, duration etc.
I'm new with VBA's and haven't been able to write a code but I need a VBA to copy information from cell B2, C2, D2, E2, F2, I18, L2 and S18 from each worksheet and paste them in cells B2, C2, D2, E2, F2, G2, H2 I2 of a particular worksheet called TRACKER in the same workbook.
The copied info should be pasted such that data from each worksheet takes a row and the next worksheet takes the next blank row etc.
Since I create new worksheets daily, I will like the VBA to update TRACKER worksheet daily.
Kindly assist with this as it would really make my work easier.
Thanks.