Microsoft Office

Microsoft Office Questions? Ask a IT Expert for Support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Microsoft Office

I need someone to create a VBA macro in excel to merge the

Customer Question
following: Cell A6: Cell A7, Cell...
I need someone to create a VBA macro in excel to merge the following:
Cell A6: Cell A7, Cell B6: Cell B7, Cell C6: Cell C7, etc....
I need to maintain the formatting of the bold headings in row 6. I need to add the colon, comma and space. The heading row 6 is fixed but there are several sheets within the workbook. Each has several rows that need to be combined with the fixed headings in the column.
Submitted: 2 years ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 5 minutes by:
5/8/2015
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,048
Experience: 20 years experience providing remote computer support
Verified
Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question

can you provide an example sheet
Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago

Attachment: 2015-05-08_202626_fac85_new_items_template_-_md_stetson_5-8-15.xlsx

Hi, You actually did this last time for us. But, this time it is a little different and does not work. Also, I'm not sure they have not done something with the format.

Thanks.

Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
lemme take a look, ill let u know if i have any questions
Ask Your Own Microsoft Office Question
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
is it possible you sent the wrong sheet, because I am really not following what you want
Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago

Yes. It is the right one. The 'T' column is in the 'New Catalog Items'. Here is the code you wrote previously for another spreadsheet. I just don't know enough about VB to get it to work with the new spreadsheet.

Sub populate()

Dim wks As Worksheet
Dim array1(), array2()

Dim cval As String
Dim i, j, lr, a, strt, eend As Long

Set wks = Worksheets("LI")

lr = wks.Cells(Rows.Count, "A").End(xlUp).Row
a = 0
For Each rcell In wks.Range("A1:O1")
ReDim Preserve array1(a)
array1(a) = rcell.Value
a = a + 1
Next rcell

If a > 0 Then
Erase array2()
For i = 2 To lr
a = 0
cval = ""
For Each rcell In wks.Range("A" & i & ":O" & i)
ReDim Preserve array2(a)
array2(a) = rcell.Value
a = a + 1
Next rcell
If a > 0 Then
For j = LBound(array1) To UBound(array1)
cval = cval & array1(j) & ": " & array2(j) & ", "
Next j
End If
cval = Left(cval, Len(cval) - 2)
wks.Range("T" & i).Value = cval
wks.Range("T" & i).Font.FontStyle = "Normal"
eend = 0
For j = LBound(array1) To UBound(array1)
strt = InStr(eend + 1, cval, array1(j))
eend = InStr(strt, cval, ":")
With wks.Range("T" & i).Characters(Start:=strt, Length:=eend - strt).Font
.FontStyle = "Bold"
End With
Next j
Next i

Else
Exit Sub
End If

End Sub

Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
but i dont understand what you want to do with this one
Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago

The old VB code does not work with this spreadsheet. It has been changed by our customer. When executed the old macro does not result in the desired contents of column T. The desired content of column T throughout the spreadsheet is the sum of all columns for each row using column heading: column row content, column heading: column row content, etc. A-O columns populating in column T.:

Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago

let me try to see what is going on

if there is any chance to send a few rows example of the desired output, that would be helpful.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
https://www.sendspace.com/file/7oiqwr

let me know if this works for you
Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago

The populate2 macro has the same results as populate macro. It does not process all the way through and crashed excel. I'm thinking it has something to do with the workbook itself. Can you try to create another a) workbook as a result of running the macro or b) the result on a different sheet. That may be cleaner, but I don't really know how to modify the macro.

Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
how many rows are there?

if there are a lot of rows it may appear to crash.

I can modify the macro.
Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago

Currently there are 6,670 rows.

Thanks.

Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
how shal i modify the macro, do you want the macro to create a new workbook each time it runs?
Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago

If that is the best option. We can cut and paste the result into column T.

Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
i dont think going out to another workbook is going to solve the problem

here is the latest version I seams to time out after about row 150 or so, but it is still running just takes time.

I limited it to 1000 rows for now so you can see that it runs.

https://www.sendspace.com/file/sr1k8m

let me know if you still have problems running it with the limited 1000 rows
Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago

Still doesn't work. I get only Product Category in T. Nothing else.

Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
did you try double clicking in one of the cells, the data is there, the cell just may not be big enough to display it all
Ask Your Own Microsoft Office Question
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
did you have a chance to try to double click one of the cells to see it fhe data is there.

Let me know if this resolves the problem so I can set it to go thtough all the rows
Ask Your Own Microsoft Office Question
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
hey there its been about a week since we last spoke. I am just trying to follow up to see if you need me further on this issue?
Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago

Hi,

That did not work either. It may have been something to do with the cell and the length. I copied out 1000 rows at a time and performed the macro. Not fun, but it worked. Thatnks for the efforts.

Andrea

Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
im goint to try something else Im going to try to make it auto adjust the cell size.
Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago

