Problem with loop

**Dedaluss** · 02-23-2014, 04:18 PM

I am new to VBA in Excel and need help in looping. I have different data from a sheet "PakkeIndtag" that I need to copy to different cells in other sheet "Data". My loop works almost perfectly. One thing I can't find out is how to jump over row 46 which is in the end of mu loop.If you look at the uploaded picture 1, you can see that I need to come over row 46 then it repeats all over again. The next yellow row will come at row 89 and so on, and so on, every 43 rows. Everything in-between yellow rows is the same as shown on the image.

My code is as follows

Please Login or Register  to view this content.

I hope somebody can help me with this problem

**TMS** · 02-23-2014, 05:25 PM

What would you have us do with a picture of a worksheet?

If it were my call, I'd move the subtotal(s) from their location in-line to the right hand side perhaps on the last row of the Sunday block.

Regards, TMS

**watersev** · 02-23-2014, 06:34 PM

hi Dedaluss, welcome to Excelforum,

option basing on the code provided (not tested due no sample file have been presented)

Please Login or Register  to view this content.

**Dedaluss** · 02-24-2014, 01:31 AM

Hi watersev,

thx for quick reply. I have to disappoint you but code you provided those not work. Maybe it would be easy if I upload portion of the file i'm working on, so you can try it out.

Best Regards
Dedaluss

**watersev** · 02-24-2014, 10:30 AM

please check attachment, press Run button or run code in Module 2

**Dedaluss** · 02-24-2014, 12:27 PM

Hi Watersev

You've done it. It works perfectly. Now do you think that i could take same code, copy it, and use it like this one, just to take data from other sheets and put it on same Data sheet?

I appreciate all your help. Please tell me if I have added reputation on to your account. This was my first reply with problem solved

Best regards
Dedaluss

**watersev** · 02-24-2014, 05:48 PM

I can't answer your question. The easiest way to check that is to use this code on a different sheet of the file.

PS. Re reputation: it was successful

**Dedaluss** · 02-25-2014, 12:17 AM

Thx a lot
PROBLEM SOLVED

Best Regards
Dedaluss

Problem with loop

LinkBack

Thread Tools

Rate This Thread

Display

Problem with loop

Re: Problem with loop

Re: Problem with loop

Re: Problem with loop

Re: Problem with loop

Re: Problem with loop

Re: Problem with loop

Re: Problem with loop

Thread Information

Users Browsing this Thread

Similar Threads

Vlookup problem in a loop with cell property and variable cell problem (long title sry)

[SOLVED] Loop inside a loop problem!

Loop problem

For Each Next Loop Problem

Problem adding charts using Do-Loop Until loop

Bookmarks

Bookmarks

Posting Permissions