View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Automatically update spreadsheet from another spreadsheet

I'm not sure what 8 sheets on one spreadsheet means, but the macro below will
parse all data into rows of 10s (change to suit your needs) and create new
sheets for the results of each parse:

Sub PaserIntoHundreds()
Set sh = ActiveSheet
For i = 1 To 991 Step 10
Set rng = sh.Cells(i, 1).Resize(10, 1).EntireRow
Set sh1 = Worksheets.Add(after:=Worksheets(Worksheets.Count) )
rng.Copy sh1.Range("A1")
' optional
'sh1.move
Next
End Sub


I may be way off target here. Post back if you need something different.


Regards,
Ryan--

--
RyGuy


"Cindy" wrote:

I have 8 sheets on one spreadsheet and I need to create individual
spreadsheets for each of the 8 sheets. The problem is I need the information
I put into the spreadsheet with all 8 sheets attached to update on the
individual spreadsheets.

How can I do this? I feel like Im just missing a step in the normal
formulas that I use.