Free Microsoft Excel 2013 Quick Reference

Problem with Monotype Sorts Check Mark

Hello Group,
I have a spreadsheet in which I am using the Monotype Sorts font to
represent a check mark. This has worked great for all of my users up
until now. I have a new user and when he views the sheet the check mark
shows up as file cabinet icon. Does anybody have any idea why this
might be happening?

I did notice this happened when I tried implementing my system on some
machines in Hong Kong but I thought this might be due to regional
settings or something.

Any help would be greatly appreciated.

Thanks,
James


Morning Gurus!

I am having a problem with some sorting code. The code below was created by recording a macro. I then pasted the code into my existing code where I wanted it to sort. It works great on my Excel 2007 at work but crashed my excel 2003 at home.

The Question:

How can a sort code be written that is ambiguous to any version of Excel? I know there is coded you can add to the workbook that will check the GUI but I was hoping not to have to add that and maybe find a different way to sort the range indicated in my coded.

Code:
    Range("A3:F54").Select
    ActiveWorkbook.Worksheets("Location Summary").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("Location Summary").Sort.SortFields.Add Key:=Range( _
        "A3:A54"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
        xlSortNormal
    With ActiveWorkbook.Worksheets("Location Summary").Sort
        .SetRange Range("A3:F54")
        .Header = xlGuess
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With
The data in column A is all text and in columns B thru F are all numerical. Does anyone have a way to sort this that will work in all versions of Excel?

As always, your help is greatly appreciated!

The program is supposed to sort a specific column which is designated by an integer variable.

With (rangename)
.Sort Key1:=Range(.Offset(0,variable),.End(xlDown)), Order:=xlAscending,
Header:=xlno

end with

HELP?

Morning,

I'm having a problem with my spreadsheet checking from sheet to sheet.

I'm using the formula:

=VLOOKUP(N2,FORUMLAS!$O$1:$P$9,2)

This correctly gives back that * counts for 0.

However when I use the formula:

=COUNTIF('INPUT SHEET'!$O:$O,FORUMLAS!O1)

It counts the * as all the values.

But again when I use a derivative of the formula (checking another column):

=SUMPRODUCT(('INPUT SHEET'!$O$2:$O$400=FORUMLAS!O1)*('INPUT SHEET'!$B$2:$B$400=FORUMLAS!$B12))

It works. Any idea how I can get the =COUNTIF('INPUT SHEET'!$O:$O,FORUMLAS!O1) one to work properly?

Thanks

Hi

This is my first post here, so I hope I've done everything correctly in accordance with the rules My downfall is my "descriptive subject line" because I ran out of room! In any case, here goes:

I'm using Excel 2007 Ultimate Edition under Windows Vista Home Premium. I'm not a "power user" by any stretch of the imagination - my uses for Excel are very limited. However, I'd really like to use it for a new application and I can't figure out how to get out of it a few of things, which I'm sure are there - I just can't figure out where to find them.

I've tried looking these up though Excel's own help files, checked out the Microsoft Knowledge Base and searched here as well. My main problem with each search place is the same as I mentioned above - finding a way to search for what I'm looking for by only using a few short words has been pretty much impossible. So, here I am.

I'll tell you up front why I'm doing this graph just so you don't think I'm trying to scam free information when I could be a business and pay for expensive courses to learn how to do all this stuff. I'm a disabled student who has recently been diagnosed with diabetes and want to create a simple way to keep track of my blood sugar levels every day. To go along with the actual spreadsheet (which was easy to create except for a couple of things) I'd like a graph that I could give to my doctor each visit rather than him thumbing through a notebook (which is what he expected me to provide him). Considering he knows how much of the day I spend on the computer (I study externally because of my disability) then he could well expect this more modern-day approach from me anyway

I went to the Microsoft site and got myself a basic Blood Glucose Chart that someone else kindly put together. I've changed it more than enough now to make it my own, so thank you to the wonderful person who created it. It had a chart included but it didn't do any of the things that I wanted it to do so that's why I am here.

The first thing is this - my Excel spreadsheet is going to be only three columns wide with date, time and then the varied test results in the last column. The number of entries per day will vary and I'm fine with entering the current time and date in the first two columns (I have at least that bit worked out!). The last column will change every time.

I've also managed to work out a colour coded system for the last column of data so that I can easily see if it's too high or too low or just right. I've never really done anything much with Excel before at all except for a budget and the like so this is all new stuff for me! I'm pleased that I got that much worked out!

The spreadsheet data entry area has been set up so that the most recent date is at the top and the oldest down the bottom. This is so I will always have the most recent entries on view at any one time and the older ones further down the page. What I want to be able to do is that once I enter the data on the top row, I want it to automatically create a new blank row above that and make all the current data go one row down. I'm sure I could create some kind of macro to do this, but as I've never created a macro in my life and, even after reading up on it in various places (Excel help section, etc as above), it's all still a bit beyond me I think. So does anyone have any suggestions for how this might work? What sort of macro might I need or is that what I need at all? Also, by creating the line new at the top every time will that include the formatting of the lower line (ie the colours for certain entries)? At the moment it does but will the automation take that away? By creating the new lines manually I find that I have to leave two blank lines at the top or otherwise when I create the new row I create the "header" row properties and not the normal row ones (the header being bold and coloured and informative not blank and noraml-). I'm not sure why it happens that way, it just does! This is the end of only the first question!

:: phew ::

Next question ... The line graphs (and it's a line graph that I'm almost certain I want) that I can create very easily using the Insert --> Line graph button are fantastic, but I'm curious as to why they can't be made permanent? I know they can be created as a template and then it's only one click to get to exactly as I want it to be (which I've done), but I'd like things to be done automatically (had you figured this out yet?). I'd really like a permanent graph (maybe on a separate sheet similar to the one that came with the one from Microsoft?) but that will also automatically update as new data is added. Also, I want to be able to target certain data at a time - say a particular week. At other times I want to see all the data that's in the sheet. Or year to date. You get the idea.

