suggestions

I need helping breaking a link. I have a file that is supposedly linked to another employees personal file on their computer and when I go into Edit Links and click break link and I get the pop up to break the link but then nothing seems to happen and the link still appears to be there. Any...

Hey guys quick question could not seem to find online. I have variable letters for example BN and would like a formula that would subtract that value by one so it displays BM. Any suggestions would be much appreciative.:):)

I have the code below in a userform, with 5 combo boxes. I need Combo Box 2 to display a time, but I can't get it to work. I've had a look around and tried a few suggestions, but can't seem to get it. Any suggestions would be hugely appreciated. ' Open UserForm1 when the workbook is opened...

Hey guys, always get me great feedback I have: Cell C2: /123K/XXX0-A/XXXX0-135-A0.job I was looking for a formula that would return the value 135 in this example. It will always be between the last two dashes in the cell. Any suggestions would be much appreciated:)

SIR, I have done SUMIF formula which is working but I need a better suggestion for this so I have 4 different sheets of raw data and total (summary) of this sheet in Rec.sheet...

Say cell E2 needs a formula that will produce a "yes" or a "no". if C2 and D2 are empty E2 should also be empty. If C2 and D2 have a no in either cell E2 should say "NO" if both have a yes or a "NO CHANGE" in both cells E2 should say "yes". I'm not sure why I can't make this work. Any...

HI i have this formula =IF(D9=0;1;0)+IF(E9=0;1;0)+IF(F9=0;1;0)+IF(G9=0;1;0)+IF(H9=0;1;0)+IF(I9=0;1;0)+IF(N9=0;1;0)+IF(M9=0;1;0)+IF(L9=0;1;0)+IF(K9=0;1;0)+IF(J9=0;1;0) For counting zeros in a document but i dont want excel to count the empty cells as zero Any suggestions?

When I open an excel spreadsheet, VB runs and then immediately closes the spreadsheet. I would like to edit the VB in the spreadsheet, but cannot keep it open to do so. Any suggestions? This was created in an *.xls 97 - 2003 worksheet

Hi there, Is there a way to restrict cell input to 8,12,13,14 digits only, please? No text, only numbers. Hope to get some helpful suggestions. Thanks, Ashima

Hi, I'm working on a budget & expense table where each row is a unique cost but column A contains sorted and grouped duplicates, where each unique value represent a department code. E.g. A (dept code) B (description) C (amount) C1 Item1 10 C1 Item2 15 C2 Item3 5 C2 Item4 20 C2...

Don't seem to be able to copy & paste into a message using Internet Explorer 11.0.95 Have changed compatibility settings but still no joy. Has anyone got suggestions as to why?

Hi, I have a spreadsheet for work with bookings in it, there’s multiple columns but I need to transfer data from one cell to another based on the following IF column A has a certain date in it AND column B has a certain time in it AND column C has a certain word in it then I want it to take...

Hi Peoples, I have x2 cells (user variables) - which through data processes procure a value in another cell. Please - any suggestions as to how to optimise such? Thank you.

I need to prevent users from entering incorrect values. Everything works except SetFocus. Any suggestions? Private Sub TextBox2_AfterUpdate() CheckBox3.Value = True If (Me.TextBox2.Value) <= (Me.TextBox1.Value) Then MsgBox "Value Cannot Be Less Than 1st Flight", vbCritical TextBox2.Value =...

I am having a problem resolving a compile error with this line. I find many of the same issues however unable to resolve. Any suggestions what this issue is. Thanks guys range("F5").FormulaR1C1 = "=TRIM(RIGHT(C5,LEN(C10)-SEARCH(" ",C5))" & " "&LEFT(C5,FIND(" ",C5))""

Hi, I have over 3000 rows of data similar to "MAYALB93.0106.04.39" in column E1. I want to parse it so that ... A1 = MAYALB93 B1 = 0106 C1 = 04 D1 = 39 so far i was able to come up with this formula below , but i really feel lost in A1 i did this: =LEFT(E1,FIND(".",E1)-1) in B1 i did this...

Greetings! I'm creating spreadsheets to show how many people were "on the clock" at each hour interval for each day of the week. I'm currently adding the information manually, but it's incredibly time consuming, and as with the example below, the data keeps changing so I'd rather have a...

I have this code below & it works to password protect the sheet, but the cells are still locked to format. Any suggestions what I am missing? Sheets("Cell_Data").Protect Password:="password", AllowFormattingCells:=True

Hey guys I was wondering if I could get some suggestions or opinions on the best way to do this. Currently I have some code written that archives all data from the day's work into another workbook. These workbooks are only used to store old data. I'm thinking about changing the way I'm archiving...

Hi All; Hope you can help. I have the following statement If IsText(Me!cmbCustomer) Then Me!txtEmail.Value = Application.WorksheetFunction.Offset(ActiveWorkbook.Worksheets("Website Orders").Range("O12"), Application.WorksheetFunction.Match(cmbCustomer.Value...