I have a payroll list that I am trying to consolidate for ease of access. As of now there is about 1500 rows in use most of which are empty. What I would like to do is hide or unhide rows 8 - 27 based on the value of the above cell. For instance if C8 > 0 unhide row 9 else hide rows 9-27. This instance is based on the first employee the next employee rows to hide or unhide is rows 36 - 55, then the next is 64 - 83. There will always be same number of cells in between employees.

I have a range of data and I am trying to apply conditional formatting:

Can someone please help me write the formula for;

IF (A/B) is less than 60% then the cell should be highlighted in Red
If (A/B) is between 61% to 80% then the cell should be highlighted in Yellow
and
If (A/B) is greater than 80% then the cell should be highlighted in Green

Hello! I need to decompose the following data (35.0 ; 11.0 ; 129.0 ) that I have in a cell to different cells where 35 , 11, and 129 are the code and 0 is any value of each code and it will be in another cell and the ";" is the separator ; thank you.

I'm trying to concatenate a filtered column into a single cell separated with commas, only visible non empty cells.

Public Function Parts(myRange As Range)

    Dim aOutput As String, entry As Range

    For Each entry In myRange

        If entry.EntireColumn.Hidden = False Then

            aOutput = aOutput & entry.Value & ","

        End If

    Next

Hello! I need to decompose the following data (35.0 ; 11.0 ; 129.0 ) that I have in a cell to different cells where 35 , 11, and 129 are the code and 0 is any value of each code and it will be in another cell and the ";" is the separator ; thank you.

Here is a link to the spreadsheet of what I'm trying to accomplish:
https://docs.google.com/spreadsheets/d/1ZFGRo6LvQHBdfj4sJiXlO-jQLFd_-gv7...

QUESTION: without using Macros, I'm trying to create two ArrayFormulas:

1) What arrayformula do I put into cell A17, such that I am able to...repopulate A5:A10 into one column, based on however many "Days" of data there are.

(In this example, there are 4. So A5:A10 needs to repopulate as one column 4 times)

Hi ExcelExperts,
I am trying to create a formula that is linked to different worksheets for the purpose of financial statements. So, if i make any changes on the original data, I need the cells in other worksheets to update at the same time.
How can i create this kind of formula?

Thanks for the help.

Really a newbie question - but here goes. I have a spreadsheet that has quite a few codes and numbers that begin with 0. I have tried to format the cells so that the number appears as, for instance, 0612 - but haven't been able to find the trick to keep it from converting to 612. I have projects due and no time to devote to searching for this - so if anyone has a quick answer that would be great.

Thanks for your time

Heatherbluejay

So here is my issue. I am Military and have to present a spreadsheet tomorrow but I want to add a formula that makes it easier for me and my superiors to use. It is about Military Vehicle Scheduled Maintenance (Service). There is a column labeled "Due Date", this is the actual day that the vehicle needs to come in and the mechanics do a service on it. Depending on the type of service it is, it will have a 10% variance allowed so in other words if it is an annual service (365 Days) we are allowed to service it 36 days before the due date or 36 days after the due date.

Can someone help me please with this in Excel 2010:

In the example of the attached picture:

Example with yellow cells: numbers in A1 and B1 to be detected on the columns E, F, I, J (cells A1 and B1 are always side by side in this way), then these two numbers to be displayed in the cell M3 plus the maximal of the numbers from the cells: C1, G2 and K4 (neighboring cells). The final text (cell M3) must look exactly like in the picture.

I'm only really familiar with coding in Matlab, and am having to convert a file from that into VBA. The point is to read an array of numbers (as seen defined in the top), and calculate the different Q values based on the if loops. This is what I have so far, and cannot get any output function to send the calculated Q values back to the worksheet, so currently I don't have one listed. Ideally, I'd like the output to be three columns, one for the number of iterations (i), one for the t value, and one for the Q calculated. Any advice would be great. I've attached my code for reference:

Hi,
I'm having a bit of difficulty in populating a desired list through the use of a combo box, I'm hoping someone here has he smarts to help me.
We have a training register to show the mandatory training required per position, I would like the user to select the position from the combo box & underneath the mandatory training for that position will appear.

Hi,I was wondering if anyone can help. I have developed a forecasting model in excel (Holt Winters). I have set up the forecasting model for one product, but I have approx 600 other products. The excel sheet with all its functions that I developed for product one, I wish to replicate exactly for all the other products by hitting a button and it opens a new sheet exactly the same as the first with all the excel functions/ calculations included.

Hi All, I am looking for a spreadsheet I can use to work out "who has won what?" within a fishing club! So I have lots of fish that are caught by members entered on a spreadsheet, but need a sheet that can sort it all out. Any elp greatly appreciated!!!!!

Hello ExcelExperts,

Currently I'm making a spreadsheet that has an Userform in it and I need some help with this. I hope some-one can help me with it and please note that my English isn't my main language so I'm doing my best to give you a good idea of what I mean etc. using the English that I know.

What I already got:
I have an Userform that I can fill in and it places the data in my excelsheet named Sheet1.
The userform looks like this:
Projectnumber Projectdetails Hours

What I want as the outcome which I need help with:

Hello,
I have a corrupted Microsoft Excel Macro-Enabled Workbook xlsm file. Does anyone know how i can restore or recover it please?