I've done a little work on the custom template graph that I created, but I'm gathering that the more permanent graph would be put together differently - well, I'm almost sure? There are, however, two particular things that I'd like to do with it. The number of results throughout a day will change - sometimes one or two results, sometimes five or six (depending on what my results are). When I create the graph, however, I want the width of a section for each day to be the same. So I guess what I need is for the axis at the bottom to be over hours throughout a day rather than just one point on the graph for only each and every test. The latter would result in a graph that would give a false sense of trends - if my blood sugar was high for one day that might be okay. But if I took five tests that day and they are all high compared to one test on a low sugar day then it's going to look like I had a lot of highs and only one low. By comparison in my perfect graph all the highs will still look like only one day and so the one test on one day that was low will show up as being comparable - I had one day with high tests and I had one day with a low test.

So I need to carefully set up that axis on both x and y (I need the "x" to reflect everything from, say, 0 to about 16 - these are reasonable limits of the glucose tests we use in Australia although it does go higher - which I know is different from the results in, say, the USA - and then the "y" date range across the bottom to be time over individual days - as above). This isn't the only thing that I need on my graph, but it's a good start anyway! And if I can learn the big stuff I might be able to work the little stuff out on my own.

Okay, two final questions and they're both frippery but frippery I'd still like ... As I said before, I've colour coded the results so that if I go above, below or between certain numbers then it will fill in the cell with various colours. I tried to mix this with bars (I've just had a look for them and can't find the exact name now, but the bars that vary in length over the width of a cell to reflect the result) so that the coloured bars I have for high, middle and low would be longer or shorter to give me a view of these results immediately but I couldn't find a way to do it. Any ideas on this one? Then I'd like to have the dots in the graph reflect the colour that the fill in of the cell is that it comes from. So high results would not only be high on the chart but red as well. Or perhaps that the fill behind the bars above a certain figure would all be red? So that it was easily seen that every time the chart went into that area it would be bad. And being blood sugar results I have red then yellow then green then yellow then red again because being low is as bad as being high and there are mediocre results as well (hence the yellow). Is any/all of that possible? It's nothing more than just another clear showing of where those results lay in the table but my Doctor needs this, trust me!

