I can answer Microsoft Excel 2000-2007 questions regarding formatting, styles, shortcut keys, templates, forms, etc, but will not answer any macro questions.
I have over 15 years experience working in corporate America as legal and financial document support specialist. I have designed a template that converts html and Excel files to inserts these numerical data into Word documents so that there will be no document corruption because of file size and graphics that comes as part of HTML and Excel.
I am a Microsoft Office Master Instructor (MOS), Certiport Administrator and Proctor (97-2003)
|Ty||06/04/16||7||8||10||Thanks for the reply. I actually figured .....|
|John||08/27/15||10||10||10||Thank you Mary. As I said; probably .....|
|Prashant S Akerkar||06/26/13||10||10||10||Dear Mary Thank you. Thanks & Regards .....|
|John Lord||06/06/13||10||10||10||Thank you for your speedy response. I .....|
Hi Ty, Apologies for the late reply. Unfortunately if the numbers and all other data has been entered as text, I do not see how you can 'calculate' the data, except if they are numbers. What i
Hello Bruce, Thank you for your question. What you are trying to accomplish can be done with Named Ranges. Here's how: Define and use names in formulas By using names, you can make your formulas
Hi Michael, Thank you for the question. For this item: (1) "Somehow I need to combine them to make sure the ordered items are not more than what I have in stock but I do not want the inventory
Hi John, You can use Conditional Formatting to get this done. To create the first rule: Select cells A1 through F##. Do this by dragging from A2 to A##. Then, click Home > Conditional Formatting
Hello Randy, Recommendation: Once you have completed the formula and are happy with the result, use the autofill function (or copy and paste the formula) to complete the list Sincerely hope this
Answers by Expert: