easy copy n paste of long list

iffi

Board Regular
Joined
Jun 5, 2011
Messages
59
Office Version
  1. 2019
Platform
  1. Windows
Hi guys

http://imageshack.us/photo/my-images/268/47328074.jpg/

http://imageshack.us/photo/my-images/96/84194073.jpg/

i have pasted two links of pictures of excel, please have a look at them so u can understand my problem easily.

in the first image of month MAY, u can see 3 columns, invoice #, party name and address, i have created a data validation of list for party name, there wil be nearly 200 different parties and have put vlookup formulae in address so whatever party i select, it will pick the right address for that party and number of invoices change from month to month for different parties
and now u can the 2nd picture of June in which u can see same party but in this month there r 5 invoices from the same party, i was creating new sheet for the new month of june but the problem is that, i m copying all the address of different parties and pasting them in new sheet of JUNE i m just tired of doing it and also in june month as i said number of invoices changing so i need to copy and paste address for all those number of invoices for the same and i have to do this for all the parties

so please kindly tell me any easy way of doing this so that i can immediately do this. Thank u very very much
47328074.jpg
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
plz no one is there solve my problem, expert plz help
 
Upvote 0
Excel Workbook
ABCDE
1MAY
2
3Invoice #Party NameAddress
4125juzia pvt.ltdA-58, pce street, musa Road
5
6
Sheet1


Excel Workbook
ABCDE
25JUNE
26
27Invoice #Party NameAddress
28151ashfaq hussain pvt.ltd
29152
30153
31154
32155
33
Sheet1
 
Upvote 0
As u said i did that and posted my data, plz read my first post for the expected results i want, Thanks, awaiting for ur kind reply
 
Upvote 0

Forum statistics

Threads
1,224,521
Messages
6,179,291
Members
452,902
Latest member
Knuddeluff

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