fixed

Hello I have a logo and some header text that I need to keep fixed on top of the excel sheet (lets say from columns A to J and rows 1 to 4). I want to keep this part of the sheet fixed for vertical / horizontal scrolls. Just as a note - I know the functionality of 'Freeze panes' and that will...

Hello! I want to use a function that utilises a range, such as =ROWS($H$8:H8) where the starting point of the range is fixed. How do I do that if the starting point is returned by another function? How to make that starting point fixed? Thanks!

Hi guys, how is everything? Look, I seek your assistance here. I’m trying to design a button to hide/unhide rows based on the empty cells in fixed column. For example, the range is from A1:Z30 (1:1 is the heading row for the table). The controlling column of the code is going to be G and...

Hi, I have created a form where I would like to validate the information entered in the input box is a specific format. The format I am trying to confirm is that it is fixed, i.e. "Display at least one digit to the left and two digits to the right of the decimal separator." Here is what I...

i want one formula for finding the value . i want to find overtime hrs . eg: Mr A has 1 day overtime 6 Hrs. but actual his OT is only 2. Because 4 hrs fixed hrs. after above all OT Hrs. How i can make this automatic

I have pasted a sample data set below with required output format, Kindly let me know if the desired output can be generated via formula/Macro. In my dataset fields are populated with 3 Keywords - Found, Not Found, Updated. I have to consolidate the headers for output field based on the...

What creative formula will be able to find and extract only the number from a cell with string like this: abc1233efg. Answer is 1233. length and number of characters is not fixed.

Hi All, I have had a look at a number of forums to try and find the answer to my question, but I will need this to be simplified. Suppose I started paying £20 every month into an investment portfolio for the next 40 years, with a fixed interest rate of 2.5%. However, every year I increase my...

I am a beginner in Excel who was plunged reluctantly into a doctoral degree post retirement age. I work in occupational health & safety. I have the need to convert data recorded by dataloggers in three instruments, from one sample per minute to one sample per one second or one sample per 2...

Hi there Legends of Excel I am having trouble with my formula - I am trying to write a formula if G48+H48=2192909 and adding it to C162 and if Est Opt3 I4 is greater than or =to this value then I want the fixed value of $179,235.50 else do F46*I163. =if('Est Opt 3'!I4,"","",If((and('Est Opt...

The goal is to be able to input only one number and have the table populate and be able to dynamically increase or decrease rows with data if Worksheet #2 has data removed or added. In this example, I want to be able to input the account # (we'll say 1) into cell B4. I want the other cells...

Hello, I have data that to be split into each different column, however the problem is if I split it using the text to column method it will split every single words to space (column) and I can do it with the fixed width either because it's different width. How do i attach the file to show...

I’m trying to figure out how to select a specific range using vba code. I know how to select the active cell. Once I have the active cell, I’d like to select a range from the active cell to a fixed, non changing cell. For example, if the active cell is a14 and the fixed cell is i49. The active...

Hi all, I have a formula that is working fine for a single cell but as soon as I try to add another cell to the formula it fails. The objective is to return a different value depending on which cell in a row contains an X (i.e. C3 =1, E3 = 2, G3 = 3 etc etc). If an X is entered into a cell I...

Ok so I have found this VBA code to copy same range from multiple sheets: Sub MakeSummaryTable() Dim ws As Worksheet Application.ScreenUpdating = False Sheets("Sheet1").Activate For Each ws In Worksheets If ws.Name <> "Sheet1" Then...

I get lots of help from here. It's about time I get help by asking a question instead of just looking up. I have below a value and a formula entered in the cells as below. <tbody> A B 1 98.362 =100-B1 </tbody> And, the value returned in the cell, B1, is 1.63800000000001, not 1.638. Has...

Is it possible to fill a range with a fixed value using auto Fill? I have a macro which should insert the value T9 into a range of cells, but the number part keeps incrementing, T9,T10,T11 etc. How can I stop this happening please? my current code is Range (“I2”).Value =T9 Range (“I2”).Autofill...

I have put together a spreadsheet for work, but stuck on one part, i am trying to do a formula/vba to send data to an email address. A4:G10 Fixed Cells (Required everytime) A11:G11 is the heading of a Table, which can go from 1 Row to 20 Rows depending on product. The Table will be at the...

Hi, Need help with Excel. I have put together a spreadsheet for work, but stuck on one part, i am trying to do a formula/vba to send data to an email address. A4:G10 Fixed Cells (Required everytime) A11:G11 is the heading of a Table, which can go from 1 Row to 20 Rows depending on product. The...

Hey all new here great forum.. Need some help with formula. I am referencing same value from another tab in same workbook and I want to drag the formula down but only include the fixed value in every 4th row. I tried OFFSET and ROW but it seems to not be working.