PDA

View Full Version : VBA code to copy data from one sheet and paste it in a specific location



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?

Nathan69
03-31-2019, 05:31 PM
please see this link to download, thanks for the help!
https://www.dropbox.com/s/vxpd1hew9r5tom6/macro%201.xlsm?dl=0

大灰狼1976
03-31-2019, 08:52 PM
Hi Nathan69!
Welcome to vbax forum.
I can't open this link. Can you post the attachment here?




--Okami

Nathan69
04-01-2019, 03:44 AM
I can’t post here b/c my file is 1.92 mb. It’s over the

大灰狼1976
04-01-2019, 10:50 PM
I can't judge if it can be solved without attachments. You can delete some content and post it.

Aussiebear
04-04-2019, 02:38 PM
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.