Macro for transfer information

[Cris_93]

Hello Excel Masters

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

 

[Mentor82]

Hi,
I’ve got one question before I prepare a code for you. Where do you take the date from in merged cells G-N? Is it done by the function /formula (if so can you show the formula placed there?) or is it a string as seen in the screen?

 

[Cris_93]

Hi Mentor82,

The date is placed there by an user

Thank you,
Cristian

 

[Cris_93]

Basically an file like this is generated by week and the date that is allocated to that cell is the Monday that always depending on the week.

Thanks Mentor82,
Cristian

 

[Cris_93]

@Mentor82 was the information I provided to you sufficient? Thanks a mill mate!