Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default forecasting sheet - macro required

Hi,
I need some help with this sheet. I need to write a macro for changing the units and prices according to inputs in table M5:N8 with the intervals selected in table J5:J9. The units and prices from n24 onwards will be calculated according to the growth rate specified. Also if one enters"R" the macro will calculate regression accordingly. This will translate into forecast revenues according to the inputs.
Attached Files
File Type: zip Forecasting test.zip (10.8 KB, 64 views)
  #2   Report Post  
Junior Member
 
Posts: 19
Default

Quote:
Originally Posted by rahulk912 View Post
Hi,
I need some help with this sheet. I need to write a macro for changing the units and prices according to inputs in table M5:N8 with the intervals selected in table J5:J9. The units and prices from n24 onwards will be calculated according to the growth rate specified. Also if one enters"R" the macro will calculate regression accordingly. This will translate into forecast revenues according to the inputs.
Hi,

I don't fully understand what you are trying to achieve.

A couple of examples based on your data will help.

Educo
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro required please Dr Hackenbush Excel Discussion (Misc queries) 4 February 10th 10 09:29 AM
MACRO REQUIRED ZEESHAN Excel Discussion (Misc queries) 1 August 21st 09 01:28 PM
Required data in one sheet Junaid Excel Worksheet Functions 4 November 26th 08 11:18 AM
How can I transfer a required data from sheet 1 to sheet 2 automat Malik Nadeem Excel Discussion (Misc queries) 6 October 24th 07 11:48 AM
vba macro required ? Peter O'Leary Links and Linking in Excel 1 April 14th 05 11:49 PM


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"