M
Matt
Hello,
I am creating a sales tracker to calculate weekly, monthly and yearly
sales. There are 5 Week Tabs, one Month To Date tab, and then a Year
to date tab which has a calendar design which i want to only hold the
final monthly data.
The way i would like to import this is to import the values by clicking
on a command button which says publish and it will import the current
monthly totals into the YTD range, on the YTD tab.
The commands i keep trying do not work, i tryed a few variations:
(curMonth is a string which returns the range to be used for the YTD
tab)
(curMTD is the range which contains the data on the MTD tab)
---------------------------------------------------------------------------------------------
YTD.Range(curMonth).value = MTD.Range(curMTD).Value
I have also tryed without YTD. and MTD. before range, and with
Sheets("YTD") and ("MTD")
These keep bugging for me and do not export to the range in the YTD
sheet.
Any suggestions or help would be greatly appreciated.
Thx.
Matt Titus
Waldorf MD
I am creating a sales tracker to calculate weekly, monthly and yearly
sales. There are 5 Week Tabs, one Month To Date tab, and then a Year
to date tab which has a calendar design which i want to only hold the
final monthly data.
The way i would like to import this is to import the values by clicking
on a command button which says publish and it will import the current
monthly totals into the YTD range, on the YTD tab.
The commands i keep trying do not work, i tryed a few variations:
(curMonth is a string which returns the range to be used for the YTD
tab)
(curMTD is the range which contains the data on the MTD tab)
---------------------------------------------------------------------------------------------
YTD.Range(curMonth).value = MTD.Range(curMTD).Value
I have also tryed without YTD. and MTD. before range, and with
Sheets("YTD") and ("MTD")
These keep bugging for me and do not export to the range in the YTD
sheet.
Any suggestions or help would be greatly appreciated.
Thx.
Matt Titus
Waldorf MD