VBA for copy data only if current week number changes

**amitmodi_mrt** · 04-08-2016, 02:04 AM

Hi, I need help in a vba code that can copy data from one cell to another cell only if current weeknum get change.

I have data in cell K3:k350, which needs to be copied to cell J3:K350 ONLY if current weeknum gets change.

Thanks in advance..

**sktneer** · 04-08-2016, 03:05 AM

You may try something like this.....

Sub CopyDataBasedOnWeekNum()
If WorksheetFunction.WeekNum(Date) <> WorksheetFunction.WeekNum(Date - 1) Then
   Range("K3:K350").Copy Range("J3")
End If
End Sub

VBA for copy data only if current week number changes

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

VBA for copy data only if current week number changes

Re: VBA for copy data only if current week number changes

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Set PivotTable Filter to Current Day, Current Week, Current Month, or Current Year

UserForm with that shows Previous Week Data and allows you to update current week

[SOLVED] Highlight current week number.

Chart previous week data as grouped and current week as ungrouped

getting the current week number formula

Sum based on Current Week, Previous Weeks vs. Current Week Forward

Week Number and current Hour

Bookmarks

Bookmarks

Posting Permissions