skip rows

Hi Guys!! I'm using the Hyperlink function for a database with different sheets. On my main sheet I have the label of each element, and on my second sheet I have each element with an individual table with some data. The issue is that I need to link the label on the first sheet with the table...

Right I have numbers from -90 to 90 by 1 with values and I need to interpolate numbers from -90 to 90 by 0.1. I need my formula to skip 10 cells then increase to use new numbers to interpolate, so for numbers between -90 and -89 it uses those values then -89 to -88 for the next 10 interpolated...

I am trying to paste data from Sheet 1 onto Sheet 2 and have 5 cells skipped on Sheet 2. I need to drag the formula down so that: Sheet 1, Cell B2 = Sheet 2, Cell A2 Sheet 1, Cell B3 = Sheet 2, Cell A7 Sheet 1, Cell B4 = Sheet 2, Cell A12 And so forth... Then in Column B on Sheet 2, I need to...

I found some previously solved posts that are similar to what I need, but I am having trouble making their solutions work for myself. I would really appreciate anyone's help! Here's the scenario: I have created a report that holds the grades of certain calls that have a corresponding reference...

I have been racking my brain trying to figure out a quick way to resolve an age old issue I have. I currently have a workbook with 3 worksheets in it. The first worksheet is the reporting sheet, the second is before data, and the last is after data. On the reporting sheet, cell A1 is equal to...

I am trying to simplify a billing spreadsheet. Sheet1 keeps track of billing to the customer, and sheet2 keeps track of a shared portion of the customer data billed to an association. I want to copy information from sheet1: A to Sheet2: A but the problem is that the interest is calculated...

I think I am making this harder than it needs to be. How do I take the information as it is displayed in the first column below and write a formula that returns a result of the second column below. I think I would have to use some kind of Offset Function. <TABLE style="WIDTH: 144pt...

I have information in a column (column W) and I need to take the information in every 6th row. I would like this information to populate in column Y. For example, I would like Y2 to show the information in W2, and then Y3 to show the information in W8, and Y4 to show the information in W14...

I have a macro that creates a DAT (csv) file, and then prints out a header row, data rows and a footer row. I have forumlas in the DATA rows across all cells in the range (BX5 and across and down to the last column and row found - see code below). My questions is where I have an entire row of...