Replies

Thanks all for checking on this matter.

I still have the problem and so does all the PC’s in my work area.. I just opened the attachment and the picture gets fragmented.
So it appears that I may have some type of hardware set up issue.

Regards,

TD

Thanks all for checking on this matter.

I still have the problem and so does all the PC’s in my work area.. I just opened the attachment and the picture gets fragmented.
So it appears that I may have some type of hardware set up issue.

Regards,

TD

A book I though was very good was Learn Microsoft Excel 2000 VBA Programming by Julitta Korol published by Wordware Publishing Inc. http:http://www.wordware.com.

I very much liked the way it was organized to allow the reader on the fly to quickly find what is needed. It starts from the very basic and goes to the more complex.
If you just want to get the work done buy it. If you want to know everything about Excel VBA you will need a different book. Good luck.

TD

A book I though was very good was Learn Microsoft Excel 2000 VBA Programming by Julitta Korol published by Wordware Publishing Inc. http:http://www.wordware.com.

I very much liked the way it was organized to allow the reader on the fly to quickly find what is needed. It starts from the very basic and goes to the more complex.
If you just want to get the work done buy it. If you want to know everything about Excel VBA you will need a different book. Good luck.

TD

Andrew:

Thanks for that suggestion, I was thinking along that line. Using instance 1 in VBA could be helpful.

TD

Andrew:

Thanks for that suggestion, I was thinking along that line. Using instance 1 in VBA could be helpful.

TD

Dear Novice:

Since you already know how to link data you should consider yourself a proficient user of Excel that is smart enough to come to the lounge to get answers.

The information that you provided is rather general, but I will give you a solution I have used on several occassions.

What I have done in the past is to find a nice secluded place on the Master Schedule Sheet and set up what I will call a data table. Here you will put all the needed data in the rows and the vessels in the columns. Of course you will use links to pull the data from each of the vessel sheets to this secluded area. MAKE SURE THE ROWS ARE IN ASCENDING SORT ORDER.

This will do two great things. First it will provide a place where you can monitor that the data is flowing correctly from each sheet. Plus you have now created a database in your master sheet which Excel just loves to slice and dice data.

Now comes the easy part. In the area of the Master Schedule that you want to print use the Vlookup function in Excel
to run down to grab the data based on what Vessel you want.

This may seem complex so I have attached an excel example that should allow you to better understand how this technique works.

Hope this will help you.

Regards,

TD

Dear Novice:

Since you already know how to link data you should consider yourself a proficient user of Excel that is smart enough to come to the lounge to get answers.

The information that you provided is rather general, but I will give you a solution I have used on several occassions.

What I have done in the past is to find a nice secluded place on the Master Schedule Sheet and set up what I will call a data table. Here you will put all the needed data in the rows and the vessels in the columns. Of course you will use links to pull the data from each of the vessel sheets to this secluded area. MAKE SURE THE ROWS ARE IN ASCENDING SORT ORDER.

This will do two great things. First it will provide a place where you can monitor that the data is flowing correctly from each sheet. Plus you have now created a database in your master sheet which Excel just loves to slice and dice data.

Now comes the easy part. In the area of the Master Schedule that you want to print use the Vlookup function in Excel
to run down to grab the data based on what Vessel you want.

This may seem complex so I have attached an excel example that should allow you to better understand how this technique works.

Hope this will help you.

Regards,

TD

The CELLS function in Excel returns information about, formatting, location, or contents of a specific cell or the upper-left cell in a referenced range. It can be a very useful function.

In the formula provided the info type requested is “Type” for cell A2. This returns the following values. “b” for Blank, “l” for labels and “v” for values. Since you only wanted to deal with values that are non zero the nested AND statement requires that the cell be a value AND that value not be zero for the formula to perform division; in all other cases (“b”,”l”, or the value zero) the formula returns -0- (zero).

Regards,

TD

The CELLS function in Excel returns information about, formatting, location, or contents of a specific cell or the upper-left cell in a referenced range. It can be a very useful function.