I've created a file to which copy all files which is older than certain dates from FromPath to ToPath.but its working.can any one help me out in this code

Sub Copy_Files_Dates()

Dim FSO As Object
Dim FromPath As String
Dim ToPath As String
Dim FileInFromFolder As Object

FromPath = "C:\Temp\New folder" '<< Change
ToPath = "C:\Temp\Test\" '<< Change

FileExt = "*.pptx*"

If Right(FromPath, 1) <> "\" Then
FromPath = FromPath & "\"
End If

If Right(ToPath, 1) <> "\" Then
ToPath = ToPath & "\"
End If

Set FSO = CreateObject("scripting.filesystemobject")

I am creating a database spread across several spreadsheets and I need to reference cells in my main spreadsheet to be displayed in other spreadsheets.
My problem is this: when I reference a cell in the straight forward way, it only copies the formula or value. When I use the =HYPERLINK function, it copies the text and use it as a URL (which of course results in an error).
I searched online for a while and found the following solution: creating a VBA of =getURL.

Public Function GetURL(c As Range) As String
On Error Resume Next
GetURL = c.Hyperlinks(1).Address
End Function

Hi,

In Sheet1!D3 of GRAND EVALUATIONS.XLSM , there is a Date. And the date value varies from time to time. The format of the date value is "05/September/2015".

I have attached a spreadsheet.

I need a formula to count the number of students from each school, in each grade, that are between 95%-100%, 90-94%, 80-89%, 70-79%, 60-69%, 50-59%, and below 50%.

So for example, there are 9 students in grade 1 at the community school that are between 90-94% and 3 between 80-89% and 2 below 50%.

Can you please help? I did get a formula from here before, but now my I have to break down the percentages further and I can't do it.

Thank you so much! :)))

I need to perform a series of calcuations a number of times depending on the value in cell A1. I think a for loop will suffice but I'm new to VBA and I'm having trouble understanding how to 'put the VBA loop' into a cell, how to reference other cells from within (I would use the OFFSET function in excel) and how to display the results in the cell.

This is what I have so far.

Dim i, iArray, Total As Integer
For i = 1 To Range("A1")
Total = Total + iArray(i)
' Cells(i, 1).Value = iFib
Next

File attached. just 12 kb excel

First section is Sheet1 and second section is Sheet2. Sheet1 is Base file. Sheet2 is the testing file. I want to compare B,C,D,E values only if column A of Sheet1 and Sheet2 matches. Display the difference or all value match. Kindly reply thanks.
I have this formula with me , its not working
=IF(AND(A6=Sheet2!A:A,B6=Sheet2!B6, C6=Sheet2!C6, D6=Sheet2!D6, E6=Sheet2!E6), "Full match", "No")

I am trying very hard to make this work and I know it gotta be simple. Here is the challenge. I have a list of sales reps in sheet (salesreps!). Lets just say it rep a, b,c. Those rep names get thrown into another sheet in my workbook (monday!). Easy enough so far. Here are a few things I, for the life of me just can't figure out.

1. When I type in a rep name on (salesreps!) - after I load in his name, the cell becomes locked.

2. I'd like on the (salesreps!) page as well the opportunity that if the rep quits, a drop downbox allowing me to choose (in-active, active).

I have 900 employees schedules which i can run a report and save as an excel file. A schedule for 1 employee is on average 4 columns and 14 rows in area within the spreadsheet. Can I automate a way for each employee to have their "table" converted to a html file for each employee out of the one spreadsheet without manually selecting the area and saving as webpage for each?

Hi there
I was wondering if anyone would be able to help me with the following

I am after creating a button on a workbook front sheet that once pressed it generates a copy of a template workbook and saves it in a number sequence that increases everytime its generated. ie. when the button is pressed it generates workbook01 the next time it is pressed it will use the same template workbook as the first time but will name it and save it as workbook02 etc.

regards m.wilson

How can I link to a cell (which contains an existing external hyperlink) form a cell in a different spread sheet but within the same workbook?

I have 2 columns of text that I want to covert or show in a new column as a number. ss A would = 17, SI A = 18 and SF = 0 how would I do that?

ss A
ss A
si C
sf I
ss A
si C
ss C

I am trying to create a macro that goes through 9 rows of data to remove duplicates then move to the next 9 rows and preform the same remove duplicates function.

Currently I have...

ActiveWindow.SmallScroll Down:=15
Range("A184:E192").Select
ActiveSheet.Range("$A$184:$E$192").RemoveDuplicates Columns:=5, Header:= _
xlNo
Range("A193:E201").Select
ActiveSheet.Range("$A$193:$E$201").RemoveDuplicates Columns:=5, Header:= _
xlNo
ActiveWindow.SmallScroll Down:=18
Range("A202:E210").Select

I am building a report card for athletes and I have made individualized reports based on their names allocated in the drop down menu.

I am unsure on how to print all these different reports without clicking on each athlete's name individually. I have had a previous report with a print all button in the developers tab but I am not sure where it went and how to create a new one.

Please help

I have a very weird problem with a userform and its option buttons. As you can see from the first picture, there are 5 identical columns of buttons, each with 14 rows. Each row is grouped with a frame. When the Calculate Scores button is hit, a grade is created below each column. It appears to be working as expected until any button in row 11 is selected.