Thank you all in advance for reading through all of this and I hope someone or a few people out there are able to help me. I will be most grateful, although what I can offer is return is probably not very much. But I will be happy to offer this whole spreadsheet/workbook to any other diabetics (or those who know diabetics) out there who are interested in it and would be happy for someone to serve it on their sites for that purpose.

Much appreciation.

Kind regards

Vicki

Creating a qualifications checklist for new hires. Need to create a list
with 'check mark' boxes, without a data base, for simple on screen checking.

Hello,

I have noticed some problems with the function "Worksheet_Change" between
different MS Excel versions.

Personally, I have the version: MS Excel 2000 (9.0.6926 SP-3)
and in this version there is NO problem.
A customer, though, works with the two versions:

MS Excel 2002 SP-1 and MS Excel 2003 SP-1

and he has noticed that when he selects a cell and changes it, the focus
(the frame is marked) wil not be moved to the next cell after the change
(and ENTER).
It is strange but it works perfectly fine in the older version.

Has anyone else experienced the same thing?
Solutions? Tips or tricks?

Below my Change function is listed. The problem occurs when a cell
is selected within the defined NAME-area "Product_Area".

Ideas anyone?

Thanks (in advance)!

/konpego

===========================================
Private Sub Worksheet_Change(ByVal Target As Range)
Dim sTargetArea As String
Dim rTarget As Range
Dim nRow As Long

On Error GoTo ERR_PROC
' ---------------- Check if change of Product list data ----------------
sTargetArea = Mid(Application.Names("Product_Area").Value, 2)
Set rTarget = Application.Intersect(Target, Range(sTargetArea))
If Not rTarget Is Nothing Then
Application.Cursor = xlWait
FormatWs_SalesSCoSaL
GoTo EXIT_PROC
End If
' -------------------- Check if change of TW data ---------------------
nRow = Target.Row
If IsEmpty(ActiveSheet.Cells(nRow, 3)) Then
Exit Sub ' no product assigned (n C
column)
End If

sTargetArea = Mid(Application.Names("Project_TW_Area").Value, 2)
Set rTarget = Application.Intersect(Target, Range(sTargetArea))
If Not rTarget Is Nothing Then
cmdUpdateProjectTimeWindow.Enabled = True
GoTo EXIT_PROC
End If

Hello,

I have noticed some problems with the function "Worksheet_Change" between
different MS Excel versions.
Personally, I have the version: MS Excel 2000 (9.0.6926 SP-3)
and in this version there is NO problem.
A customer, though, works with the two versions:
MS Excel 2002 SP-1 and MS Excel 2003 SP-1
and he has noticed that when he selects a cell and changes it, the focus
(the frame
is marked) wil not be moved to the next cell after the change (and ENTER).
It is strange but it works perfectly fine in the older version.

Has anyone else experienced the same thing?
Solutions? Tips or tricks?

Below my Change function is listed. The problem occurs when the cell selection
is within the defined NAME-area "Product_Area".

Ideas anyone?

Thanks (in advance)!

/konpego

===========================================
Private Sub Worksheet_Change(ByVal Target As Range)
Dim sTargetArea As String
Dim rTarget As Range
Dim nRow As Long

On Error GoTo ERR_PROC
' ---------------- Check if change of Product list data ----------------
sTargetArea = Mid(Application.Names("Product_Area").Value, 2)
Set rTarget = Application.Intersect(Target, Range(sTargetArea))
If Not rTarget Is Nothing Then
Application.Cursor = xlWait
FormatWs_SalesSCoSaL
GoTo EXIT_PROC
End If
' -------------------- Check if change of TW data ---------------------
nRow = Target.Row
If IsEmpty(ActiveSheet.Cells(nRow, 3)) Then
Exit Sub ' no product assigned (n C
column)
End If

sTargetArea = Mid(Application.Names("Project_TW_Area").Value, 2)
Set rTarget = Application.Intersect(Target, Range(sTargetArea))
If Not rTarget Is Nothing Then
cmdUpdateProjectTimeWindow.Enabled = True
GoTo EXIT_PROC
End If

I manage a sports league, and use Excel to do team rankings with points, games played, wins, ties, etc.

