Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Jess. I have another task for you, using the same

Customer Question
Hello again Jess. I have another...
Hello again Jess.
I have another task for you, using the same spreadsheet I gave you - do you still have it? I need you to add in extra sheets (added in automatically once it recognises left of flower stems as identified in the sheet) which will be additional orders using the same table and workings out except that the second and subsequent sheets will only use the flowers left over from the previous order/sheet. This is to be calculated in the 'Summary Order Costings' table in the bottom left side of each sheet. However, each new sheet will show in that table a running total from the previous sheets total cost as well as the individual fee charged per order the total flowers left over (all orders), the flowers left over wholesale cos, and the total GST to pay all orders. The second and subsequent sheets will only be generated automatically once the final cost is generated on each sheet and only off there are flowers left over in Column K.
Submitted: 26 days ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 14 hours by:
3/29/2018
Microsoft Office Technician: Jess M., Computer Support Specialist replied 25 days ago
Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 7,608
Experience: Computer Software Specialist for more than 10 years
Verified

Hi, thank you for requesting me. Can you send me the file again and then include the extra sheet that you require? I want to see if I can automate it for you and I want to see what exactly are the information to be placed on that automated sheet.

Ask Your Own Microsoft Office Question
Customer reply replied 24 days ago
Hi Jess,
I have been working on the various sheets and this has shown me some additional complications that have emerged, so I am working on fixing these for you as much as I can to make it easier for you to follow. I am now changing the look and process of the first and subsequent sheets to make it easier for my wife to use. As soon as I have finished at my end I will send it to you. In the next couple of days.
Customer reply replied 24 days ago
PS. I am also open to any suggestions you might have as we progress the job.
Microsoft Office Technician: Jess M., Computer Support Specialist replied 24 days ago

Thank you, ***** ***** your time.

Ask Your Own Microsoft Office Question
Customer reply replied 22 days ago
Hello Jess,
I have reworked the spreadsheet again and now have two sheets only. The first sheet involves the flower costing calculations and the second is an invoice for the first sheet order. once an invoice is generated i need you to rework the first sheet as a new fresh sheet ready for a new order to be done with the first order to be saved as a separate file for company records.Can you please check:
1. that all cells formulas are working
2. insert a macro button to generate an invoice on the second sheet once the order is completed (invoice needs to be in an editable form of some sort to enable the completion of each order details).
3. Once the invoice is generated I need you to refresh the first sheet for use as a new order while keeping the previous order as a separate file for record keeping. The new order sheet (first sheet) to be included as part of a new order in cells A3 to D21 and F3 to F22 as blank as well.
4. Once an order has been completed, there will most likely be some flower stems left over. these need to appear on the next order sheet in cells A and B cells 26 to 44 as left over from the previous order.
5. The invoice sheet, once completed, will need a macro button to send to pdf then to save and send to email and print.
6. Save needs to save both the first order sheet and the invoice sheet under one name for filing and retrieval purposes.I hope this make sense?
Regards, John
Microsoft Office Technician: Jess M., Computer Support Specialist replied 21 days ago

Thank you John. Please give me some time to check on your Excel file and your required results.

Regards,

Jess

Ask Your Own Microsoft Office Question
Customer reply replied 14 days ago
Hi Jess,
How are you going with my request. Its been over a week now?
Regards, John
Customer reply replied 12 days ago
Hi Jess,
If you are having trouble completing my request please let me know and I will put it out to others to try. I really need this done soon.
Thanks, John
Microsoft Office Technician: Jess M., Computer Support Specialist replied 12 days ago

Sorry for the delay. Here are some clarification:

1. Check that all cells formulas are working

Sheet 1 has formulas, all working. Invoice has no formulas.

2. insert a macro button to generate an invoice on the second sheet once the order is completed (invoice needs to be in an editable form of some sort to enable the completion of each order details).

