need help in copiyng the "entire coloum" macro.

**shiva_reshs** · 01-29-2013, 06:55 PM

Hello,

Please Login or Register  to view this content.

I have a pivot table with lots of header in it. I copy selected column based on its header from Pivot and copy in another sheet. I created this macro which search the header but i am not able to copy the entire column. I need help to create a macro which can search the header and copy the column value.

For Example, if column A3 has "Invoice Amount", then I need macro to search Invoice amount and copy the below the entire row from below. (I do not want to copy the header, just a cell value from below header till row 30.

Regards,
Shiva

**AlphaFrog** · 01-29-2013, 08:35 PM

Try this. Change the destination to suit.

Please Login or Register  to view this content.

**shiva_reshs** · 01-30-2013, 02:02 PM

Hi Alpha,

Code does the perfect job , But could you help me here to modify the "paste destination"?

Please Login or Register  to view this content.

The code above, helps to search the blank row and paste it, when it paste the data in "Summary - Qtr". Any help on this plz

Regards,
Shiva

**shiva_reshs** · 01-30-2013, 02:42 PM

I was able to do it with below code

Please Login or Register  to view this content.

However, how can I make it Exact search? I mean to say, when it search for Invoice amount , I want Excel to search the exact word, and not a matching word in some other sentence.
Regards,

**AlphaFrog** · 01-30-2013, 04:48 PM

Please Login or Register  to view this content.

**shiva_reshs** · 01-30-2013, 05:36 PM

Thanks, It worked.

Any help on how Can I have only value to be pasted instead of Formula or formats from Pivot Table?

I have added few columns with formula in it, next to Pivot table. When it searches the "invoices amount" and copy the entire row, it also copy the "#DIV/0!" (if any found) in the Summary - qtr sheet. I found below code, but does not seems to work. It still copy the #DIV/0! in summary sheet.

Please Login or Register  to view this content.

**AlphaFrog** · 01-30-2013, 06:03 PM

Please Login or Register  to view this content.

**shiva_reshs** · 01-30-2013, 06:54 PM

Perfect!!!! Thank you so much for your help!!!!

Regards,
Shiva

need help in copiyng the "entire coloum" macro.

LinkBack

Thread Tools

Rate This Thread

Display

need help in copiyng the "entire coloum" macro.

Re: need help in copiyng the "entire coloum" macro.

Re: need help in copiyng the "entire coloum" macro.

Re: need help in copiyng the "entire coloum" macro.

Re: need help in copiyng the "entire coloum" macro.

Re: need help in copiyng the "entire coloum" macro.

Re: need help in copiyng the "entire coloum" macro.

Re: need help in copiyng the "entire coloum" macro.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions