Nathan69
03-31-2019, 05:23 PM
hey guys i have a question,
i am needing some help, i am needing to create a VBA code to copy specific row and columns but i need it to copy the items that are over 5,000 dollars and i need it to paste in a specific location. Is there any help you guys can provide?
So for instance i have the maint and contract broken down by area 1,2,3,4 general plant and environmental and the cost center (on sheet 1 column I) it tells me where on the sheet I put the description Ie 6901 is general plant, so i manually copy and paste into general plant row.
And i also put the respective PO number, vendor name and expense allocation code all on the Maint-contract summary sheet.
Is there a VBA code i can use to help automate this?
i am needing some help, i am needing to create a VBA code to copy specific row and columns but i need it to copy the items that are over 5,000 dollars and i need it to paste in a specific location. Is there any help you guys can provide?
So for instance i have the maint and contract broken down by area 1,2,3,4 general plant and environmental and the cost center (on sheet 1 column I) it tells me where on the sheet I put the description Ie 6901 is general plant, so i manually copy and paste into general plant row.
And i also put the respective PO number, vendor name and expense allocation code all on the Maint-contract summary sheet.
Is there a VBA code i can use to help automate this?