Replies

Thanks Legare. This does exactly what I wanted the user to do. One last question, I might be wrong, but for this macro to work the sheet has to be existing. I have a macro that will be inserting this sheet how can I make this part of that macro or call it. Thanks.

Sorry for all the confusion guys, but I still don’t know which code to use. Basically, I am attaching the file for reference. I want the person to fill all cells until they reach D7(which is merge all the way to J7). If any text is enter in this cell (d7) I want the worksheet to format the row below and put a 2(subsequent number from above)in A2 and format the same as the row above. I hope this helps to clarify the issue. Thanks.

Thanks Hans.

Thanks Hans.

Thanks Rori, However this comands adds an extra worksheet. It does add the worksheet I want to at the end, but I also get an extra sheet. Here is the VB command. Any ideas where I went wrong?
Sub InsertSheet()
Dim wk As Worksheet
On Error Resume Next
Set wk = worksheets(“allotment”)

‘If no error occurred, then worksheet already exists
If Err = 0 Then Exit Sub

‘if error exist then go to 0 and exit sub
On Error GoTo 0

Set sht = Sheets.Add(After:=Sheets(Sheets.Count))

‘If spreadsheet is built do the following
With worksheets.Add
.Name = “allotment”
.Range(“a6”) = “Date”
End with
End sub

Thanks that works.

Thanks Hans.

Thanks Hans for the quick response.

Thanks Hans. Do you know if there is a way to get a history for an excel file of a user making changes. For example, I want find out the last person that made changes to a file and date.

Thanks Hans for all your help.

What about doing a loop? I only want to create this worksheet one time, but I am afraid that the people using the spreadsheet may run the macro by mistake in which case I don’t want them to get an error message. For example if they press the macro. The VB will check to see if the “Allotment” worksheet is present if not then it will create it with all the other information on the macro.

Thanks HansV. That work, but now one more question. If I tried to run the macro again, I get an error. What other VB command do I need to include so in case someone runs the macro again it will not give them an error? Thanks.

Thanks LegareColeman that works.

what happen is that the document was started as a table in a word documents and then it was brought over to excel to calculate some fields. I tried doing the best formatting, but I was just curious. Thanks for the reply though. I kknow if I do a merge, I would lose all the info on a cell.