Skip to main content

Tagged With "excel"

Blog Post

Wide Format Technology Update- The Canon TX Series printers and MFP Systems

Art Post ·
Just about a year ago, Canon USA released their new TX Series of Wide Format inkjet printers and MFP Systems. Canon has positioned the TX Series as a higher volume solution to capture opportunities on the production side of the aqueous inkjet technical documents market. There are two basic TX Series models available, the TX 3000 and TX 4000. The difference in these models is their supported print width, the 3000 being a 36” printer and the 4000 is a 44” printer. Both TX printers are single...
Blog Post

John O'Leary | 21 Day Challenge for Polek & Polek

Art Post ·
An Excellent message from my friend Chris Polek & John O'Leary
Reply

Re: Adding a drop down list in excel

Old Glory ·
I used to be pretty good at Excel but don't have to use it as much as I used to. That being said, unless things have changed, I don't think that radio buttons or drop down menus can generate a value that can be used in a formula. If the variables are few, then if/then might work. If the variables are great, then try VLOOKUP or HLOOKUP formulas.
Reply

Re: Adding a drop down list in excel

Rick Backus ·
Hey Art, here's how - In Excel add the choices you want in the dropdown to a column of cells. Go to the Data tab and select Data Validation menu and data validation. In the popup window select the setting tab and in the allow dropdown select list. Enter the range of cells where you entered the choices earlier. You can enter additional text from the other tabs and then OK. Voila' a dropdown in Excel. Be careful if you reference the contents of the dropdown as it will result in the index value...
Reply

Re: Adding a drop down list in excel

Art Post ·
thanx for this, I'll give it a go later
Reply

Re: Adding a drop down list in excel

Old Glory ·
I tried this and it works!!! Amazing the things you can learn on this site. Thanks Rick!
Reply

Re: Adding a drop down list in excel

Art Post ·
awesome worked here also, now how about when I pull an item from the drop down that a price will populate in the next column? Any takers on this?
Reply

Re: Adding a drop down list in excel

Rick Backus ·
So expanding on the original solution. Add another column of data next to the choice column you used for the dropdown with the corresponding prices for each choice. Next go to the formulas tab in the ribbon and select Name Manager -> New. Enter "Data" in the range "Name" field and select the range of cells with all the choices and prices in them for the "Refers To" field and OK. Finally in the cell next to the dropdown field enter this formula. =vlookup(E5,Data,2,false) E5 in this example...
Topic

ansarada Announces New Secure Document Management Solution for Managing Microsoft® Office Files During M&A Due Diligence

Art Post ·
CHICAGO--( BUSINESS WIRE )-- ansarada , a global provider of virtual data rooms designed to simplify the mergers and acquisitions process, today introduced Secure Office, a new document review feature that allows bidders to open secure Microsoft® Office files in their native programs, rather than as read-only PDF or image files. With Secure Office, bidders can now manipulate documents, such as adjusting formulas to “stress-test” financial models in Excel, while the seller maintains strict...
Topic

Why Business Intelligence Dashboards Are Killing Traditional Reporting

Art Post ·
By West McDonald, Vice President of Business Development / Owner, FocusMPS What is a BI dashboard? Essentially a BI (Business Intelligence) dashboard is an interactive way to move through important business metrics and data points. You can start with a global view and then “drill down” to get more specific insights. The goal is to take a mountain of data; possibly from different sources like Excel and SQL; and marry them in such a way that actionable intelligence is created. A BI dashboard...
Topic

Thermocopy Earns A 2016 Circle Of Excellence Award From RICOH

Art Post ·
Thermocopy Earns A 2016 Circle Of Excellence Award From RICOH November 5, 2015 · Thermocopy has earned Ricoh’s prestigious Circle of Excellence Award for 2016. Circle of Excellence is earned by fewer than 5% of Ricoh Dealerships nationwide and is designed to recognize Dealers who provide outstanding service and support in accordance with Ricoh’s guidelines. “I’m proud of our team. They’ve earned this distinction through a dedication to work, extensive training, and an ongoing commitment to...
Topic

