Auto copy entire row, possibly using IF function

[mcbogel]

Hi

I am stuck with a little problem. I have a window cleaning business and am trying to get excel to automate my routes.

What I have now:

Tab1 (Sheet:Costumers)

A B C D E F G H I J K L M N O P Q 1 # Streetname Street# Town Zip code Name Phone1 Phone2 Total Price Per month Text to be shown on costumers bill1 Price1 Text to be shown on costumers bill2 Price2 Notes Frequency Week 2 1 Fake Boulevard 109 Imagination city 71906 Henry von Luftballoon 555-564-658 $20 $20 Window cleaning $20 1 month 1, 5, 10, 15, 20, 25, 30, 35, 40, 45, 50 3 2 Easy Street 112 Squaresville 98621 Karen Berg 555-654-235 $50 $25 Window cleaning $50 2 months 1, 10, 20, 30, 40, 50 4 3 Evergreen Terrace 742 Springfield N/A Homer Simpson 555-651-687 $110 $110 Window cleaning $25 Removing spiderwebs $85 1 month 1, 5, 10, 15, 20, 25, 30, 35, 40, 45, 50 <tbody> </tbody>

<tbody>
</tbody>

At the moment I find my routes by using the filter function. I choose what week I am currently in and I receive a list.




What I want:

Tab1 (Sheet:Costumers)
Tab2 (Sheet:January (week1-5))
Tab3 (Sheet:February(week6-9))
Tab4 (Sheet:March (week10-14))
etc. etc. until I have 12 months and 52 weeks.


I want to enter my costumers information into the "Costumers" sheet and have them automatically transfer to the month tab in which they belong.


My attempt at this have been to use the IF, ISNUMBER and SEARCH function.

I have used this funtion: =IF(ISNUMBER(SEARCH(1,R2)), "1", IF(ISNUMBER(SEARCH(2,R2)), "2", IF(ISNUMBER(SEARCH(3,R2)), "3", IF(ISNUMBER(SEARCH(4,R2)), "4", "error"))))


What I want the function to do:

Tab2 (Sheet:January (week1-5))
=IF(ISNUMBER(SEARCH(1,R2)), [copy Tab1 (Sheet:Costumers) row1 and paste it into Tab2 (Sheet:January (week1-5)) row1] , IF(ISNUMBER(SEARCH(2,R2)), [copy Tab1 (Sheet:Costumers) row1 and paste it into Tab2 (Sheet:January (week1-5)) row1], IF(ISNUMBER(SEARCH(3,R2)), [copy Tab1 (Sheet:Costumers) row1 and paste it into Tab2 (Sheet:January (week1-5)) row1], IF(ISNUMBER(SEARCH(4,R2)), [copy Tab1 (Sheet:Costumers) row1 and paste it into Tab2 (Sheet:January (week1-5)) row1], "error"))))

Is this possible to do this using just functions or do I need to use VBA?


Thanks in advance for the help. If I haven't explained my request well enough please let me know.

Daniel

 

[mcbogel]

Just gonna bump this up a bit

 

[mcbogel]

anyone?

 

[mcbogel]

still no one?