LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 85
Default Pulling table into new worksheet

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
Pivot table pulling wrong value RestlessAde Excel Discussion (Misc queries) 2 February 16th 11 07:17 PM
Pulling data from another worksheet Susan Excel Discussion (Misc queries) 2 June 20th 08 06:53 PM
NEED HELP WITH PULLING IN ONLY NECESSARY DATA FROM A TABLE lenubian Charts and Charting in Excel 1 June 13th 08 12:10 AM
Pulling information from one worksheet into another Monika Excel Worksheet Functions 1 November 16th 06 11:18 PM
Pulling from a table to make a timeline KwaiLo Excel Worksheet Functions 1 May 5th 06 03:28 PM


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