Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

On a spreadsheet with X number of names, one name per row,

Customer Question
there are five columns of...
On a spreadsheet with X number of names, one name per row, there are five columns of data for each name. The challenge I have is that some of the names are XXXXX XXXXX their column data is different. I want to create a macro that will give me combined data for each name and leave me with unduplicated names with data totals. The data is all numeric and can end up on a new worksheet.
Submitted: 8 years ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 34 minutes by:
6/17/2010
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago
John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9,666
Experience: Vast experience in Excel programming and business solutions
Verified

Hi again,

 

If you can send me your file I will be happy to take a look at it. you. If you need help uploading the file let me know.

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
I will send but it will come from my work email and a different PC. What is your email address?
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

To send the file go to www.wikisend.com and upload it there. You will then get a page that has the download link (the link looks something like this http://wikisend.com/download/527586/Book1.xls). Copy the download link and come back here and paste it in your reply.


If the file has sensitive information let me know before you upload it.

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago

Information not sensitive - link below - comments added to file

 

http://wikisend.com/download/966788/JustAnswerFileDaniels.xls

Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Ok I am almost done. Will post the file in a moment...

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
OK
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Ok, here you go

 

FILE

 

To run the macro click the Go! button. The results will be displayed in the sheet "Combined"

 

Please note that since there is a macro in that file you need to make sure that you have your Excel Options configured so that macros are allowed to run, otherwise nothing happens when you click the button. If you need assistance in this regard please let me know.

 

Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the work.

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
That's not the way I want it - on the combined sheet I want one name with the totals for that one name. i.e. on the Associate worksheet XXXXX XXXXX is listed twice with different column data. On the Combined sheet I want her to show up once with her data summarized/combined (whatever term you want to use) in the cognizant column. Make sense? I will add an additional $18 when satisfied if you're agreeable.
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Will do.

 

Should have it ready within 30 min...

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
Breath is bated - col
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Here goes

 

FILE

 

Check it and let me know if it needs anything else.

 

Thanks

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
Final question - will this work on unlimited list of names? i.e. if i used it on 5,000 agent names, would the result be the same?
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Absolutely. The macro determines the last row of data irrespective of how many rows there are. Try adding or removing names to see how it works.

 

 

 

John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9,666
Experience: Vast experience in Excel programming and business solutions
Verified
John D and 87 other Programming Specialists are ready to help you
Ask your own question now
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Thanks!

 

Ask Your Own Programming Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask John D Your Own Question
John D
John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9,666
9,666 Satisfied Customers
Experience: Vast experience in Excel programming and business solutions

John D 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:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I have an excel file with dates. Every two columns make up
I have an excel file with dates. Every two columns make up an object with dates (begin and end). I have almost 200 objects of this sort, so there are many columns. I need to find the latest date in ea… read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
How can you update an existing table in a database from an
how can you update an existing table in a database from an excel spreadsheet that has five columns, ID, Col1, Col2, Col3, Col4, the problem is that the excel spreadsheet columns should go into one col… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,133 satisfied customers
Need to write a macro for an Excel project, with the following
Need to write a macro for an Excel project, with the following variables. 1. Data is gathered from multiple sheets 2. Data has a discrepancy with the name format. Is has both last name/first name, no … read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
I need someone to create a VBA macro in excel to merge the
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 n… read more
AAATom
AAATom
Software Engineer
Master\u0027s Degree
42 satisfied customers
I have an Excel file with 247 sheets with identical columns
I have an Excel file with 247 sheets with identical columns and the same number of rows and columns of data. Basically, each sheet is a page created from a 247-page PDF report. I want to create a Mast… read more
Ryan-CTech
Ryan-CTech
Manager
279 satisfied customers
I need a macro to merge a folder with about 140 single page
I need a macro to merge a folder with about 140 single page spreadsheets into a single page summary spreadsheet. Range B1;B35, and E1:35, are the only data I want on the spreadsheets in the folder. I … read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
For excel 2003, create a MACROI have a spreadsheet layout
For excel 2003, create a MACRO I have a spreadsheet layout out as follows: • A spreadsheet with multiple tabs. • There is a primary worksheet named “MAIN” which holds summary pulled from the other tab… read more
Ryan-CTech
Ryan-CTech
Manager
279 satisfied customers
I want to track my students progress in excel. I have some
I want to track my students progress in excel. I have some classes with 17 students, some classes with 23 students. I'll create tables for each class. They'll all be on one worksheet (per quarter). Ea… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I need to modify a macro. I need this macro to be easier to
I need to modify a macro. I need this macro to be easier to use. I will upload an excel spreadsheet that includes this macro to whatever site you require. At Run Time I would need to be prompted to in… read more
Suryanto
Suryanto
Computer Engineer
Bachelor's Degree
535 satisfied customers
I have a single spreadsheet that is generated daily that has
I have a single spreadsheet that is generated daily that has a column of daily totals. I have a second spreadsheet that contains that daily total, with all the previous daily total columns. Basically … read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
MACRO - to Pivot data, within the Active Spreadsheet/worksheet,
MACRO - to Pivot data, within the Active Spreadsheet/worksheet, for all rows in that spreadsheet. I have 18 different documents, all formatted in the same way, with the same columns, but that can have… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
MACRO, to copy entire contents of multiple spreadsheets, into
MACRO, to copy entire contents of multiple spreadsheets, into the one worksheet in another spreadsheet, and append each document immediately after the last, starting on the first empty row, column A E… read more
Suryanto
Suryanto
Computer Engineer
Bachelor's Degree
535 satisfied customers
I have a two step issue. Step 1 I am creating a csv file
I have a two step issue. Step 1: I am creating a csv file from a program that extracts sales information from a certain program our company uses. The information comes across with both details and tot… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I need an Excel Macro. I will provide an excel spreadsheet.
I need an Excel Macro. I will provide an excel spreadsheet. Column A of the spreadsheet contains customer account numbers. The same account may be listed on numerous rows (in this example some custome… read more
Suryanto
Suryanto
Computer Engineer
Bachelor's Degree
535 satisfied customers
I need a formula or VBA code that will allow me to do the following I
I need a formula or VBA code that will allow me to do the following: I have an excel database of approx. 2000 records (it's a membership database). There are separate lines for each member, some of wh… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
For John D You made a sort Macro for me. What I want
For John D You made a sort Macro for me. What I want to do is to be able to create is a summary page that looks back to the detailed information and pulls up totals based on a specified (by the user) … read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Lets say I have an excel spreadsheet of all NFL players (32
Let's say I have an excel spreadsheet of all NFL players (32 teams) and their stats (20+ columns). I need a macro that will run through the roster and pull out all players by TEAM, and put those playe… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Hi I have a spreadsheet which has multiple tabs. The information
Hi I have a spreadsheet which has multiple tabs. The information from each tab is summarised on another sheet within the spreadsheet. Each formula which I need to change manually is in the form of; =D… read more
Tony M
Tony M
Sr. Application Developer
Bachelor's Degree
54 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