VBA to Export column data from open workbook to next available column of closed workbook?

Hello again Gurus,

I am looking for a bit of VBA code to export data with a button trigger only from an open worksheet tab named JOB COSTING of a workbook, column (E13 thru row E2164 only) to the next available column of a closed workbook named INVENTORY.xlsm worksheet tab name CARROLL, starting with column (AA13 thru row AA2164). I am also looking for the code to add a column header of the info in cell D:3 of the active open worksheet tab named JOB COSTING to the closed workbook tab named INVENTORY.xlsm cell AA:12 or what ever the next available column will be.

I have multiple tabs in the INVENTORY workbook that will add together on the TOTAL INVENTORY worksheet tab, so I will have to tweak the vba code depending on what JOB COST workbook I have open will determine what tab name on the INVENTORY workbook the new columns will add to each time.

Thanks for any and all suggestions or help in advance.

Do you really mean a closed Workbook or would just not active suffice? To modify a closed Workbook, we'd need to use outdated code. But to modify an open workbook we could use regular contemporary VBA.

BTW can you post sample workbooks?

Open, Post, Close that's most viable - will we be posting to established records or making new lines??

Hi Nick's Dad,

You'll need to tweak this - the stickiest point is probably the path of the "closed" book.

Please Login or Register  to view this content.

You're welcome! Let me know if you ever get stuck again

Hi xladept,

Sorry to bother you and starting this Thread up again, but you did say if i got stuck on this to let you know, well I did get stuck again.
I tried to make a few changes in the code to match changes I made in the two workbooks.
the copy works but with a #REF! in the new copied cells and the next time the code is rune it stops with a TYPE MISMATCH error.

I have spent hours trying to fix what I am sure is a simple fix

here is the new code.

Please Login or Register  to view this content.

I do not know why the code works when I change the to be copied cells to other cells in the workbook, but the cells I want to copy gives #REF!

Thanks, NicksDad.

I have attached a copy of the page that sends the code to the INVENTORY workbook, this site would not let me upload a copy of INVENTORY workbooks to large.

I've been looking at your new code and I've been trying it. See if it works (take precautions):

Please Login or Register  to view this content.

Originally Posted by xladept

I've been looking at your new code and I've been trying it. See if it works (take precautions):

Please Login or Register  to view this content.

when I run the new code you gave me I get a TYPE MISMATCH error.

I have tried it a few ways and still get #REF! error in the copied cells of the INVENTORY workbook.
when I use this part of the old code.

Please Login or Register  to view this content.

Attached is what the file looks like when done.
Thanks.

Hi NicksDad,

I'm stuck without that inventory - so, if you will, you can email it to me: [email protected]