Hi, I have VERY LITTLE knowledge in VBA. However, I need to complete this task, and it must be done in VBA.
I have attached the data below. What I am trying to accomplish is hard to explain if you do not have the data in front of you.
DATA: View attachment Data.xlsx
What I am trying to do is this:
I want to align all the "Amount and Kind of Material Used" cells into the same column. 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 cells 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.
I have attached the data below. What I am trying to accomplish is hard to explain if you do not have the data in front of you.
DATA: View attachment Data.xlsx
What I am trying to do is this:
I want to align all the "Amount and Kind of Material Used" cells into the same column. 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 cells 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.