While trying to sort the list in ascending and descending order for points, it works fine, but if I do the same thing for the other columns (e.g. Goals scored), Excel just starts ranking them completely randomly!! I don't understand....

Oh I should mention that all the values in each column result from functions (namely I have another worksheet with team scores (in another tab), and have set up functions that allow me to count the number of wins, goals scored etc.). I don't know if that's a factor... apparently the fact that the functions refer to another tab might be a problem...?

Can someone help?

Hello,

I have noticed some problems with the function "Worksheet_Change" between
different MS Excel versions.

Personally, I have the version: MS Excel 2000 (9.0.6926 SP-3)
and in this version there is NO problem.
A customer, though, works with the two versions:

MS Excel 2002 SP-1 and MS Excel 2003 SP-1

and he has noticed that when he selects a cell and changes it, the focus
(the frame is marked) wil not be moved to the next cell after the change
(and ENTER).
It is strange but it works perfectly fine in the older version.

Has anyone else experienced the same thing?
Solutions? Tips or tricks?

Below my Change function is listed. The problem occurs when a cell
is selected within the defined NAME-area "Product_Area".

Ideas anyone?

Thanks (in advance)!

/konpego

===========================================
Private Sub Worksheet_Change(ByVal Target As Range)
Dim sTargetArea As String
Dim rTarget As Range
Dim nRow As Long

On Error GoTo ERR_PROC
' ---------------- Check if change of Product list data ----------------
sTargetArea = Mid(Application.Names("Product_Area").Value, 2)
Set rTarget = Application.Intersect(Target, Range(sTargetArea))
If Not rTarget Is Nothing Then
Application.Cursor = xlWait
FormatWs_SalesSCoSaL
GoTo EXIT_PROC
End If
' -------------------- Check if change of TW data ---------------------
nRow = Target.Row
If IsEmpty(ActiveSheet.Cells(nRow, 3)) Then
Exit Sub ' no product assigned (n C
column)
End If

sTargetArea = Mid(Application.Names("Project_TW_Area").Value, 2)
Set rTarget = Application.Intersect(Target, Range(sTargetArea))
If Not rTarget Is Nothing Then
cmdUpdateProjectTimeWindow.Enabled = True
GoTo EXIT_PROC
End If

(NOTE: This was previously posted to public.excel group)

Using ASP 3.0, I give the user the ability to create a spreadsheet with a
click. In the resulting spreadsheet, I have 2 columns which contain dates,
and which were created by almost exactly the same code, yet they behave
differently when I try to sort.

First, go to http://www.middletree.net/get.htm and right-click and save the
Excel file, then open it.

Note that the dates in both the Open Date and the Last Modified column look
pretty similar. Now, move the cursor so that you aren't accidentally
highlighting an entire column or anything. From the Excel menu, select Data,
then Sort. In the box that comes up, tell it that you want to sort by TSE,
then by Last Modified.

When you do this, you'll see that the TSE part is correct. However, the
LastModified date is out of order. Specifically, there are some 2005 dates
surrounded by 2006 dates.

Interestingly, this problem doesn't seem to occur in the Open Date column. I
have spent a lot of time looking at my ASP code, but I don't see how these
two columns were built any differently.

Ar any rate, how can I make this so that the dates are sorted correctly?

I have a 2D array which I am attempting to sort. The print-out below shows
the data in its original form and then what it looks like after the sort. I
am trying to sort based on the 5th column. But as you can see, the sorted
range suffers from 2 errors. Firstly, the first item in column 5 is 22.
Secondly, the strings in the first column are in their original order.

Note that each unit is repeated twice in the array. Is the problem based on
the fact that I have repeated data? Or have I slipped a digit in my bubble
sort?

Unsorted Data
Unit 1 C E 241 22
Unit 2 D D 313 13
Unit 3 C B 207 31
Unit 1 C E 61 33
Unit 2 D D 87 5
Unit 3 C B 87 13
************************
Sorted Data
Unit 1 C E 241 22
Unit 2 D D 87 5
Unit 3 D D 313 13
Unit 1 C B 87 13
Unit 2 C B 207 31
Unit 3 C E 61 33

The array with the data is called "HourData". The code I use to sort the
array is as follows:

