Copy from one worksheet into rows (days of week) on second spreadsheet.

**Sandy2976** · 10-13-2009, 09:33 AM

I have struggled for a day now searching and tweaking but I cannot figure this out.

Worksheet (Daily Sales) - daily input, copy to the worksheet (Weekly Sales), Monday through Saturday. The ranges copied are not consecutive. I am using If...then...else.

Please Login or Register  to view this content.

Thanks for any help. I have been away from excel for awhile would really appreciate any help.

Sandy2976

**DonkeyOte** · 10-13-2009, 10:18 AM

Perhaps you could try

Please Login or Register  to view this content.

**Sandy2976** · 10-13-2009, 11:23 AM

Thanks for your help. I tried running the code and I am getting Runtime error '13 Type mismatch on this portion of the code.

Please Login or Register  to view this content.

Sandy

**DonkeyOte** · 10-13-2009, 11:27 AM

The code is based on the following assumptions

1 - day of interest is stored in 'Daily Sales Record'!G3

2 - value in above cell is always one of: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday
(is this cell an actual date value formatted as dddd ?)

The error you are receiving is because the value in the cell specified in point 1 does not contain any of the values as specified in point 2.

**Sandy2976** · 10-13-2009, 12:32 PM

Thank you, works great.

Sandy

**royUK** · 10-13-2009, 12:32 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**Sandy2976** · 10-13-2009, 12:36 PM

I was wondering if it is possible to give a brief explanation of the code. I would like to understand it so if the need arises I will be able to create the code on my own.

Thanks,

Sandy