That would be great for our future issues with this spreadsheet.

Thanks.

Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
ok, please rate so im reimbursed. I will make the changes in the next day or so
Ask Your Own Microsoft Office Question
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,048
2,048 Satisfied Customers
Experience: 20 years experience providing remote computer support

The-PC-Guy is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

694 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

2,048 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

IT Miro

IT Miro

Computer Scientist

157 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

146 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
How can recover my 25 digits key for my Office 365 pro plus
Hi, how can recover my 25 digits key for my Office 365 pro plus 365 … read more
Chris Lindsey
Chris Lindsey
IT University
151 satisfied customers
Side-by-side error coming up and the sxstrace error. I cant
side-by-side error coming up and the sxstrace error. I cant run avast antivirus or microsoft office 7?? … read more
Cody
Cody
Computer Science
1,543 satisfied customers
I just purchased a new computer and had Microsoft Office
I just purchased a new computer and had Microsoft Office personal 365 installed. When I try to access files transferred from old computer it says office not activated and prompts me to sign in. Each t… read more
Kamil Anwar
Kamil Anwar
IT Consultant / Systems Engineer
Bachelor\u0027s Degree
428 satisfied customers
For word-processing, I use Microsoft WORD home & Office
For word-processing, I use Microsoft WORD home & Office version: Why do I sometimes get "Read Only" or"Protected View" when I open a saved WORD document ? Then the document comes out in huge print. Ca… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I have Microsoft Office 2016 installed on my computer. Two
I have Microsoft Office 2016 installed on my computer. Two days ago, I ceased work with an organisation and deleted the emaill addresses I had for those organisation. In so doing, there must have been… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
694 satisfied customers
I have just installed ms 365 on my desktop and it has my
Hi I have just installed ms 365 on my desktop and it has my emails stored on the cloud and i need to get on the desktop … read more
Kamil Anwar
Kamil Anwar
IT Consultant / Systems Engineer
Bachelor\u0027s Degree
428 satisfied customers
I'm trying to install Weatherbug and it says it won't
I'm trying to install Weatherbug and it says it won't install on my PC and to check with software publisher for version that will work on my PC. I've had it on there before with no problem. But after … read more
Kamil Anwar
Kamil Anwar
IT Consultant / Systems Engineer
Bachelor\u0027s Degree
428 satisfied customers
I have a copy of Publisher 2007 that I bought. I have a new
I have a copy of Publisher 2007 that I bought. I have a new computer and I installed Publisher on it. When I go to activate it, the message says I have exceeded the number of times to do so. Why is th… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I am trying to access my NYT account but do not have my
I am trying to access my NYT account but do not have my password..any help appreciatedd … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
694 satisfied customers
Two days ago I upgraded to High Sierra and reloaded
Two days ago I upgraded to High Sierra and reloaded Microsoft office. Now I cannot open a document I finished last evening. It's titled "Seoul" and it's a document (DOC) shows on the icon. How do I re… read more
Kris R
Kris R
IT Manager
Computing
2,420 satisfied customers
I need instructions on how to print labels from excel
I need instructions on how to print labels from excel listing … read more
The-PC-Guy
The-PC-Guy
Computer Manager
2,048 satisfied customers
Having problem signing in not getting code on my e mail got
having problem signing in not getting code on my e mail got a new tower for my computer 2 days ago ? maybe problem am not computer smart sorry i just saw e mail for microsoft is not what i thought … read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
518 satisfied customers
Cannot save a document in Word because of "file permission
cannot save a document in Word because of "file permission error" How do I get rid of this so I can save documents? … read more
Cody
Cody
Computer Science
1,543 satisfied customers
My laptop came from the repair-shop, the HD collapsed - (for
My laptop came from the repair-shop, the HD collapsed - (for 2nd time) and "they" returned it without my Microsoft package :( … read more
Cody
Cody
Computer Science
1,543 satisfied customers
My computer crashed and I ended up restoring to factory
My computer crashed and I ended up restoring to factory settings. I re-installed successully Microsoft office after restoring, but again had computer issues. Once again returned to factory settings. E… read more
Bryan
Bryan
IT Consultant
8,747 satisfied customers
Just purchased a new computer and it is telling me that the
just purchased a new computer and it is telling me that the password ***** I input was not correct … read more
Bryan
Bryan
IT Consultant
8,747 satisfied customers
I want to combine multiple rows with the same name in column
I want to combine multiple rows with the same name in column 1 into 1 row. Each row has about 35 columns, but within each row name, there will never be entries within the same column. … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
My system was upgraded by accident. My problem is that the
My system was upgraded by accident. My problem is that the password ***** I had for my "guest' password ***** not work . My regular password ***** ***** but i do not want to give it out to family. How… read more
Bryan
Bryan
IT Consultant
8,747 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x