BubbleSort2D HourData, 4 '5th column = 4th column in 0 based array

For Counter = 1 To TotalUnitBids
Debug.Print HourData(Counter - 1, 0) & " " & HourData(Counter - 1,
1) & " " & HourData(Counter - 1, 2) & " " & HourData(Counter - 1,
3) & " " & HourData(Counter - 1, 4)
Next
********************************************************
Function BubbleSort2D(PassedArray As Variant, col As Long)
' Sorts an array using bubble sort algorithm in descending order using
'column as sort criteria
Dim First As Integer, Last As Integer
Dim i As Integer, j As Integer, k As Integer
Dim Temp As Variant

First = LBound(PassedArray, 1)
Last = UBound(PassedArray, 1)
For i = 1 To Last - 1
For j = i + 1 To Last
If PassedArray(i, col) > PassedArray(j, col) Then
For k = 1 To UBound(PassedArray, 2)
Temp = PassedArray(j, k)
PassedArray(j, k) = PassedArray(i, k)
PassedArray(i, k) = Temp
Next k
End If
Next j
Next i
End Function

Thanks

EM

Hello,

I have noticed some problems with the function "Worksheet_Change" between
different MS Excel versions.
Personally, I have the version: MS Excel 2000 (9.0.6926 SP-3)
and in this version there is NO problem.
A customer, though, works with the two versions:
MS Excel 2002 SP-1 and MS Excel 2003 SP-1
and he has noticed that when he selects a cell and changes it, the focus
(the frame
is marked) wil not be moved to the next cell after the change (and ENTER).
It is strange but it works perfectly fine in the older version.

Has anyone else experienced the same thing?
Solutions? Tips or tricks?

Below my Change function is listed. The problem occurs when the cell selection
is within the defined NAME-area "Product_Area".

Ideas anyone?

Thanks (in advance)!

/konpego

===========================================
Private Sub Worksheet_Change(ByVal Target As Range)
Dim sTargetArea As String
Dim rTarget As Range
Dim nRow As Long

On Error GoTo ERR_PROC
' ---------------- Check if change of Product list data ----------------
sTargetArea = Mid(Application.Names("Product_Area").Value, 2)
Set rTarget = Application.Intersect(Target, Range(sTargetArea))
If Not rTarget Is Nothing Then
Application.Cursor = xlWait
FormatWs_SalesSCoSaL
GoTo EXIT_PROC
End If
' -------------------- Check if change of TW data ---------------------
nRow = Target.Row
If IsEmpty(ActiveSheet.Cells(nRow, 3)) Then
Exit Sub ' no product assigned (n C
column)
End If

sTargetArea = Mid(Application.Names("Project_TW_Area").Value, 2)
Set rTarget = Application.Intersect(Target, Range(sTargetArea))
If Not rTarget Is Nothing Then
cmdUpdateProjectTimeWindow.Enabled = True
GoTo EXIT_PROC
End If

Hi

The following macro provided by Jason of this forum, saves the content of a cell in column B as a unicode text file with file name from the adjacent cell in column A.

I am using this macro to format dictionary entries for use with Mobipocket Creator (ebook software) which requires that each entry in the dictionary is saved as a separate text file. This macro enables me to convert dictionaries that are in an excel spreadsheet to a form that can be used by Mobipocket Creator.

However, I am having a problem with quotation marks. Whenever there is a quotation mark in a cell in column B, Excel puts additional quotation marks in the output file.

For example, when the macro saves the following:

He said, "Hi!"

I open the resulting text file and it shows:

"He said, ""Hi!"""

Excel has enclosed the quotation marked section in quotation marks and enclosed the whole sentence in quotation marks as well. How can I get it to save the text properly?

Sub MakeTextFiles()

Dim Wb As Workbook
Dim Ws1 As Worksheet, Ws2 As Worksheet
Dim Cell As Range, Rng As Range
Dim lastRow As Long
Dim fPath As String, sWb As String, sPath As String, sWs As String

Set Wb = ThisWorkbook
sWb = Wb.Name
sPath = Wb.Path

