PDA

View Full Version : Shifting and combining columns using VBA



texas979
08-12-2013, 09:51 PM
Hi, I have VERY LITTLE knowledge in VBA. However, I need to complete this task, and it must be done in VBA.

Here is a link to a small sample of the data I am looking at. Please click the DOWNLOAD arrow (next to the printer icon). I believe you must log into your Google Account to download. What I am trying to accomplish is hard to explain if you do not have the data in front of you.

LINK: https://docs.google.com/file/d/0B19IVJ5jMd6LYmp4U1JPS192QjQ
ALSO: 10428

What I am trying to do is this:

I want to align all the "Amount and Kind of Material Used" cells. In this small data, the LAST column with "Amount and Kind of Material Used" is column R. So ideally, I want all the other "Amount and kind of material used" to shift over to column r as well. Keep in mind that this should move all other columns after "Amount and Kind of Material Used" as well.

Once this is completed, I want to COMBINE ALL CELLS after the "Amount and Kind of Material Used" column into one cell with an underscore in between.

can someone PLEASE help me with this?

or help me START the code. I'm on Google reading VBA for dummies and it really isn't helping.

Thanks.

Bob Phillips
08-12-2013, 11:46 PM
Cross-posted at XGuru http://www.excelguru.ca/forums/showthread.php?2015-Shifting-and-combining-columns-using-VBA

Aussiebear
08-13-2013, 12:02 AM
I believe you must log into your Google Account to download.

To upload files here, click on Go Advanced, scroll down to Manage Attachments and follow the prompts from there. Much better this way than have us download from other sources.