Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

This answer was rated:

I have a spreadsheet that shows that sub-totals of several…

I have a spreadsheet that...
I have a spreadsheet that shows that sub-totals of several inventory items. The sub-total command uses column C (Item Number) as the "At each change in" filter. Us there an Excel command that will enable me to copy the Item Description appearing in column D so that it will appear in the sub-total row. The reference to the Item Description that I want to appear in column D would be the Item Descripiton appearing in row prior to the sub-total row. For example if the row sub-total is in C5, I want D5 to grab the Item Description in D4 and copy this to the blank cell in D5 so that the sub-total will have an Item Description.
Show More
Show Less
Ask Your Own Programming Question
Answered in 3 minutes by:
6/29/2010
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,

 

It would help if you can send me the file so I can work on it directly. Would that be ok?

 

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
There is no insert file option. How do I go about it?

Ok go to www.wikisend.com and upload it. You will then get a page that has the download link. Copy the download link and come back here and paste it in your reply.

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago

http://wikisend.com/download/603734/Sample.xlsx

 

My question is how do you populate the sub-total line with the item decription shown in the row preceeding the sub-total line. For example, row26. how do you place the item description "Greens Grade 50 lb" in row26 columnD. I have a worksheet with about 200 pages and thousands of sub-totals.

You cannot do that with the Subtotal command mainly because the subtotal row is created and reserved by the Subtotal feature. You will need a macro to place the preceding text in the subtotal row. Even then before you apply Subtotal again you will need to remove the added text.

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago

John, it is actually the macro that I need in order that I can populate sub-total row with the item description. Can you send the macro?

Ok, I will write a macro to do that. Should have it ready this evening or by tomorrow morning.

 

Ask Your Own Programming Question

Ok, here you go

 

http://www.sendspace.com/file/19zpf2

(the download link is at the bottom of the page)

 

The macro is run by clicking the Go! button.

 

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

John,

 

Fantastic. It worked! Now how do I copy the macro to my main file so I can test whether it will work in the large file.

 

Thanks,

 

Romy

Great!

 

Ok I will prepare the instructions for transferring the macro, In the meantime time please go ahead and click the Accept button if you are satisfied with the macro. Thanks.

 

 

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
Customer reply replied 8 years ago

John,

 

Just a minor revision please. Can you modify the macro so that it will include the Invty Type description appearing in Column E.

 

Thanks for your help. I truly appreciate it and will make sure you get a well deserve feedback recommendation.

 

Romy

Sure. Here you go

 

http://www.sendspace.com/file/hgsmpb

 

And here are the instructions for transferring the macro to another file


1- Close all Excel workbooks and Excel programs.
2 - Open the file that I sent you.
3 - Press the keys ALT + F11 to open the Visual Basic Editor
4 - Copy the macro code by selecting all the code lines and pressing the keys CTRL+C
5 - Close this file
6 - Open your own workbook
7 - Press the keys ALT + F11 to open the Visual Basic Editor
8 - Press the keys ALT + I to activate the Insert menu
9 - Press M to insert a Standard Module
10- Paste the code by pressing the keys CTRL+V
11- Make any cusXXXXX XXXXXes to the macro if needed at this time
12- Press the keys ALT+Q to exit the Editor, and return to Excel

13- Save your excel file

 

