ideas

I sometimes take screenshots on my 4K monitor and upload them to Imgur so I can embed them. Any ideas why they come out so large? It's not a problem on mrexcel.com. Even when I view them on Imgur.com, they look big there also. Example: They seem to be getting scaled up by a factor of 2.5.

Hello, I've really tried to figure this out by googling and struggling. I have a database of drivers which is in order of week number 1 - 52 along the top and their MPG (miles per gallon) per week. (as below). I wondered is it possible to put this into a graph, ideally or some kind of table...

I'd like to have the word Project appear in cell E2 on the first Monday of each month. Any ideas on how to do that?

Hi. I'm a an excel novice so apologies in advance. I need to create an allocation tool which distributes work evenly amongst teams. We receive a different amount of queries to get through everyday so would need to amend the daily allocation. Each of the teams have different targets which vary...

I have several protected worksheets with multiple passwords. I am not permitted to change the PW. I would like a script to unlock all the sheets so I thought of this, but it does not work. Any Ideas? Sub Un_Protect_All() awsn = ActiveSheet.Name For Each Sheet In Application.Worksheets...

Here is what I am looking to do: Column A Column B X(unknown # =X*.35 If X less than 857 =300. If X is 858 or more than it is X*.35 Any ideas how to do that? Any help would be great appreciated!!!

If I have a sequence of numbers running vertically in column A, e.g 1901 1902 1903...up to 1952 If I have a number in cell G3 that is not found in my list, eg 1953, I want the function to then give me the number provided in G4 instead I know i'll want an IF function but cant figure it out...

I have a multipage with a label on page 1. I want the label to reflect what is in cell B5, but it doesn't do anything no matter what I try. Any ideas? Private Sub FeesForm_Initialize() Dim ws As Worksheet MultiPage1.pgTerm1.lblTerm.Caption = ws.Cells("b5") End Sub

Hi All, try to replicate the below but my both date and previous date can only slicer the sales amount not the previous sales (Previous sales does not change at all). Any ideas what went wrong and is there any other better way to do it...

Hello, I have this macro that is supposed to delete rows that are blank in either column C or D, but it tends to run for a long time and I am not sure why. Any ideas on how to make it more efficient? Sub deleteBlankRows() Range("D10:D8000").Select...

I am trying to create a formula that will do the following; IF H2 is greater than 50% of I2+JK+K2 then return "***" I am using the following formula but it is not working correctly =IF(AND(H2>+I2+J2+K2/2),"***") Any ideas on what I am doing wrong or how to make this work correctly? Thanks for...

Hi I have a workbook of which I have data on a tab of which I need to transpose from Horizontal to Vertical but then I need to paste the link to it too in another worksheet in same workbook. Any ideas on best way? Thanks

Hi All, So I've got a table in excel that is laid out like below; <colgroup><col><col><col><col><col><col span="5"></colgroup><tbody> 8am-9am 9am-10am 10am-11am 11am-12pm 12pm-1pm 1pm-2pm 2pm-3pm 3pm-4pm 4pm-5pm 5pm-6pm 1 2 3 4 5 6 7 8 9 10 1 12 72 124 209 322 450 500 644 678 1 2 3 4 5...

Set wb = Workbooks.Add ThisWorkbook.Activate ActiveSheet.Copy Before:=wb.Sheets(1) wb.Activate Workbooks("Copy of TEST2 - Copy.xlsm").Close Dim path As String Dim fileName As String path = "C:\Users\andy_\OneDrive\Desktop\VAMLog\" fileName = "SAVEPDF.frm"...

So this seems it should be simple but i cant get it. I want to remove all non alpha charectors from a spreadsheet but not the spaces, which is where i am getting issues. So if I had [ "bob's Number*1 ten." ] the results would be [ bobs number1 ten ]. Any ideas? Thanks.

Hi there, I am creating a calculator in Excel which I need to only go up to 99999 and once it does so I need it to go back to 0. For example....99994 + 8 will return a value of 2 as opposed to 100002. Any ideas on how I would do this? Thanks in advance

Hi Everyone, Not sure if this can be done but I need a formula that can add cell A1 every sheet that starts with the letters "SR" any ideas? Must be a formula not allowed to use VBA on this. Thanks Tony

I have a barcode in excel that scans just fine. Its code 3of9 extended. When i copy that cell and paste it into a word document it will not scan at all. Any ideas? Thanks Kris

I currently have a macro stuck in an infinite loop! I've done Alt/Esc about 3 times and it's not breaking out. I tried Ctrl/Esc, Alt/End and Ctrl/End & it isn't helping. Anybody have any ideas? Thank you!!

I'm having problems to get this done: On a sheet named "sheet3" store the value in cell A3 into a variable called r. I'd appreciate any help or ideas. Tks, Anderson