Set Ws1 = Sheets("Sheet1") 'change to name of sheet with the data
Set Ws2 = Sheets("Sheet2") 'change to name of a blank sheet
fPath = "C:Temp" 'change to the correct path for text files
sWs = Ws2.Name

Application.ScreenUpdating = False
Application.DisplayAlerts = False

With Ws1
lastRow = .Range("A" & Cells.Rows.Count).End(xlUp).Row
Set Rng = .Range("A1:A" & lastRow)
End With

For Each Cell In Rng
Ws2.Range("A1") = Cell.Offset(0, 1)
Ws2.Activate
ThisWorkbook.SaveAs fPath & Cell & ".txt", xlUnicodeText
Next Cell

Ws2.Range("A1").ClearContents
Ws1.Activate
Ws2.Name = sWs

ThisWorkbook.SaveAs sPath & Application.PathSeparator & sWb, xlWorkbookNormal

Application.ScreenUpdating = True
Application.DisplayAlerts = True

End Sub

Hello, I've searched everywhere with no avail to my problem. Perhaps someone here who is more knowledgeable can help me with my problem.

I have a worksheet where I am trying to total how many employees kids will be attending an event, and it must be based on a few criterias.

The column I am having problems with must have this result:
Only include child in Total column if a "1" is entered in the attending field and if child is between ages 3 and 12. Children 2 and under are free to attend so they are totaled in a seperate column.

My worksheet looks a little something like this:

__|___A___|______B______|_______C________|_____D_____|_____X_____|
1_|_Child 1_|__Date of Birth_|_Age as of Dec. 1_| __Attending_|_Total Kids__|
2_|__ Joe__|____2/01/08___|_______3________|_____0 _____|____1______|

There are columns like this for up to five children.

I was able to calculate ages using a COUNTIF function, but failed to implement the attending criteria.

This is what I would have entered in the Total Kids column for this example (just to check age):
My actual formula is much larger however, since there are fields for 5 children. It looks like this:

This results in a child being added to the total column, even though he is not marked as attending yet. Is there any way that
i can correct this to ONLY count a child in the total column if it meets the conditions of older than 2, younger than 13, and
marked as attending? (all in one function?)

I am using excel 2003, and this needs to be calculated without implementing another table (such as required in a DSUM, pivot table, or things of the like). If I shouldn't be using COUNTIF, please direct me otherwise.

Sorry for the long post, or if I posted in the wrong section. Any help is greatly appreciated.

I have an issue with the sort function on my school class roster.

I have a book set up as "Master Roster" and has the list of all my classes and all students in each class. But in the books for each month (i.e. Sept., Oct., Nov.), I have names linked to the "Master Roster." As students are added and subtracted, I will be able to update it on the Master Roster, yet keep track of who was in the class in each month. Their attendance data is kept in the unique row for that name. At the end of a month, I will make the names for the month tab permanent, but the new month will still be linked to the "Master Roster" which will therefore always be a current list.

I have to keep track of attendance for each month which is the purpose of this whole file. Yet, my problem is that during the month, I will want to alphabetize the list as new students come into the class (which is quite frequent), and exit the class (which is somewhat frequent). However, if I do this on the "Master Roster", it will alphabetize the list in the current month, but leave the attendance data unsorted.

Therefore my problem is this. How do I alpha sort my "Master Roster" and keep the data in the current month to stay with the name which is linked to the other book. (I used formula is='Master Roster'X1 to link the names of the Master Roster to the current month). I'm not sure if I am explaining this correctly. Please yell at me if I made this unclear and i will try and clarify. I've attached the spreadsheet for you to look at if it helps (the names have been changed so no worries). Thank you. [Bonus: if you look on the file, I figured out a conditional formatting formula so that all Saturdays and Sundays in each classroom is shaded out.]

Hello,

i have a problem with a simple excel
if
function


	VB:
	
