• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excell

Mustang

Contractor Among Contractors
Joined
Jul 18, 2005
Messages
1,164
Likes received
1
Thanks received
1
Location
Bedfordshire
Any Excel gurus that would mind if I PM'ed them with a problem I have in Excel? Dont wanrt to try and describe it in a thread....!! :throw:
 
Last edited: 16:20
Mustang said:
Any Excell gurus that would mind if I PM'ed them with a problem I have in Excel? Dont wanrt to try and describe it in a thread....!! :throw:

PM away :D
 
expat said:
Excel.

In memoriam.

I'm not so sure. In my view there will still be Excel and/or Access solutions keeping things together for a long, long time yet. From a Finance angle as a freelance Finance Manager they are most often the only solution available to reconcile the mess left from poorly setup/maintained systems where all the resource is now pointing to 'leading edge' technology.
 
Thanks to those that responded - especially SpaceCadet who resolved the issue I had. :yay:

Here's another one: can you set a "Master" Header and Footer that appears on all worksheets or do I have to go in and add a Header/Footer to each sheet individually? :confused:

TIA.
 
macros:

Code:
Sub SetAllHeaders()

    Dim wsheet As Worksheet
    Dim basesheet As String
    
    basesheet = "sheet1"
    
    For Each wsheet In Worksheets
    
    If wsheet.Name <> basesheet Then
    
    
       With wsheet.PageSetup
           .LeftHeader = Sheets(basesheet).PageSetup.LeftHeader
           .CenterHeader = Sheets(basesheet).PageSetup.CenterHeader
           .RightHeader = Sheets(basesheet).PageSetup.RightHeader
           .LeftFooter = Sheets(basesheet).PageSetup.LeftFooter
           .CenterFooter = Sheets(basesheet).PageSetup.CenterFooter
           .RightFooter = Sheets(basesheet).PageSetup.RightFooter
       End With
       
    End If
    
    Next wsheet
End Sub

obviously you'll need to tailor it for your needs!
 
Last edited: 12:47

Advertisers

Back
Top