Create macro to copy data from rawdata file b

Closed
nirmala_kr Posts 2 Registration date Saturday April 3, 2010 Status Member Last seen April 3, 2010 - Apr 3, 2010 at 07:41 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 4, 2010 at 11:49 AM
Hi experts...
Need a help from you to create an macro to copy the data from rawdata file by condition and paste it into another summary excell file.
My requirement is as under...
I have raw data file in which i have to filter for particular business group column by 3 different criteria like "GLOBAL OPS" then filter Region by "Asia" then filter by suppler name "aaaa","bbbb", "cccc" and then get the total USD value for this.. and then paste that into the summary file which has in one column soruced, vertical integration and in row i have 5 tabs under which i have to compare and paste the data from the raw data

itme supplir name spen(USD) source control region businessgroup
1 aaaa xxx CPCR america global ops
2 bbbb xxx CPCS europe infra
3 ccc xxx BMSD asia medical


AND THIS IS MY SUMMARY template FILE and need to copy that filteredd data from raw data and compare then paste it to this summary template under the respective subtotal, cpcr cpcs value fiel..

9 10
descriptopm Sub-Total % Not maintained CPCR CPCS BSCM BMDC EOL Wrong Category Can't Make VI has no capacity or price not competitive Category Changed Others
Outsourced(excluding of VI) $1,224,444 18.3% $0 $56 $99,999 $0 $0 $0 $0 $0 $0 $0 $0
VI $544,444 8.2% $0 $677 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total $6,677,777 100.0% $0 $888,888 $99,999 $0 $0 $0 $0 $0 $0 $0 $0
% 0.0% 19.1% 80.9% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%



It will be your great help if this macro done... i was doing this manually for one template, but i have more than 196 files to do the same by commodity wise..
please help

thanks a lot in advance

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Apr 4, 2010 at 11:49 AM
Could you post a sample file for raw data and how you would like the result to appear. You can post on some share site like https://authentification.site
0