Fujitsu and Kodak Alaris Each Earn Two BLI Winter 2015 Pick Awards

Art Post ·
Fujitsu and Kodak Alaris Each Earn Two BLI Winter 2015 Pick Awards Date: January 12, 2015 Contact: Anthony Polifrone Tel: 201-488-0404 ext. 39 Fax: 201-488-0461 E-mail: info@buyerslab.com January 12, 2015 – Hackensack (NJ) – Buyers Laboratory LLC, the world’s leading independent tester of document imaging products, announced its highly anticipated Winter 2015 Pick awards in the scanner category today, bestowing honors upon two scanners from Fujitsu and two scanners from Kodak Alaris.
Topic

Excel Document Solutions, Inc. becomes Ricoh Certified Services Provider through CHAMPS program

Art Post ·
Malvern, PA, August 12, 2014 - Ricoh Americas Corporation today announced that Excel Document Solutions, Inc. has been officially confirmed as a Ricoh Certified Digital Imaging and Managed Document and Business Process Services Provider through Ricoh’s CHAMPS program for dealer transformation. Individual workstyles continue to quickly evolve in today’s dynamic work environment, and as a result Ricoh is focused on information mobility: helping workers at organizations of all sizes access...
Blog Post Premium

Ask Art "Is Selling Workflow Really Worth the Hassle"?

Art Post ·
Here's a recent email from a Print4Pay Hotel member.   Recently I read an article you had written about whether or not solutions were worth the hassle and I find myself wondering the same thing many times.  We have been evaluating and using...
Topic

Adding a drop down list in excel

Art Post ·
Can anyone help with this?  I'm working with MS 365 and would like to add drop down lists for products that would then auto populate the price.  I went here and followed the instructions however it is not working ...
Topic

Virtela Wins 2013 Excellence In SDN Award

Art Post ·
DENVER, Dec. 30, 2013 -- /PRNewswire/ -- Virtela, the world's largest independent managed network, security and cloud services company, today announced that it won the 2013 Excellence in SDN Award for Virtela Enterprise Services Cloud (ESC),...
Topic

BTA’s Newly Revamped FIX: Cost Management for Service 2.0 Scheduled for Feb. 13

Art Post ·
NEWS RELEASE For Immediate Release For More Information Contact: Jan. 9, 2014 Brent Hoskins Executive Director Business Technology Association (816) 303-4040 BTA’s Newly Revamped FIX: Cost Management for Service 2.0 Scheduled for Feb. 13 Attendees receive free registration to BTA’s Winter Break district event Kansas City, MO — On Feb. 13 in Orlando, Fla., the Business Technology Association (BTA) will present FIX: Cost Management for Service 2.0 as a front-runner to the Winter Break district...
Topic

BTA’s FIX: Cost Management for Service 2.0 Scheduled for Nov. 14

