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: 85
Default pulling in a table with formulas

I have a worksheet createed that has a bunch of formulas in it. It is saved
in it's own file.

Standing on its own, the formula is all junk, because there is no data to
count and such.

I want to create a macro that will put this table into a worksheet that has
the data and have all of the formulas work.

This will be a monthly report counting empoloyees and complaints. The
reason I want to have the table seperate is changes can be made more readily
to the table than the macro.

Is this possible, how will I do it?
 
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
Excel formulas pulling from another worksheet changes when sorted CC Excel Worksheet Functions 1 February 4th 09 06:26 PM
formulas pulling data from other worksheets RogerB Excel Discussion (Misc queries) 0 February 15th 08 07:35 PM
Spreading formulas down the workbook while pulling from 2nd workbo EA4Life Excel Discussion (Misc queries) 3 July 24th 07 07:58 PM
Formulas pulling from other tables dicko1 Excel Worksheet Functions 0 June 21st 07 12:10 AM
not pulling down formulas _______Tim_______ Excel Programming 3 August 24th 03 05:48 PM


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