Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selct and Copy data from differant rows at the same time
Is this possible? Say you had data in row 1 , coloumns A thru G Thn Row 2 only has data in Columns F and G That belongs to the data in columns A thru E You search for a value in column F find it . Now you want to copy the value you found colum F and G And the row data columns A thru E Paste all this to another worksheet on one line Emp # Name '''''''''' Dept# '''''Shift'''Hire Date'''''''''Jobcode''''''Jobtitle 121 '''''John Doe'''''' 2525 '''''''''' A''''''07/08/06'''''''' 56254 ''''''''''' Job1 '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''''''''''''''''''' 25648 ''''''''''''Job2 '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''''''''''''''''''' 45465 ''''''''''''Job3 So the search string finds the jobcode 45465 The results would be pasted like this to a new sheet Emp # Name '''''''''' Dept# '''''Shift'''Hire Date'''''''''Jobcode''''''Jobtitle 121 '''''John Doe'''''' 2525 '''''''''' A''''''07/08/06'''''''' 45465 ''''''''''' Job3 Can this be done? Thanks Charles -- mrdata ------------------------------------------------------------------------ mrdata's Profile: http://www.excelforum.com/member.php...o&userid=17899 View this thread: http://www.excelforum.com/showthread...hreadid=561434 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
selct and Copy data from differant rows at the same time
The simple answer is "yes". in trying to give a more complete answer it would be helpfull to have a better picture of what you are trying to achieve. Including how the data gets on the first sheet. The answer to this could greatly simplify (or complicate) the issue regards -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=561434 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
selct and Copy data from differant rows at the same time
Thanks for responding the attached example will better explain what i a trying to do. Thanks Charle +------------------------------------------------------------------- |Filename: Copy of Pre-Bid2.zip |Download: http://www.excelforum.com/attachment.php?postid=5034 +------------------------------------------------------------------- -- mrdat ----------------------------------------------------------------------- mrdata's Profile: http://www.excelforum.com/member.php...fo&userid=1789 View this thread: http://www.excelforum.com/showthread.php?threadid=56143 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting data from 2 differant colums | Excel Worksheet Functions | |||
Auto Populate Data from cell to another sell in differant sheets | Excel Discussion (Misc queries) | |||
Selct and edit sheet | Excel Discussion (Misc queries) | |||
VBA Protect and NOT be able to selct locked cells | Excel Programming | |||
Printing differant rows | Excel Programming |