# Extract Data from Multiple worksheets

1. ## Extract Data from Multiple worksheets

Hi. I have a work book w/ multiple worksheets with sales data.. for differnt
regions..who can i extract data that shows me which customer ordered 50 +

2. ## RE: Extract Data from Multiple worksheets

Hi I have setup a front sheet, using the offset with a combobox to select the
month
=OFFSET('2005 Budgets'!B5,,MonthCell-1)
=IF(MonthCell<12,OFFSET('2005 Budgets'!B5,,MonthCell),"Year end")

HTH
Frank

I could send you a working example?.

"Perry" wrote:

> Hi. I have a work book w/ multiple worksheets with sales data.. for differnt
> regions..who can i extract data that shows me which customer ordered 50 +

3. ## RE: Extract Data from Multiple worksheets

Assumed is the following:
1) There are 4 sheets containing the sales data: "Sales Data 1", "Sales Data
2" ... "Sales Data 4".
2) The name of the sheet to receive the results is "Results".
3) For each of the sales data sheets, the names of the customers start in
cell A2.
4) For each of the sales data sheets, the number of boxes sold are listed
adjacent to the customer names starting in cell B2.
4) The results are to be transfered to sheet "Results" starting in the
second row with customer names in column A and boxes sold in column B.

Sub ExtractData()
Dim ws1 As Worksheet, ws2 As Worksheet
Dim rng As Range
Dim c As Range, cc As Range
Dim i As Integer

Set ws2 = Sheets("Results")
Set cc = ws2.Range("B2")
Application.ScreenUpdating = False
For i = 1 To 4
Set ws1 = Sheets("Sales Data " & i)
Set rng = Range(ws1.Range("B2"), ws1.Range("B2").End(xlDown))
For Each c In rng
If c.Value >= 50 Then
cc.Value = c.Value
cc(1, 0) = c(1, 0)
Set cc = cc(2)
End If
Next c
Next i
Application.ScreenUpdating = True
End Sub

Regards,
Greg

"Perry" wrote:

> Hi. I have a work book w/ multiple worksheets with sales data.. for differnt
> regions..who can i extract data that shows me which customer ordered 50 +

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

## X vBulletin 4.1.8 Debug Information

• Page Generation 0.07616 seconds
• Memory Usage 8,859KB
• Queries Executed 16 (?)
Template Usage (30):
• (1)footer
• (1)forumrules
• (1)gobutton
• (3)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (3)postbit_legacy
• (3)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
Included Files (40):
• ./vbseo.php
• ./env.php
• ./vbseo/includes/functions_vbseo.php
• ./vbseo/includes/functions_vbseo_pre.php
• ./vbseo/includes/functions_vbseo_url.php
• ./vbseo/includes/functions_vbseo_createurl.php
• ./vbseo/includes/functions_vbseo_db.php
• ./vbseo/includes/functions_vbseo_vb.php
• ./vbseo/includes/functions_vbseo_seo.php
• ./vbseo/includes/functions_vbseo_misc.php
• ./vbseo/includes/functions_vbseo_crr.php
• ./vbseo/includes/functions_vbseo_cache.php
• ./vbseo/includes/functions_vbseo_hook.php
• ./vbseo/includes/functions_vbseo_startup.php
• ./includes/config.php
• ./global.php
• ./includes/class_bootstrap.php
• ./includes/init.php
• ./includes/class_core.php
• ./includes/functions.php
• ./includes/class_friendly_url.php
• ./includes/class_hook.php
• ./includes/functions_cforum.php
• ./includes/functions_bigthree.php
• ./includes/class_postbit.php
• ./includes/class_bbcode.php
• ./includes/functions_reputation.php
• ./includes/class_bootstrap_framework.php
• ./vb/vb.php
• ./vb/phrase.php
• ./packages/vbattach/attach.php
• ./vb/types.php
• ./vb/cache.php
• ./vb/cache/db.php
• ./vb/cache/observer/db.php
• ./vb/cache/observer.php
• ./includes/functions_notice.php
• ./includes/functions_prefix.php

Hooks Called (44):
• init_startup
• friendlyurl_resolve_class
• database_pre_fetch_array
• database_post_fetch_array
• global_bootstrap_init_start
• global_bootstrap_init_complete
• cache_permissions
• fetch_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• bbcode_parse_start
• bbcode_parse_complete_precache
• bbcode_parse_complete
• postbit_display_complete
• cache_templates
• template_register_var
• parse_templates
• notices_check_start
• notices_noticebit
• process_templates_complete
• memberaction_dropdown
• tag_fetchbit_complete
• forumrules