Hope this helps

 

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'm trying to make a simple spreadsheet on excel that allows
i'm trying to make a simple spreadsheet on excel that allows me to do an IF THEN type of formula where if the cells in B14 to D14 = cells in a different tab, AND if E14 in that different tab is NOT blank, THEN F14 in the first tab will equal E14 minus 1. and i dont know how to do that. can you help? … read more
George Sibiya
George Sibiya
PhD
313 satisfied customers
I have a spread sheet that has line item costs that are
I have a spread sheet that has line item costs that are categorized 1,2,3 or 4. I want to summarize costs by category. How?… read more
Bruce Wilner
Bruce Wilner
Master of Engineering
30 satisfied customers
I have a large excel 2000 data sheet,(over 500 rows)
I have a large excel 2000 data sheet,(over 500 rows) with col (C) populated with "N" in some rows, while all other rows in col (C) are blank. Col (D) is populated with dollar amounts which are increme… read more
Ryan-CTech
Ryan-CTech
Manager
279 satisfied customers
i am trying to convert text in a cell that looks like a 1 d40
i am trying to convert text in a cell that looks like a 1 d40 to a formula, a is the file name, 1 is the sheet number and d40 is the cell. So I want the text to change to be +file name, sheet number c… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Hi,In Excel, i need to identify how many times a certain
Hi, In Excel, i need to identify how many times a certain account has been inactive. I can do this by counting how many times there is a blank in the single row of data for each account. Not how many … read more
shorecc
shorecc
143 satisfied customers
I want to be able to name a column preferably programatically
I want to be able to name a column preferably programatically but if necessary through the ribbon. Ideally inserting a new row will not change the name of this row. Then I need to be able to loop thro… read more
Suryanto
Suryanto
Computer Engineer
Bachelor's Degree
535 satisfied customers
I need a VBA routine written. I have two worksheets. In worksheet
I need a VBA routine written. I have two worksheets. In worksheet "Expedite-Revised" there are Inventory Item #'s. Worksheet "OMO Rpt Data" also has Inventory item #'s. I need to be able to hyper-link… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I have an excel sheet with 3 columns I need to match duplicate
I have an excel sheet with 3 columns I need to match duplicate information that would occur in more than one row. For example 0.19 / CD RD / 4140 repeats twice below. Then I would need to add the tota… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
how can I, using excel 2007 show standard deviation in each
how can I, using excel 2007 show standard deviation in each cell rather than having it displayed at the bottom of the range… read more
J. Mar
J. Mar
IT Specialist
Master's Degree
341 satisfied customers
excel 2007 programming question. I have a spreadsheet and in
excel 2007 programming question. I have a spreadsheet and in the spread sheet is a column for product description i have another spreadsheet with a column of product descriptions. the rows of the firs… read more
ATLPROG
ATLPROG
Computer Software Engineer
Master's Degree
7,677 satisfied customers
I have a workbook in Excel 2007 that has three tabs an inventory
I have a workbook in Excel 2007 that has three tabs – an inventory tab – Johnston purchase order tab – Empire purchase order tab. Note: There will be additional purchase order tabs. The inventory tab … read more
Suryanto
Suryanto
Computer Engineer
Bachelor's Degree
535 satisfied customers
Have a spread sheet with 315 rows. Need to navigate between
Have a spread sheet with 315 rows. Need to navigate between column C and column D sequencially. Have a macro to position cell cursor at C4 when the workbook is opened._Using Data Validation to present… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
@ John D - For the same worksheet we were working on AF (QTY)
@ John D - For the same worksheet we were working on AF (QTY) AG (Item Description) AH (Unit Price) need option for multiple entries containing them in the same row, perhaps a drop down table with the… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I want my macro to GoTo a cell, copy the results, paste the
I want my macro to GoTo a cell, copy the results, paste the value in the next cell, copy the "new value" and then GoTo the "new Value" which is a calculated value in the ss. The macro below shows "Pag… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I use Excel 2003 and currently have this formula SUM(IF($A$16 $
I use Excel 2003 and currently have this formula: =SUM(IF($A$16:$A$9999="BH",IF(AH16:AH9999>=500,1,0),0)) But I want to use this inconjuction with the SUBTOTAL function. Can you help me on this for… read more
John The Geek
John The Geek
Senior Software Developer
Bachelor\u0027s Degree
65 satisfied customers
Excel 2003. In Spreadsheet A I have a list of items going
Excel 2003. In Spreadsheet A: I have a list of items going down Column A, in column B I have a quantity, and in Column C, I have a formula which multiplies the quantity in column B by a cell in Spread… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I can format the text of an entire row by changing the value
I can format the text of an entire row by changing the value of one cell in that row by 'managing rules' under conditional formatting. However that conditional format is fixed to that cell when I copy… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I am trying to create a booking system and want to know occupancy
I am trying to create a booking system and want to know occupancy at any time. As an example if I have 10 spots available and I enter a name in one cell I want to see that there are 9 spots left. So i… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 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