Populate data until specific row criteria is reached.

**ollander88** · 03-26-2012, 12:53 PM

Hello,

I am trying to edit a VBA module so that it populates data from one sheet to another but only until a specific row is reached.

For example, I have table with a column that contains various dollar amounts and a row at the bottom labeled TOTALS that sums that entire column. But, when I run the macro I only want it to copy the values above the total amount. I do not want it to include the actual total amount. Is this possible?

Thank you for your help!

**dilipandey** · 03-26-2012, 12:56 PM

Hi Ollander88,

Welcome to the forum.

yes this is achievable.. you can have include something like below in your code:-

Please Login or Register  to view this content.

would suggest you to the post the sample file with code to help you better. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Dennis7849** · 03-26-2012, 12:59 PM

The code looks like this

Please Login or Register  to view this content.

**ollander88** · 03-26-2012, 01:22 PM

Thank you for all your responses. I guess I should have included the original code. How would I incorporate it into the following:

Please Login or Register  to view this content.

Thank you!

**dilipandey** · 03-26-2012, 01:25 PM

Hi Dennis7849,

Could you post the file containing this code... thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**ollander88** · 03-26-2012, 01:39 PM

DILIPandey,

When I tried to incorporate your code, the data continue to copy itself continuesly. This is the code I am working with.

Please Login or Register  to view this content.

**dilipandey** · 03-26-2012, 01:41 PM

Hi Ollander,

Replace line 3 of your code with following. thanks

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>

**ollander88** · 03-26-2012, 01:54 PM

DILIPandey,

That doesn't seem to work. Attached is the excel file.

**dilipandey** · 03-26-2012, 02:17 PM

Hi Ollander,

See the attached file and let me know if the macro works fine. thanks.

Regards,
DILIPande

<click on below 'star' if this helps>

**ollander88** · 03-26-2012, 03:43 PM

DILIPandey,

That code works fine; although the range is fixed. I would like it to be dynamic as there is the possibility of the data exceeding a fixed range of rows. Hence why I asked if it would be possible to have the data stop populating once it reaches the row that contains the text "Totals" in it. Is that still possible? I appreciate your help.

**dilipandey** · 03-27-2012, 01:15 AM

Hi ollander88,

See the revised solution.
Now it will copy the range till the Totals.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Paul** · 03-27-2012, 01:42 AM

Ollander,

In the future please be sure to wrap your code within [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags. Also, don't quote entire posts as it just clutters the thread.

Thank you.

**ollander88** · 03-27-2012, 09:41 AM

When I run the macro, the 'Run-time error 1004 Application-defined or object definer error' dialog box appears.

**dilipandey** · 03-27-2012, 01:23 PM

Hi ollander88,

Macro is running fine on my system.

Can you run it in break mode and share the outcome.. Alt+F11, go to the code, press F8 and again and again.. see the outcome and let me know where it has given error. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Populate data until specific row criteria is reached.

LinkBack

Thread Tools

Rate This Thread

Display

Populate data until specific row criteria is reached.

Re: Populate data until specific row criteria is reached.

Re: Populate data until specific row criteria is reached.

Re: Populate data until specific row criteria is reached.

Re: Populate data until specific row criteria is reached.

Re: Populate data until specific row criteria is reached.

Re: Populate data until specific row criteria is reached.

Re: Populate data until specific row criteria is reached.

Re: Populate data until specific row criteria is reached.

Re: Populate data until specific row criteria is reached.

Re: Populate data until specific row criteria is reached.

Re: Populate data until specific row criteria is reached.

Re: Populate data until specific row criteria is reached.

Re: Populate data until specific row criteria is reached.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions