Cris_93
New Member
- Joined
- Nov 1, 2019
- Messages
- 22
- Office Version
- 2016
- Platform
- Windows
Hello Excel Masters :D
I need to develop a macro that transfers information from one file to another and I need your help please.
The file from which the information comes is the below one:
The information I need to transfer is from columns D (RTO021,RTO022,etc.), column O (28000, 2000,etc) and the date from the merged cells G to N (07/06/2020).
The macro should grab this information and place it into a final final with the below aspect:
Columns "Fact Type", "Unit", "Market" and "Date" should have always the same value and the ones containing "Product", and "Value" should change accordingly.
Could you please help me with this?
Thank you,
Cristian
I need to develop a macro that transfers information from one file to another and I need your help please.
The file from which the information comes is the below one:
The information I need to transfer is from columns D (RTO021,RTO022,etc.), column O (28000, 2000,etc) and the date from the merged cells G to N (07/06/2020).
The macro should grab this information and place it into a final final with the below aspect:
Product | FactType | Unit | Date | Value | Market |
RTO021 | RollingForecast | P | 07/06/2020 | 28000 | DEFAULT |
RTO022 | RollingForecast | P | 07/06/2020 | 2000 | DEFAULT |
RTO137 | RollingForecast | P | 07/06/2020 | 6200 | DEFAULT |
RTO051 | RollingForecast | P | 07/06/2020 | 0 | DEFAULT |
RTO053 | RollingForecast | P | 07/06/2020 | 475 | DEFAULT |
RTO026 | RollingForecast | P | 07/06/2020 | 0 | DEFAULT |
RTO028 | RollingForecast | P | 07/06/2020 | 1800 | DEFAULT |
RTO002 | RollingForecast | P | 07/06/2020 | 0 | DEFAULT |
RTO057 | RollingForecast | P | 07/06/2020 | 2200 | DEFAULT |
Columns "Fact Type", "Unit", "Market" and "Date" should have always the same value and the ones containing "Product", and "Value" should change accordingly.
Could you please help me with this?
Thank you,
Cristian