VBA code to copy data from one sheet and paste it in a specific location

[Nathan69]

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?

[Nathan69]

please see this link to download, thanks for the help!
https://www.dropbox.com/s/vxpd1hew9r...%201.xlsm?dl=0

[大灰狼1976]

Hi Nathan69!
Welcome to vbax forum.
I can't open this link. Can you post the attachment here?




--Okami

[Nathan69]

I can’t post here b/c my file is 1.92 mb. It’s over the

[大灰狼1976]

I can't judge if it can be solved without attachments. You can delete some content and post it.

[Aussiebear]

Just make up a sample workbook with the correct sheetname then indicate which column triggers the event (H,i,J,k or L) and show where you would like the data to be copied to.