Required vb coding for display data

[dswara1829]

Dear Sir,

When i enter Category in Form sheet all data should be display from data sheet.

Regards,
Dattatray Kumbhar

[torachan]

I have attached an alternative approach - I have merely placed your table in one of my recent apps.
Looking through your code it was never going to work - you had got in a tangle as to which sheet you were filtering - look at your 'With' ....'End With'

[dswara1829]

I have attached an alternative approach - I have merely placed your table in one of my recent apps.
Looking through your code it was never going to work - you had got in a tangle as to which sheet you were filtering - look at your 'With' ....'End With'

Thanks for you suppport ,But if i want to Copy Mobile and email i am unable to copy.

[torachan]

Alter the column widths in the code, if zero that column does not show.
For replies please use the 'Post quick reply' - quoting previous post only clutters the page with unnecessary words.

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Code for macro

Please Login or Register  to view this content.

[jindon]

dswara1829,
To From sheet code module
Are you sure about your pagesetup line?

Please Login or Register  to view this content.