- What is the source for INVOICE data? You need to fill out the invoice sheet, Excel calculates figures, then save it as a SEPARATE file? And once the INVOICE is saved as a separate file, that is what you meant by "order is completed" and you will DEDUCT the ordered quantity to the stock or inventory in Sheet 1?

3. Once the invoice is generated I need you to refresh the first sheet for use as a new order while keeping the previous order as a separate file for record keeping. The new order sheet (first sheet) to be included as part of a new order in cells A3 to D21 and F3 to F22 as blank as well.

-I don't understand this completely. Is this what I mentioned above? Are you saying that when the INVOICE is generated and saved as a separate file, you need Sheet 1 to be UPDATED (stocks in the previous invoice will be deducted) for use in the next invoice?

4. Once an order has been completed, there will most likely be some flower stems left over. these need to appear on the next order sheet in cells A and B cells 26 to 44 as left over from the previous order.

-Covered above.

5. The invoice sheet, once completed, will need a macro button to send to pdf then to save and send to email and print.
6. Save needs to save both the first order sheet and the invoice sheet under one name for filing and retrieval purposes.

Ask Your Own Microsoft Office Question
Customer reply replied 11 days ago
Hi Jess,
point 1. all good.
point 2. the macro button in the first sheet (sheet 1) is used once the first sheet is finished with an order. You press the macro button and it automatically opens the second sheet. Once in the second sheet, the invoice is generated according to the figures in the first sheet (the total cost and number of flowers used etc.) but this invoice sheet also needs to be edited by the person doing the order. Also, as there may be flowers left over when finishing with the invoice, these left overs will need to show in a new sheet 1 (new order). After completing the final invoice stage, the sheet 1 order and invoice will need to be saved to a separate file for record keeping.
Point 3. Yes, I need the new order to include any left over flowers, but also allow the person to update with new flowers etc as per the capabilities of the first sheet. The new order will also show a blank invoice (sheet 2).
Point4. covered above.
Point 5. and 6. agreed.
Please let me know if still confused :-)
Microsoft Office Technician: Jess M., Computer Support Specialist replied 11 days ago

Ok one more clarification.

On the first sheet it is called the template. What cells will take the order? Are those in column C? or in column F?

And what data or information from from sheet 1 will be transferred to the INVOICE sheet?

I suggest that you give me a sample file with sheet 1 being filled out for ordering, and what are the data to be transferred in the INVOICE sheet so that I can start from there.

Ask Your Own Microsoft Office Question
Customer reply replied 11 days ago
Hi Jess. Please find attached the spreadsheet with an order as an example. Please note the invoice fields need to be left editable as each order will have different items and different customers. The only thing to come across from the first sheet will be the total fee charged.
In the first sheet, Columns A, B, C, D, and F with a pale ivory colour (in fact all cells with an pale ivory colour are editable by the user) are to be editable by the user. The other cells and fields I intend locking down. So, the above columns are editable by the user as well as cells M 26, 27, 28, 29 and 32. Cells B 26 through to B 44 is where the left over flowers are to appear. These left over flowers can show in the current order sheet and in the new order template but can be deleted by the user if required.
Microsoft Office Technician: Jess M., Computer Support Specialist replied 11 days ago

Now with that sample order, HOW do you want the Invoice sheet to look? I need to see what data and where these data from sheet 1 are pulled out.

Ask Your Own Microsoft Office Question
Customer reply replied 11 days ago
The invoice will look exactly as I have shown you on the second sheet.
Microsoft Office Technician: Jess M., Computer Support Specialist replied 11 days ago

I can see the invoice sheet, but I want to see, based on the order info on sheet 1, what are the entries in the invoice so that I can see where to pull them.

Ask Your Own Microsoft Office Question
Customer reply replied 11 days ago
The only figure to come across is the total fee charged. The rest of the fields are to be left blank for the user to fill out.
Microsoft Office Technician: Jess M., Computer Support Specialist replied 10 days ago

