• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help weekly report

excel700

excel700

New Member
Good day ,

How are you Gents ,
thanks for this exceptional website...
I have attached my excel sheet and I need help on it … many thanks for your time to help in advance

I'm just new in vba


--------
for ex.
if C1=H1 then
Check Week Archive Sheet
and check if the there is data in week47 column if Yes give Msg already there is data in current week do you want copy if yes copy if no do nothing
if there is no data yet in week 47 then do this calculation
Sheet(week)c3 up to end down and (-) week46 in week archive to see the difference then put the result in b3 up to end down in week sheet
and we need to do loop here for 52 week then if we reach to end we have to delete all week history to start new year
 

Attachments

Thangavel said:
After copy what you wanted to do?
Click to expand...

Thanks my friend for time and help …. just copy under the current week no in Week archive but if there is data give msg to recopy or not and keep it until we reach to week 52 and we can delete all weeks data and start from the beginning and in the same time see the difference between the year to end data in pervious week which is for ex . week46 in week archive sheet and year to end of the current week which is week 47 and we have put the result it in count by month of current week which is b3:B8 in this example in week sheet
 
Any one can help with this ... Mr. Thangavel is busy now with something else .... thanks in advance for any one could help
 
You must log in or register to reply here.
Back
Top