LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Caluculating and Posting to a summary sheet

Hello,

This is my first time to use this tool so I hope I don't sound like an
idiot. I really need some help so I guess I will try it

I have a list of 158 accounts that I want to perform a financial
calculation on. The data needed for the calculation is in a table and I have
linked it to a drop down box. So when I pick an account in the drop down, an
offset command is used to populated the data in my model and calculate the
metric I need. What I am looking for is a macro that will run through all 158
and post them to a summary sheet. SInce the ouput is based on a drop dwon, I
think the first ouput sumary would need to be pasted as a value, but I am not
sure. I also don't know how to make the ouputs paste one below the other. I
would really appreciate any help you could give me.

Thank You

To Old to learn
--
Thanks
 
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
Help with locating values in cells and caluculating Yossy Excel Worksheet Functions 1 November 13th 08 05:57 PM
Generate sheet names from list, assign data to summary sheet. [email protected][_2_] Excel Programming 4 June 20th 07 09:17 PM
How can i copy data from a tabbed working sheet to a summary sheet StephenF Excel Discussion (Misc queries) 1 March 15th 07 03:40 PM
the owner of posting should be able to delete the posting Mahendra Excel Discussion (Misc queries) 7 August 8th 05 07:21 PM
posting data from a form to a sheet depending on month melchead Excel Programming 3 September 27th 03 04:08 AM


All times are GMT +1. The time now is 02:56 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"