Oh, that is not ideal but can be done too. With Excel, if sheet 1 is complete with information regarding orders, the invoice CAN pull out the data from sheet 1 so that the user only needs to enter the invoice to and delivery address. But if you only want to copy the total fee (O34 in sheet 1) to L46 in Invoice sheet, that will be fine.

Ask Your Own Microsoft Office Question
Customer reply replied 10 days ago
For the moment that is all we need. Can you complete the rest of the tasks so I can test it out?
Customer reply replied 8 days ago
Hi Jess,
One more thing. When the invoice button is pressed at the end and it generates a pdf, to allow to save and print and then refreshes the first page and the invoice for another order while also showing the left over flowers in the bottom left table. I need you to show these left over flowers from that order in a separate columns next to the existing column of left over flowers. This is because as it is now there will be a conflict between flowers left over in the current order showing on the new sheet and the flowers left over from the second order.
Customer reply replied 8 days ago
Please see attached the latest version of the calculator with the additional cells for the left over flowers
Microsoft Office Technician: bbao, IT Consultant replied 8 days ago
bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 1,358
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP
Verified

How can I help you here?

Ask Your Own Microsoft Office Question
Customer reply replied 7 days ago
Hello, I have a excel spreadsheet that I need some help with. It is a cost calculator and invoice system for my wife's new business. it has two sheets. The first sheet is a costing calculator which is pretty much completed but needs a button for the user to push and automatically take them the second sheet where they generate the invoice. The only data to come across from the first sheet is the total fee to be charged which is located in cell O34. this goes into cell H37 on the second sheet. Once they have filled out the invoice this second sheet needs another macro button that will allow the user to save both sheets in a file they name for their records, then be able to print just the invoice or save as PDF to send to the customer. Once this is done then we need the first sheet (calculator) to represent with the original data deleted and ready for another new order for calculating in the first sheet and a new invoice. One issue we also need is to have any left over flowers from the first order to show in the next new order in the table on the bottom left. This second order starts the whole process over again. Are you able to do this for me.
Microsoft Office Technician: bbao, IT Consultant replied 7 days ago

This is a small invoicing application. To keep all history records, you need at least one more sheet for all details. Actually, the best way to do this is not with Excel, it is a job for Microsoft Access.

Ask Your Own Microsoft Office Question
Customer reply replied 7 days ago
I need to work with excel as the first step is using a calculator. Please see the attached spreadsheet. The first sheet has the calculator and the second sheet has the invoice.
Customer reply replied 6 days ago
I understand this is difficult for you to do, so can you at least insert a macro pdf button on the invoice sheet near the cell H37 that allows the user to save the sheet(invoice) as a PDF on my desktop. I will have to work out the other features myself.
Microsoft Office Technician: bbao, IT Consultant replied 6 days ago

Sorry, I can't be available on this question in recent two days. I opt out for now and see if other experts can help. I will come back once the question is still outstanding there in two days. Sorry for any inconvenience.

Ask Your Own Microsoft Office Question
Was this answer helpful?
Ask NewITZone Your Own Question
NewITZone
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
90 Satisfied Customers
Experience: I have been using Office Pro for 10 years and implemented applications for business use.

NewITZone 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

7,608 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

588 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

