worksheet to worksheet

[coachdp3]

Can I send an Excel form to someone to complete the formula I need done? I will pay for this if needed but everytime I ask mrexcel for help, the response doesn't work as planned. Please provide e-mail to send file and direction. Basically I want to take data from a weekly worksheet and at weeks end, hit a macro button that would save the weekly info to another workbook called monthly. This monthly form would be an ongoing form for the entire year. Thx for your help.

 

[Dryver14]

If you are not quite getting the answers you are looking for it may be because you are not quite explaining the situation or indeed it is not do able. There should be no need to leave the board as most on here spend more time than you can pay for trying to solve the problem.

Each one is a challenge to be conquered

Ensure you fully understand your self what you are seeking before posting

Whilst some on here are embarressingly bright they are not mind readers.

 

[coachdp3]

OK, ill do my best to explain. I have 2 worksheets. The first titled "Weekly" the second titled "Monthly". We track info. each week and log this info by date in the weekly worksheet. At the end of each week, I have to manually enter this info into the monthly worksheet under the correct month. Example: all info in the weekly is dated for February 1st - 7th. I would then copy all Feb.1-7 info and re-enter into the monthly worksheet under Feb. Then I would go back to the weekly worksheet and erase all Feb 1-7 data so I can then enter Feb 8-14 data at end of next week. Id like to create a macro button that performs this task each week. Is this do-able?

 

[Dryver14]

yes

we would need to know the following

start row for each row on weekly sheet, how you want it placing in monthly sheet,

 

[Dryver14]

the best bet is to see both pages so we know how many columns etc

 

[coachdp3]

Weekly and Monthly Worksheet Cell Column:
A = Numbered Row
B = Date
C = Vender Name
D = Service Provided
E = Invoice Number
F = Amount of Bill
G = Fax
H = Re submit
I = Charge to:

Range for Weekly Worksheet is: B3:I52

Range of the Monthly Worksheet by Month is:

Jan - B2:I86
Feb - B89:I172
Mar - B175:I258
Apr - B261:I344
May - B347:I430
Jun - B433:I516
Jul - B519:I602
Aug - B605:I688
Sep - B691:I774
Oct - B777:I860
Nov - B863:I946
Dec - B949:I1032

If you need the actual file, I can send to you if you give an email addres to send them to. When I try to attach the file, it doesnt work.

Thanks for your Help.

If you have a Regal Cinemas near you, i would like to comp you and your family a free movie for helping me out.

 

[Dryver14]

how is the date formatted in column B and what happens to the weekly info once you have the information on the monthly sheet?

 

[coachdp3]

The date is format is : 03/01/11

The info going from the weekly to the monthly is broken down by catagory in Column I and returned as amount in Column F. I already have this formula set up on the page in Columns J-M on the monthly worksheet so once the info is transfered from weekly to monthly, cells J-M will take that info and organize as I need.

 

[Dryver14]

what I meant is does the next week go below that week also or do you clear the info for the following week?