Art Post ·
NEWS RELEASE For Immediate Release For More Information Contact: Oct. 5, 2016 Brent Hoskins Executive Director Business Technology Association (816) 303-4040 BTA’s FIX: Cost Management for Service 2.0 Scheduled for Nov. 14 BTA members may apply their $150 or $250 educational discount promo code received with their membership toward the tuition fee Kansas City, MO — On Nov. 14, the Business Technology Association (BTA; www.bta.org ) will present FIX: Cost Management for Service 2.0 (...
Blog Post

Eight Excellent Reasons Why the Ricoh MP 305SPF Should be Your Next Copier Lease or Purchase!

Art Post ·
Years ago with the emergence of A4 (devices that can only print/copy letter or legal paper), we had to adjust our talk track to add, "do you need to print, copy or scan 11x17 (tabloid) size paper. That first question would help us determine if the client was a candidate for an A4 or A3 (devices that can print/copy/scan tabloid) device. Ricoh's new MP 305SPF gives us a new wrinkle when proposing the right system for our clients. The claim to fame for the MP C305SPF is that clients with...
Topic

FlexPrint LLC Recognized as 'Best of the Best' With Ricoh Circle of Excellence

Art Post ·
PHOENIX - October 30, 2017 - ( Newswire.com ) FlexPrint LLC is proud to announce that it has been certified as a 2018 RFG Circle of Excellence dealership. This award recognizes those who are the “Best of the Best” within Ricoh’s national dealer network that provide outstanding service and support in accordance with Ricoh's strict guidelines. FlexPrint LLC and all its authorized service locations are exceeding the standards. “It is an honor to receive this award for another year. We are proud...
Topic

Excel Business Systems Specializes in Office Equipment in Virginia and Grand Rapids, Minnesota

Art Post ·
To boost employee productivity and ensure business growth, purchasing right office equipment in Virginia and Grand Rapids, Minnesota, is essential. This press release was orginally distributed by ReleaseWire Hibbing, MN -- ( ReleaseWire ) -- 01/13/2020 -- Studies show that employee productivity is directly proportional to the quality of office equipment. The more the quality, the better the employee productivity. To increase and boost the productivity of the business, it may be worth to...
Topic

Excel Business Systems Improves Business Operation Through Office Equipment in Grand Rapids and Virginia, Minnesota

Art Post ·
This press release was orginally distributed by ReleaseWire Hibbing, MN -- ( ReleaseWire ) -- 06/04/2019 -- Having proper office equipment is necessary to ensure the smoothing running of the business operation. The range of equipment, be it a fleet of 3D printers or copiers, should be in good working condition to avoid any discrepancy with the operation at the work unit. This is where Excel Business Systems comes into the scene. As a premier resource for office equipment in Grand Rapids and...
Topic

NetDocuments Wants to Update Legal’s Tedious Document Organizing Process

Art Post ·
Lugging massive binders to litigation or filing binders on shelves for recordkeeping may become a relic of the past, if NetDocuments’ new SetBuilder add-on has its way. SetBuilder allows users to link and organize various Microsoft Word documents and Excel spreadsheets needed for a matter and house those documents in a single PDF for distribution and storage. To be sure, SetBuilder isn’t the first document management tool adapted to lawyers’ and legal staff’s workflows, but NetDocuments said...
Comment

Re: Towa Typewriter Excellence 55

Art Post ·
I sold a few of these in the late eighties and early nineties. Towa Corporation was based out of Morrisville, PA. They had a small dealer channel, in addition to typewriters they also sold copiers and cash registers. They re-label Sanyo copiers. Frak does anyone remember Sanyo!
Image

Towa Typewriter Excellence 55

Art Post ·
Towa Typewriter Excellence 55
Topic

M-Files Named Winner in the 2022 BIG Artificial Intelligence Excellence Awards -

Art Post ·
AUSTIN, Texas, March 23, 2022 --( BUSINESS WIRE )-- M-Files , a global leader in information management, today announced that the company has been named a winner in the Business Intelligence Group’s Artificial Intelligence Excellence Awards program . In its inaugural year, the BIG Artificial Intelligence Excellence Awards sets out to recognize organizations, products and people who bring Artificial Intelligence (AI) to life and apply it to solve real problems. M-Files was recognized for its...
Topic

Ricoh Wins 2023 ENERGY STAR® Partner of the Year Sustained Excellence Award from EPA for 8th Straight Year

Art Post ·
Ricoh Wins 2023 ENERGY STAR® Partner of the Year Sustained Excellence Award from EPA for 8th Straight Year EXTON, Pa. , March 28, 2023 / PRNewswire / -- Ricoh USA , Inc . today announced it has received the 2023 ENERGY STAR Partner of the Year Award for Sustained Excellence from the U.S. Environmental Protection Agency (EPA) and the U.S. Department of Energy. Supporting the company's commitment to the environment made more than 45 years ago, and its mission to realize a sustainable future,...
×
×
×
×
×