In the formula provided the info type requested is “Type” for cell A2. This returns the following values. “b” for Blank, “l” for labels and “v” for values. Since you only wanted to deal with values that are non zero the nested AND statement requires that the cell be a value AND that value not be zero for the formula to perform division; in all other cases (“b”,”l”, or the value zero) the formula returns -0- (zero).

Regards,

TD

Assuming that you are working with cells A1 and A2 with A2 as denominator try the below formula

=IF(AND(CELL(“Type”,A2)=”v”,A20),A1/A2,0)
Regards,
TD

Assuming that you are working with cells A1 and A2 with A2 as denominator try the below formula

=IF(AND(CELL(“Type”,A2)=”v”,A20),A1/A2,0)
Regards,
TD

Tal:

Attached to this response is a workbook containing 2 Macros for your use.

The first Macro OldTabs will create a new Worksheet called “Tab Control”.
In Column B it will list the current names of each TAB in a workbook
In Column C the Macro will put the same names as in Column B
The user will then use Column C to type in the new desired TAB names. It is very important that Column C has a TAB name
for each worksheet in the workbook or the Macro will not function properly. If you don’t want to change a TAB leave the entry that is already in Column C.
Then run the second Macro NewTabs. This Macro will replace the TAB names with your entries in Column C and Delete Tab Control.

Since you are new to Macro’s I suggest the following to use the Macros.
1. Open the attached workbook and save it on your local drive.
2. When needed, open the attached workbook either open the workbook with the tab names you want to change or make it active.
3. Make sure the workbook with the tab names is the Active workbook
4. Then use the shortcut keys ALT + F8 or on the excel menu bar select Tools, Macro, Macro
5. Highligh the Macro you want and hit the Run button.

In the long run, you should move the Macros to your personal.xls worksheet and then put custom buttons on your toolbar, attach the Macros to the buttons.

Lastly, below I have included the Macro Code so it can be viewed by the people who view this post.

Regards,

TD

Sub OldTabs()
‘
‘ MyTabs Macro
‘ Macro recorded 1/23/2004
‘
‘Macro Will Create a new worksheet and list all Tab names
‘ Dim MyTabs As Worksheet
Dim MyValue As Integer
Dim WC As Integer
Dim Placeholder As String
Dim r As Integer
‘Procedure MyValue = 10
WC = Worksheets.Count
Worksheets.Item(WC).Activate
Worksheets.Add After:=Worksheets.Item(WC)
ActiveSheet.Name = “Tab Control”
Cells(7, 3).Value = “New Names”
For r = 1 To WC
Worksheets.Item®.Activate
Placeholder = ActiveSheet.Name
Worksheets(“Tab Control”).Activate
Cells(MyValue + r, 2).Value = Placeholder
Cells(MyValue + r, 3).Value = Placeholder
Next r
End Sub

Sub NewTabs()
‘
‘NewTabs Macro
‘Macro recorded 1/26/2004 by duthiet
‘
‘Maco will use list created in Tab Control [Column C]
‘that is then modified by User to rename the Tabs. MyValue = 10
WC = Worksheets.Count
For r = 1 To WC – 1
Worksheets(“Tab Control”).Activate
NewName = Cells(MyValue + r, 3).Value
Worksheets.Item®.Name = NewName
Next r
Application.DisplayAlerts = False
Worksheets(“Tab Control”).Delete
Application.DisplayAlerts = True
End Sub

Edited by HansV to make URL clickable – see Help 19

Try going to http://www.microsoft.com[/url%5D find the office page and then look for templates.
I am not 100% sure but I think you will be able to find a bunch of Calendar Templates.

Regards,

TD

(Edited by HansV to make URL clickable – see Help 19)

Ronny:

Microsoft at its main site http://www.microsoft.com[/url%5D at the office web page has a link to “Templates”
If you select this you will go to the Template page. At the bottom there is a category called education
If you select this category you will see a selection for Teachers then a sub-selection fro tests and grades.

One of these seems to do exactly what you desire. Just download and save on you computer.
Regards,

TD