ideas

I need a formula that extracts every other character from a cell. For example: 112233445566 778899,, aaBBcc## Would become: 123456 789, aBc# Any ideas? Thanks!

"We can't update some of the links in your workbook right now....." VBA code to ensure that upon opening the spreadsheet this automatically selects "continue" to this message? Any ideas please?

Hi All I have a sheet of data (Sheet2) I would like a formula to go in sheet 1 cell F3 that will return the last value from column C of sheet 2. any ideas? Cheers Neil

G'day guys. Need to do a tricky one... I'm not sure how this can be done with a VBA sub routine. Once the data shifts to another sheet ("DATA Currently") I need to run a VBA script afterwards to convert it into the "Data needs to be" values. Anyone got ideas? I'm sure there would be a way...

Hi all I want to move files from Dropbox to One Drive so I can use auto save. Does anyone have any ideas on the best way to move Excel files and move the lookups from other files to the new locations. Cheers

Hi just wondering if anyone would have any ideas on simplifying this formula...

I've googled this with no luck. Every formula I find seems wrong. I want to count the number of days an employee has worked in a row automatically. In the image shown here, Cell D2 should be 1, D3 should be 2 (because there are values greater than 0 2 days in a row for billy), but D4 should...

Trying to open a PDF file that's coming from a Hyperlink. My feeble attempt at a string. Any ideas? Sub openPDF() ThisWorkbook.FollowHyperlink "G:\Elbe\Elbe Tools\Selectors\Elbe\Elbe USA Selector.xlsm" End Sub Rob

I'm working on customizing my mac excel 2011 toolbar. Using View/Toolbars/Customize I can add and delete buttons. My problem is I want to add the "Edit Comment" command/button but it's missing from the list. It was there yesterday because I put it on my toolbar but then took it off. Ever since...

Good day! I have about 10 files that I manually open and update daily. Overall, the procedure takes 30 minutes so far. Is there any way to outsource this update somehow? On a kind server / Sharepoint? What ideas would you have for me? A macro which on an external computer in the morning each...

Hi there, I'm trying to put a code into my macro, but I struggle with finding right arguments for the code. I'm want cells from A:F to be locked and be unselectable, and range from H:Q to be locked and selectable. Any ideas? Thanks

Hello all. I am looking for a way to find an integers (stored as a variable) nearest multiple of 1000's, both above and below. For example, if a variables value is 5012, I would like to have 5000 and 6000 returned as two additional variables. Any ideas?

Hi all, I am trying to highlight expired/ expiring dates using CF I have the following formula =AND(LEN(G13),TODAY()>G13) This doesn't seem to work with a range of cells and only highlights parts of the range Any ideas what I am doing wrong? Thanks

Hi All, With some help from you guys on here i have manged to build a small database which i want mutlple users to be able to use. The file itself is on a shared drive where all users have access to be able to see the file in question. The only issue is when they click on it to open it they...

Hi all, I have this which works when "X" is found in one column: If Cells(ActiveCell.Row, "L").Value = "X" Then But what about when X can be found in one of three columns? If Range("R" & ActiveCell.Row & ":T" & ActiveCell.Row).Value = "X" Then That returns an error. Any ideas? I'd prefer...

I am trying to right a formula that will look up the firs set of values in a cell where there are numbers separated by a dash below is an example of the data. I want to look up the 301 or 024. Any ideas? <colgroup><col></colgroup><tbody> 301-513410 303-545826 024-562515 303-556837...

Hello all I am trying to protect part of my worksheet but still allow sort by filter but this line of code that I put together is not working out, any idea's please Rows("14:1048576").Select Selection.Locked = False Selection.FormulaHidden = False ActiveSheet.Protect...

I would like to be able to produce a number of line charts and place them into an existing worksheet. Is it possible to have them placed into a sheet in the same way something like Range("A1").End(xlDown).Offset(1,0) would select the next cell below the last occupied cell? Ideas?

I am looking to use sumif/sumifs but what I need to do is check my criteria against the left 14 characters of my range. I am not sure how to write that. Any ideas? SUMIF(left($A$2:$A$3000,14),A2,$C$2:$C$3000) Thanks,

Hi, I am a bit stuck and was wondering if anyone has any ideas. I have an extract from Exchange that has data similar to this..lots of rows but need a formula that searches each row for "*newmail.com" and appears in the NEWMAIL column (C): <colgroup><col width="75" style="width: 56pt...