Problem to put table row values (after filtering) into other form

**NatanZ** · 11-03-2011, 05:59 AM

Hey guys,

I got a little problem.

I have an Excel workbook with 2 worksheets.
The first one contains a data-table (Name, Phone, Address) with fast filter - I filter it untill I get only 1 result.
The second sheet should take the result an make it look like a form:
Name: NAME
Phone: PHONE
Address: ADDRESS

I've tryed with ="A2" on the Name cell, but when filter result on line e/x 5, yet form shows A2.

I hope you understood.

Any help pls.

**watersev** · 11-03-2011, 06:19 AM

hi, NatanZ, can you post sample workbook showing original data (5-10 rows is enough) and expected result?

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

**NatanZ** · 11-03-2011, 06:28 AM

I've attached.
Try filter abe and youll understand.
NOTE THERE ARE 2 WORKSHEETS

**watersev** · 11-03-2011, 06:50 AM

will solution with macro be acceptable for you?

**NatanZ** · 11-03-2011, 10:09 AM

Originally Posted by watersev

will solution with macro be acceptable for you?

I hope so, please post your solution.

Many thanks.

**watersev** · 11-03-2011, 11:29 AM

please check attachment, if it suits your needs

**NatanZ** · 11-04-2011, 03:58 AM

Originally Posted by watersev

please check attachment, if it suits your needs

Hey, it works like a charm on the sample you attached, but I couldn't figure it out.
I'll post here the fixed thing I need with hope you'll help me also.

NOTE THERE ARE 2 WORKSHEETS
NOTE THERE IS A FASTFILTER ON THE FIRST ROW
NOTE THIS FILE CONNECTED TO ACCESS DB

MANY THANKS MAN!!!

**watersev** · 11-04-2011, 04:36 AM

please check attachment, code added, I've made some changes to it as per your data layout but I did not test it.

**NatanZ** · 11-04-2011, 07:24 AM

Originally Posted by watersev

please check attachment, code added, I've made some changes to it as per your data layout but I did not test it.

THANK YOU SO MUCH!

You saved my day

SOLVED

Problem to put table row values (after filtering) into other form

LinkBack

Thread Tools

Rate This Thread

Display

Problem to put table row values (after filtering) into other form

Re: A little help with table-form thingies

Re: A little help with table-form thingies

Re: A little help with table-form thingies

Re: A little help with table-form thingies

Re: Problem to put table row values (after filtering) into other form

Re: Problem to put table row values (after filtering) into other form

Re: Problem to put table row values (after filtering) into other form

Re: Problem to put table row values (after filtering) into other form

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions