Copy paste data multiple times or use some sort of formulla

[Raviprmr]

HI,
I am try to copy paste data multiple time using some paste special or formulla. It would be great if it can be done using formulla, as and when new entries come.

The above part shows the data and the below is the output I am trying to draw without doing it manually. In future if I am adding anything below HIJ in column A it should be capture in the next 4 rows of column B as shown in output along with qty data mentioned in column B,C,D,E and respective date in column D of output. Any help would be greatly appreciated

 

[udprocks]

HI,
I am try to copy paste data multiple time using some paste special or formulla. It would be great if it can be done using formulla, as and when new entries come.

The above part shows the data and the below is the output I am trying to draw without doing it manually. In future if I am adding anything below HIJ in column A it should be capture in the next 4 rows of column B as shown in output along with qty data mentioned in column B,C,D,E and respective date in column D of output. Any help would be greatly appreciated

View attachment 14180

Hi ravi,

Welcome to the forum,

Not sure what you looking for.. can you please define it more clear about your result...

 

[Xen]

Hello, se this file

 

[Raviprmr]

Hi ravi,

Welcome to the forum,

Not sure what you looking for.. can you please define it more clear about your result...

Sure, To a larger extent Xen solution has worked.

What I am trying to do is the tabular form of the data representation, I am trying to convert vertically. So for the same name, I would like to have it one below the other

 

[udprocks]

Sure

just see your file mate above, XEN had done it,

i think you are looking for that..

 

[Xen]

Sure, To a larger extent Xen solution has worked.

What I am trying to do is the tabular form of the data representation, I am trying to convert vertically. So for the same name, I would like to have it one below the other

Can you clarify, what it 'to larger extent'? Is there any problem?
If you want one below other, just drag table with your mouse to desired location

 

[Raviprmr]

Can you clarify, what it 'to larger extent'? Is there any problem?
If you want one below other, just drag table with your mouse to desired location

Thanks for your kind help. I am sharing with you the actual format that I am trying to work on.

Can you help me on this?

 

[Xen]

Thanks for your kind help. I am sharing with you the actual format that I am trying to work on.

Can you help me on this?

Here you go

 

[Raviprmr]

Here you go

This is perfectly fine but I am not able to show the reference in Sheet 1, can you create the reference in sheet 1 in the column marked in Yellow. the three data points Material, Qty and Del date.... Thank you so much

 

[Xen]

Well, I just put links in there...

 

[Raviprmr]

Well, I just put links in there...

Thank you very much...... Xen.....
Not only for your efforts, but also for the quick response and the time taken by you to reply me in such a quick succession.

Kudos to you. And also Belated Merry Christmas and prosperous new year.....
Cheers