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