Macro - copy weekly data to a week number

**Dennikim** · 04-02-2008, 06:57 AM

Hi,

i try to copy data which are generated on a daily basis to a different worksheet into the row with week No. , but it needs to be checked the week number. It depends on which week number the data generated, then the data have to be copied to a different row.

4-Apr-08 14 WeekNo.
11-Apr-08 15
18-Apr-08 16
25-Apr-08 17
2-May-08 18

My recorded macro:

Please Login or Register  to view this content.

Hope you can help me

**royUK** · 04-02-2008, 07:07 AM

Please read the Forum Rules and use Code tags where appropriate

**Dennikim** · 04-10-2008, 10:47 AM

Hello Roy,

the provided links are not working. Maybe i should be more precise what i exactly want:

I use a macro which runs on a daily basis to collect numbers from a database.
The result should be copied to to a different TAB based on the week number.

E.a.:
Execute week No 12: The result should be copied to the row with week number 12 , execute week No. 13 -> copy to row with week no. 13 and so on.

Hope this makes it more clearer.

Thanks.

Macro - copy weekly data to a week number

LinkBack

Thread Tools

Rate This Thread

Display

Macro - copy weekly data to a week number

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions