Reply
 
LinkBack Thread Tools Display Modes
  #1   Report Post  
Old June 21st 13, 07:50 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2013
Posts: 5
Default Sorting data exported from Crystal Report

I have a crystal report that list customers from different locations.
The format is simple. 1 row will have the name of an office. lets say 'office 1'. then it will have a list of the customers in column a. eventually 'office 2' will be in column a followed by their list of customers. 5 offices total. i import the sheet created by crystal into a table in sheet1 of a new spreadsheet. now i need to split that table into 5 sheets. sheet2 will be office 1 and their customers. sheet3 will have office 2. etc. i have used address/match and can get the cell location of office 1, office 2 from the 1st sheet.

how do i get the range of cells between office 1 and office 2 on sheet2?

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
referencing crystal report Hemant_india[_2_] Excel Programming 1 September 7th 06 07:11 AM
Import A Crystal Report into Excel Kris_Wright_77 Excel Programming 1 November 7th 05 12:58 PM
Cleaning up data from Crystal Report Leslie Coover Excel Worksheet Functions 4 August 24th 05 03:27 PM
Exporting data from Crystal Report to Excel - Need soln Aniyan_Remo Excel Programming 0 June 29th 05 10:29 AM
Regarding Crystal Report in Visual Basic 6.0 ElanKathir .S.N Excel Programming 0 May 22nd 04 07:00 AM


All times are GMT +1. The time now is 06:23 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017