Select, Copy, Paste one by one till last data to new format

vasandgl

New Member
Joined
Nov 1, 2019
Messages
1
Hi Excel Experts,
Myself Srini, new to this forum. I need your help to provide a macro code for the below
Input & Output file image links are as below

Input File Image-->https://ibb.co/xLQ6dLD
Output File Image--> https://ibb.co/f0VMv9c
f0VMv9c
f0VMv9c


In Input, Rows & Columns can be n numbers.
Need to filter datewise excluding blanks from input and copy Row Lables values, Date & Qty and paste in the Output Format from Cell A3
For the dates it need to convert from traditional date format to as below.
10-Oct-2019 --> 101019
05-Oct-2019--> '051019
For a single part number, multiple dates & Qty available means it need to enter in the Date 2 & Qty 2 for the 2nd Data, if 3rd & 4th Date & Qty available for same part means need to enter in Comments 1 & Comments 2 in simple way like 20OCT-10 (ie.,DDMMM-Qty).
If more than 4 Date & Qty available means put in some error file & store.
From Input Date as TBA & Qty as 0 -->put in some error file & store.

It will be really helpful if anyone can help me.

Thanks,
Srini.
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Forum statistics

Threads
1,213,558
Messages
6,114,296
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top