V9 EXPORTING MORE THAN 64K RECORDS XLS MERGE TABS

V:retail pro9_seriesToolsExcel Plugin to Merge Tabs is a plugin for Office that helps merge into one XLSX file.

In answerbook.

Hi Colt,

I have something that will provide additional value to assist with merging the sheets into one sheet instead of trying to copy and paste multiple 65k row sheets into one. I am providing you with an Excel Add-In that provides sheet merging that can be easily installed by the customers on the machine that’s running Excel 2007 or higher. Please find attached the Excel Add-In file ( RproExcelAddIn.xls) and here is the details for installing and using it:

Installing the Add-In on Excel 2010:

1) Goto File->Options and you will be presented with the Excel Options dialog.

2) Select Add-Ins from the left pane. On the right pane, select Manage = “Excel Add-Ins” and click “Go…”.

3) Click Browse and select our new Excel Add-In file. Make sure to check it on. Click OK to close the dialog. You will notice that the Add-Ins menu at the top now be displaying.

4) Click Add-Ins, you will see a new menu item “RetailPro Helper”. Click it and you will see “Merge All Sheets into New Workbook”.

NOTE: This Add-In won’t install or work on Excel 2003 or any lower versions.

How it works: After exporting the data into Excel the Crystal Report engine opens our file in Excel. Once the file is open you can select the option (“Merge All Sheets into New Workbook”) to merge all the sheets into one sheet in new workbook.

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Comments
This field is for validation purposes and should be left unchanged.

84111

or

Schedule A Demo

Popup — Contact Us

Name*
Organization / Business name*
Address*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Name
This field is for validation purposes and should be left unchanged.

80515

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Name
This field is for validation purposes and should be left unchanged.

36099

or

Schedule A Demo

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Phone
This field is for validation purposes and should be left unchanged.

2608

or

Schedule A Demo

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Email
This field is for validation purposes and should be left unchanged.

59038

or

Schedule A Demo

Sandy Malaney

Upon graduating with a degree in business from California State University, Sacramento, Sandy Malaney accepted a sales position from Lanier Business Products. She found her stride in outside sales, becoming Lanier’s top producer in their telecommunications division.

In 1988, Malaney joined Checkpoint Systems, selling security systems to retail companies. Malaney gained valuable information about the retail sector that would eventually lead her to her next career at a startup called Retail Technologies, Inc. (RTI) in 1990.

As vice president of sales and marketing, Malaney focused on sales, brand marketing, and expanding product line. (Today Retail Technologies is known as Retail Pro International (RPI), and is headquartered in Folsom, CA.)

Then in 1993, RTI eliminated its sales division to focus solely on software development. Sandy and her husband Mick seized the opportunity to open a software distributorship that included selling and supporting RTI’s point of sale and inventory management solution—Retail Pro.

The Malaneys didn’t need to look far for a business name. “Big Hairy Dog” described the family dog, Molly, an Old English Sheep Dog. Today, pups Dugan Finnegan and Paisley Rose continue to dutifully represent the family business.

Sandy Malaney’s varied experiences in business and in life prepared her for the rigors of owning a small technology firm. Celebrating 27 years (or—189 dog years) of success, Big Hairy Dog continues to expand in the retail market place, while providing an award-winning help desk to customers worldwide.

Name*
Organization / Business name*
Address*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Phone
This field is for validation purposes and should be left unchanged.

47631

TECHNICAL SUPPORT

tech@BigHairyDog.com

Support Hours

Monday – Friday: 6AM-6PM PST

PST Saturday: 9AM-5PM PST

Sunday: 9AM-2PM PST

OFFICE HOURS

Monday – Friday: 8AM-6PM PST

Saturday: 9AM-5PM PST

Sunday: 9AM-2PM PST

After-Hours Phone Number:
916.368.1070

Fax: 916.368.1411

3205 Ramos Circle Sacramento, CA 95827

Name*
Organization / Business name*
Address*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Name
This field is for validation purposes and should be left unchanged.

79988

BIG HAIRY DOG

3205 Ramos Circle
Sacramento, CA 95827
800-377-7776 FAX: 916-368-1411
Info@BigHairyDog.com

OFFICE HOURS

Monday – Friday: 8AM-6PM PST

Support Hours

Monday – Friday: 6AM-6PM PST
Saturday: 9AM-5PM PST
Sunday: 9AM-2PM PST

Mick Malaney President & Co-Founder
CELL: (916) 803-3939

Sandy Malaney CEO & Co-Founder
CELL: (916) 802-3939

Sales Department

800-377-7776 | 916-368-3939
Info@BigHairyDog.com
Karen Page CELL: 503-728-8396

Felicia Casper CELL: 916-956-9727

Technical Support Department

916-368-1070
Tech@BigHairyDog.com

Customer Service/Upgrade Service

800-377-7776 | 916-368-3939
Service@BigHairyDog.com

Administration/Billing

916-368-3939
Admin@BigHairyDog.com