Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 27th 05, 08:11 PM posted to microsoft.public.excel.misc
Cody
 
Posts: n/a
Default Transfer data from one sheet to another

Did I stump you guys? This is a hard one!

Here is the senario:

Worksheet one has a cell with a drop down menu with the numbers 1-10 in it.
Below the drop down menu are two columns labled 'account number' and 'method'
each with many fields available for info below them.

Worksheet 2 is a database. It has many columns labled 'account number', '
method', 'date', 'cycle' etc. The cycle field is what contains the numbers
1-10 of the previous worksheet.

I need a way of making it so that when I choose 1-10 from the dropdown menu
on the first sheet, that it reads the 'cycle' list from the second sheet and
finds all that match and then transfers the 'account number' and 'method' of
the ones that match back to the first sheet and places them in the
appropriate columns. This is a hard one and any suggestions are so very much
appreciated.
--
Cody

  #2   Report Post  
Old November 28th 05, 02:36 AM posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default Transfer data from one sheet to another

Hi!

Did I stump you guys? This is a hard one!


Not really! (on both)

It's the way you want to return the data that makes it a PITA. In last
nights post you only wanted a single account number. So, I'm guessing you
want the "pulled" data table to look like this:

Act No.....Data1.....Data2.....Data3
11111......aaaaa......1a1b1.....xxxx
.................ababa......2ab2a.....zzzz
.................babbc......3b3a3.....yyyy

If you only had a few columns of data and wanted to extract it to a database
"style" table:

Act No.....Data1.....Data2.....Data3
11111......aaaaa......1a1b1.....xxxx
11111......ababa......2ab2a.....zzzz
11111......babbc......3b3a3.....yyyy

It's a piece of cake! (depending on how much data you have to "search" and
how much data needs to be extracted)

The other alternative is a pivot table.

Biff

"Cody" wrote in message
news
Did I stump you guys? This is a hard one!

Here is the senario:

Worksheet one has a cell with a drop down menu with the numbers 1-10 in
it.
Below the drop down menu are two columns labled 'account number' and
'method'
each with many fields available for info below them.

Worksheet 2 is a database. It has many columns labled 'account number', '
method', 'date', 'cycle' etc. The cycle field is what contains the
numbers
1-10 of the previous worksheet.

I need a way of making it so that when I choose 1-10 from the dropdown
menu
on the first sheet, that it reads the 'cycle' list from the second sheet
and
finds all that match and then transfers the 'account number' and 'method'
of
the ones that match back to the first sheet and places them in the
appropriate columns. This is a hard one and any suggestions are so very
much
appreciated.
--
Cody




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
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
enter data on 1 sheet and make it enter on next avail row on 2nd s Nadia Excel Discussion (Misc queries) 27 September 9th 05 03:39 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Append the data given in diff sheets of an Excel File to one sheet sansk_23 Excel Worksheet Functions 3 May 10th 05 02:00 AM
populate cells with data from another sheet Pepe_abu Excel Worksheet Functions 0 January 15th 05 08:51 AM
Automatic cell increment with data from sheet 1 to sheet 2 Big G Excel Worksheet Functions 2 December 20th 04 05:59 PM


All times are GMT +1. The time now is 09:26 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