software

Hello,

I've created an Adv. Filter that copies data from Sheet2 to Sheet3
(headers included), the issue is that I would like to give the ability
to the user to select which record from the possible multiple that
populated from the Adv. Filter.

Example user clicks column quot;Aquot; (quot;Datequot;, Sheet3) and on the record / ROW
he or she is needs to be populate back to Sheet1 for editing.

I do have a “unique record” tie this all together which date amp; time
(merge, column quot;Fquot; as text) that would be like my lookup unique record,
but I simple cant think of a way to get macro to run based on position,
or hyperlink, checkbox to make this work, any ideas.

Any help is appreciated!--
Fable------------------------------------------------------------------------
Fable's Profile: www.excelforum.com/member.php...foamp;userid=2185
View this thread: www.excelforum.com/showthread...hreadid=500742
Hi Fable,

You may have solved this issue yourself (or by reposting) by now but
anyway...

re quot;I've created an Adv. Filter that copies data from Sheet2 to
Sheet3quot;
I have never been able to get an advanced filter to copy data from one
sheet to another so I'm curious, what version of Excel are you using?

To allow them to select amp; copy one or multiple rows for pasting back to
sheet1, have a look at:
www.j-walk.com/ss/excel/tips/tip36.htm.

You could incorporate the macro on the above page into your workbook,
get the users to select the complete row/s by holding down control as
they click on the row #'s to select the entire row, amp; then run this
macro.
NB: Test this on a copy of your workbook first amp; you will notice that
after you select the cell you want it pasted to, it pastes the rows in
the same layout as they were when copied (ie there may be blank rows
between them). This is just one possibility but may be a helpful
starting point.

hth,
Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...

Fable Wrote:
gt; Hello,
gt; I've created an Adv. Filter that copies data from Sheet2 to Sheet3
gt; (headers included), the issue is that I would like to give the ability
gt; to the user to select which record from the possible multiple that
gt; populated from the Adv. Filter.
gt; Example user clicks column quot;Aquot; (quot;Datequot;, Sheet3) and on the record / ROW
gt; he or she is needs to be populate back to Sheet1 for editing.
gt; I do have a “unique record” tie this all together which date amp; time
gt; (merge, column quot;Fquot; as text) that would be like my lookup unique record,
gt; but I simple cant think of a way to get macro to run based on position,
gt; or hyperlink, checkbox to make this work, any ideas.
gt; Any help is appreciated!--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=500742If you start from the other sheet you can copy advanced filtered results to
another sheet

www.contextures.com/xladvfilter01.html#ExtractWs

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

quot;broro183quot; gt; wrote in
message ...
gt;
gt; Hi Fable,
gt;
gt; You may have solved this issue yourself (or by reposting) by now but
gt; anyway...
gt;
gt; re quot;I've created an Adv. Filter that copies data from Sheet2 to
gt; Sheet3quot;
gt; I have never been able to get an advanced filter to copy data from one
gt; sheet to another so I'm curious, what version of Excel are you using?
gt;
gt; To allow them to select amp; copy one or multiple rows for pasting back to
gt; sheet1, have a look at:
gt; www.j-walk.com/ss/excel/tips/tip36.htm.
gt;
gt; You could incorporate the macro on the above page into your workbook,
gt; get the users to select the complete row/s by holding down control as
gt; they click on the row #'s to select the entire row, amp; then run this
gt; macro.
gt; NB: Test this on a copy of your workbook first amp; you will notice that
gt; after you select the cell you want it pasted to, it pastes the rows in
gt; the same layout as they were when copied (ie there may be blank rows
gt; between them). This is just one possibility but may be a helpful
gt; starting point.
gt;
gt; hth,
gt; Rob Brockett
gt; NZ
gt; Always learning amp; the best way to learn is to experience...
gt;
gt; Fable Wrote:
gt;gt; Hello,
gt;gt; I've created an Adv. Filter that copies data from Sheet2 to Sheet3
gt;gt; (headers included), the issue is that I would like to give the ability
gt;gt; to the user to select which record from the possible multiple that
gt;gt; populated from the Adv. Filter.
gt;gt; Example user clicks column quot;Aquot; (quot;Datequot;, Sheet3) and on the record / ROW
gt;gt; he or she is needs to be populate back to Sheet1 for editing.
gt;gt; I do have a quot;unique recordquot; tie this all together which date amp; time
gt;gt; (merge, column quot;Fquot; as text) that would be like my lookup unique record,
gt;gt; but I simple cant think of a way to get macro to run based on position,
gt;gt; or hyperlink, checkbox to make this work, any ideas.
gt;gt; Any help is appreciated!
gt;
gt;
gt; --
gt; broro183
gt; ------------------------------------------------------------------------
gt; broro183's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30068
gt; View this thread: www.excelforum.com/showthread...hreadid=500742
gt;
Hi Peo,
Ahh, I see...
Thanks, another little gold mine from Debra :-) that will come in
handy.

Cheers
Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...Peo Sjoblom Wrote:
gt; If you start from the other sheet you can copy advanced filtered results
gt; to
gt; another sheet
gt; www.contextures.com/xladvfilter01.html#ExtractWs
gt;
gt; --
gt; Regards,
gt; Peo Sjoblom
gt; Northwest Excel Solutions
gt; Portland, Oregon
gt;
gt; quot;broro183quot; gt;
gt; wrote in
gt; message ...
gt; gt;
gt; gt; Hi Fable,
gt; gt;
gt; gt; You may have solved this issue yourself (or by reposting) by now but
gt; gt; anyway...
gt; gt;
gt; gt; re quot;I've created an Adv. Filter that copies data from Sheet2 to
gt; gt; Sheet3quot;
gt; gt; I have never been able to get an advanced filter to copy data from
gt; one
gt; gt; sheet to another so I'm curious, what version of Excel are you
gt; using?
gt; gt;
gt; ...
gt;--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=500742
Sorry for the delay in response Rob, I was traveling between Mexico and
Argentina and in meeting all week. Any how, I did not see Peo posting
prior (Thanks Peo) but I was able to solve my problem with the code
below. In a nut shell the user click in Col. B (yellow Boxes) and it
will import that record. The only quot;side effectquot; is that the adrress is
value is place in the yellow box, which is really not a problem since
with a little make up you can fix it (conditional formatting) or a code
that clears the B Col. (Range). Hope this help as it did for me.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
Application.ScreenUpdating = False
Cancel = True
Dim IntersectRange As Range
Set WatchRange = Range(quot;B10:B5000quot;)
Set IntersectRange = Intersect(Target, WatchRange)
If IntersectRange Is Nothing Then
MsgBox (quot;Select an option from the yellow high lightsquot;)
Else
Target = quot;Cquot; amp; ActiveCell.Row amp; quot;:ADquot; amp; ActiveCell.Row
Range(Target).Select
Selection.Copy
Range(quot;C12quot;).Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range(quot;B10quot;).Select
End If
Call EXEC_IMPORT
Sheets(4).Select
Range(quot;D15quot;).Select
Sheets(3).Select
Application.ScreenUpdating = True
End Sub--
Fable------------------------------------------------------------------------
Fable's Profile: www.excelforum.com/member.php...foamp;userid=2185
View this thread: www.excelforum.com/showthread...hreadid=500742
Hi Fable,
I'm pleased you were able to solve your problem :-)

Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=500742