Information Transfer

[Cris_93]

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:

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

 

[jasonb75]

Reported as duplicate of Macro for transfer information

 

[Cris_93]

Thanks Jason I tried to remove the previous one but I could't.

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).