jevi
Active Member
- Joined
- Apr 13, 2010
- Messages
- 339
- Office Version
- 2016
- Platform
- Windows
Hi All,
1. I have a big database and I need to copy from this huge database from column A to BZ, the rows differ everyday so now is 133.458. From this file "Database.xlsx", sheet will have an incremente number every day but is the first sheet always, I need to copy in another file "Working File.xlsx" sheet "Dati" the columns D, E, F,G and AM and the criteria is: exclude the value "0" (the column AM is with values and I need to exlude the "0").
2. Then when the data is copied to the "Working File.xlsx" sheet "Dati", I need to remove dublicates based on Column E,F,G,AM (which in the new file and sheet the columns will be A:E.
Then to make it perfect don't know if it is possibile with VBA (but important for me is 1 & 2):
- count the names that are in column D and the amount that is in the column E and give the result in a new sheet but same "Working File.xlsx" in cell B5;B6
- give the information from column A:E but for only the 10th clients with the highest value (that in is column E or old AM).
I try to record it but is not working as too many values when I uncheck the 0.
I hope I was clear but please let me know if you need more explanation
Thank you,
1. I have a big database and I need to copy from this huge database from column A to BZ, the rows differ everyday so now is 133.458. From this file "Database.xlsx", sheet will have an incremente number every day but is the first sheet always, I need to copy in another file "Working File.xlsx" sheet "Dati" the columns D, E, F,G and AM and the criteria is: exclude the value "0" (the column AM is with values and I need to exlude the "0").
2. Then when the data is copied to the "Working File.xlsx" sheet "Dati", I need to remove dublicates based on Column E,F,G,AM (which in the new file and sheet the columns will be A:E.
Then to make it perfect don't know if it is possibile with VBA (but important for me is 1 & 2):
- count the names that are in column D and the amount that is in the column E and give the result in a new sheet but same "Working File.xlsx" in cell B5;B6
- give the information from column A:E but for only the 10th clients with the highest value (that in is column E or old AM).
I try to record it but is not working as too many values when I uncheck the 0.
I hope I was clear but please let me know if you need more explanation
Thank you,