Can I create a macro in one of my spreadsheets and send it to another user so they could use it on their adta in their computer?

I need to track contract end dates for staff at three centres, my spreadsheet looks like this: centre end date TJAS 1/10/10 ACT ...

Worksheet 1 has one VLOOKUP function that provides an employee ID number after it has been placed in a cell (via the drop-down list selection of the last...

I have a very large worksheet and need to hide addt'l columns. However when I try to hide them I get the error message "Cannot shift objects off sheet" ...

We have mulitple shared excel files for users to enter data in a common format. We are then using the import query to compile the data from these files into...

I want to do a Hlookup which has to return the value from the row it's standing in. =HLOOKUP(L3,Sheet4!B2:AE35,????,FALSE) L3 gives a code which is on top of...

I have several columns with 1 of 4 values (Y,N,N/A,blank). I need to calculate the percentages of Y's. For example if there are 6 columns, 3 with Y's, 2...

I have a worksheet containing Customer feedback data which I continually add to. This is structured by employee, data, comment and so on. I want to be able...

Hi all, I have an issue, where I have a formula to capture a month and its data. The month on the columns keeps changing, example A1=Jan and the follwong...

Hello: I have the following chart: A 1 1 Plastic 2 Wood 1 metal 2 5 Plastic 2 Metal 3 4 Metal 3...

I need to enter data in different forms - thus several sheets with the same information but sorted differently on each sheet. Is there a way to link each...

Hi, I have a formula which works...

I have two worksheets - 1st one is Played 2nd one is Score in first work sheet i have columns n "points" column o "date" in worksheet two i have column c...

i customized a cell with a now() date field so that it's date is always updated. i also designed the cell and add a "th" word so that today would be shown like...

How do I extract the last word in a character string of words and spaces? I appreciate your help, -John

hi, I have 3 values, e.g, A1=67, B1=89, C1=92 At cell D1 and E1, how to get the best two highest values appear automatically. TQ

Hi I have a number of workbook that are linked together. Each workbook represents one month of data and the current month links to the previous month. All...

In one of my uses, I am using the colour of cells rather than their contents to signify something. I want colours of some cells to change when I change...

I have a list of numbers that are 6 digits long & I want to sort them (ascending or descending) by the last 4 digits. Is this possible?

I would like to test a condition in a cell and then write something in another cell. For Example my If statement is in cell d23 and this is what I want to...