(ABS(G33)

I have a check box on another userform that brings you to Userform 10. How can I show the CheckBox on the other Userform with a check mark only if the correct password is entered on Userform10.

	VB:
	
If UserForm10.TextBox1.Text = "dlw36208" Then 
    UserForm4.CheckBox1.Enabled = True 
    Unload UserForm10 
Else 
    UserForm4.CheckBox1.Enabled = False 
    MsgBox "You Have Entered An Invalid Password. Please Try Again." 
End If 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
abbeville

Anyone know how to set up a menu with a check mark beside an entry that indicates if the item has been clicked on/toggled or not (like the status bar item in the View menu)? I have built a couple of additional menus with various toggle selections and would like to show whether they had been selected or not, however, I can't seem to figure out how to add or remove a check mark. Any help would be appreciated! Thanks.

I inserted a check mark and tried to us a vertical lookup and post the check mark

All I get is a horseshoe looking character. When I do reference to the cell I get the same symbol.

What I trying to do is to place a check mark by the items which have been approved.

I know I could do it with an "X" or a color, but top management wants a check symbol.

I am using Excel 2007

I'm trying to share a workbook that has a lot of macros and I'm having problems with some of them particularly ones that sort or filter. Has anyone had this problem and what is causing it?

Hi all,

I have a problem with the following code, which should find the last row in one workbook sheet, copy the row, open another workbook, find the last row & then paste the data on the row below it (I've removed the code that pastes the data for clarity):

Dim LastRow As Long
If WorksheetFunction.CountA(Cells) > 0 Then
'Search for any entry, by searching backwards by Rows.
LastRow = Cells.Find(What:="*", After:=[A1], _
SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious).Row
MsgBox LastRow
Rows(LastRow).Copy

End If

Workbooks.Open Filename:="C:New machine study applicationSavings data.xls"

LastRow = 0
'If WorksheetFunction.CountA(Cells) > 0 Then

LastRow = Cells.Find(What:="*", After:=[A1], _
SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious).Row
LastRow=LastRow+1
MsgBox LastRow

...in that the first part of the code works fine & correctly locates the last row containing data. The second part (after I open the second workbook), returns the same row as the first part of the code, even though the second workbook has more entries than the first. I've tried changing

LastRow = Cells.Find(What:="*", to LastRow = Cells.Find(What:="",

but this returns an empty row about 5 rows below my last row of data. Can anyone help me out on this & show me where I'm going wrong.

Regards,

Mark

Code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim asheet As String
asheet = ActiveSheet.Name
Application.ScreenUpdating = False
Sheets("Save Log").Select
Sheets("Save Log").Unprotect Password:="password"
Range("A" & Rows.Count).End(xlUp).Offset(1).Value = "Saved " & Now & " by " & Environ("Username")
Sheets("Save Log").Protect Password:="password"
Sheets(asheet).Select
Application.ScreenUpdating = True
End Sub
Hi, I am using this code at workbook level in some of my workbooks. The problem I have is when I have multiple books open (which all contain this code) and I close them all using the X icon, when I select "Save All" nothing happens.

Then if I select the X icon again, it errors at this point -

Code:
If I save the books one by one, there is no problem. I'm guessing its a problem with focus on the workbook which is saving
and the book executing the code but have no idea how to sort this out??

Any idea why this is? Thanks!

Hi
I'm having problems with multiple if statements.
Here is some test data I'm trying, but failing to work with.

basically if there is a balance in column F, I need to see if column h & k match. if then I want to use column F as the o/s balance. However if there is an o/s balance in column f, h & k, but also a balance in column i & l, I need to ignore f, h & k and use columns i & l. Also if there is just a bill in column h or k, I need to check if i or l has been billed.if the balance in i or l is different from h & k i need to ignore h & k.
Column O, row3 should then be 110(not 120 as I've shown) as any payment made in column M should be deducted.

I hope this makes some kind of sense as I have been losing my hair over this and am now bald!!
column Fcolumn Hcolumn Icolumn Kcolumn Lcolumn Mcolumn Oa/c 1+2 billa/c1 osa/c1 billeda/c2 osa/c2 billedpayment madeo/s balancerow 21003007000100row 315020501307010120row 400250025

Hi, I have created a form in excel that has many check boxes, but I cannot figure out how to get the box to show an "x" instead of a check mark.

I am using the check box option from the Forms toolbar and I have also tried the ActiveX control, but couldn't get either to work with an "x".

I am not even sure if you can do this or not, but any help would be appreciated.

Thanks,
Bearspaw2008