147 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
Trying to open my Office 365 account and it says my
Trying to open my Office 365 account and it says my organization is marked for removal. What does that mean? Details copied here; … read more
bbao
bbao
IT Consultant
1,358 satisfied customers
I am creating labels in Microsoft word. In mail merge
I am creating labels in Microsoft word. In mail merge manager, I select document type. Which automatically puts in old information. This is valid 5150 avery labels. Then I select "Get LIst" and select… read more
Jess M.
Jess M.
Computer Support Specialist
7,608 satisfied customers
I have Word 2013 and scanned a document into my computer. It
I have Word 2013 and scanned a document into my computer. It is in PDF format. I opened it in Word and the message comes up stating it will change the PDF to an editable Word document. It looks like i… read more
Cris
Cris
60 satisfied customers
I accidently shut down a word document and I can't find it.
Hi I accidently shut down a word document and I can't find it. I lost my wor. Is there any way to retrieve. … read more
bbao
bbao
IT Consultant
1,358 satisfied customers
Desktop, WIN 10, Office 365, Can not start any of the
Desktop, WIN 10, Office 365, Can not start any of the MS-Office programes. "cannot find 'C:\program files (x86)\Microsoft Office\Office16Excel.exe' Any advice? I am using Firefox browser.. Thanks Joch… read more
John
John
System/Network administrator
High School or GED
2,069 satisfied customers
I have a common problem – a recent Microsoft Office update
I have a common problem – a recent Microsoft Office update has stricken all my customised features in AutoCorrect and AutoText from Normal.dotm. But why should I worry? I have a version of Normal.dotm… read more
bbao
bbao
IT Consultant
1,358 satisfied customers
I am trying to make two sided table tent signs. I have 5
I am trying to make two sided table tent signs. I have 5 images duplicated one on each 8.5x11 sheet. I can 1 of the 10 total images to show up. Only the file location appears. how do I get them show u… read more
bbao
bbao
IT Consultant
1,358 satisfied customers
I have mistakenly replaced my original word document with
Hi I have mistakenly replaced my original word document with another worddoc … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,395 satisfied customers
Yesterday u[graded from office 365 personal to 365 home.
Yesterday u[graded from office 365 personal to 365 home. Your colleague canceled my old subscription. I installed 365 home. But it is not working. So now I have no access at all. … read more
bbao
bbao
IT Consultant
1,358 satisfied customers
My hard drive died and and i need to get another hard drive.
My hard drive died and and i need to get another hard drive. I just renewed my office 365 and do not have a key code to reinstall office. can you please help me get my office back. … read more
Mr.Med
Mr.Med
1,046 satisfied customers
Need help assigning background colors of plot area to data
Need help assigning background colors of plot area to data source … read more
bbao
bbao
IT Consultant
1,358 satisfied customers
I need to reinstall Microsoft office. I have my serial key.
I need to reinstall Microsoft office. I have my serial key. What do I do … read more
Jason Jones
Jason Jones
AAS Information Technology
6,322 satisfied customers
In an excell spreadsheet, I hid column A and now I cannot
In an excell spreadsheet, I hid column A and now I cannot get it to show … read more
Russell H.
Russell H.
Computer Technology Consultant
Vocational, Technical or Trade Scho
788 satisfied customers
Just installed Microsoft Office on my new iMac. Where is it?
Just installed Microsoft Office on my new iMac. Where is it? … read more
Don Williams
Don Williams
BS
14 satisfied customers
There was an upgrade on my MacBook Air Laptop this
Hello! There was an upgrade on my MacBook Air Laptop this afternoon. I have been able to work with everything except with Microsoft Word; the response is always "Microsoft Word is Currently being upda… read more
bbao
bbao
IT Consultant
1,358 satisfied customers
My normal.dotm is corrupted. Word 2010. 2 days ago.
my normal.dotm is corrupted JA: What application are you using? Customer: word 2010 JA: When did you last update Word? Customer: 2 days ago JA: What have you tried so far with your Word? Customer: eve… read more
Jason Jones
Jason Jones
AAS Information Technology
6,322 satisfied customers
I have a word created document that I am not able to open.
I have a word created document that I am not able to open. It does not give me the choise of word a … read more
Moses C
Moses C
Bsc
566 satisfied customers
MY outlook fails to connect to the server. To resolve this
Hi, MY outlook fails to connect to the server. To resolve this we have reinstalled outlook a few times. Which resolves the issue but then a few days later the same problem comes back. I have also rein… read more
bbao
bbao
IT Consultant
1,358 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