Excel Golf Skins Sheet

Okay, first I should mention that I'm a complete amateur when it comes to excel. No VBA or macro experience, so if you're not sure whether I know something yet, I probably don't.

I have a workbook with 6 worksheets inside; One of the sheets is a master; it's simply the other 6 sheets compiled into 1 big one. I need to set it up so that any new data entered into the new separate sheets is automatically entered into the master sheet, in the first blank row.

The columns are not the same across all the sheets. Hopefully, this will be easier for the pros here than it's been for me, I've been banging my head against the wall on this one. I'll be checking this thread r...

Configuration: Windows XP / Firefox 3.6.3

i would like to say happy birthday to each of my employees on there spreadsheets in excel 2007. I am having a hard time to get each of there birthdays to work , I can get it to work for today's date, but I need there birth dates to work as the day comes up. any help with the formula would be a great help.

Thank you

Hello,

Okay, here I go. I have a workbook which contains a tab (CalendarData) with information as follows:

Column A - Name
Column B - Apt #
Column C - Initial Follow-Up
Column D - 30-Day
Column E - 90-Day
Column F - 180-Day

The calendar tab is simply called 'Calendar'

I need to have the information in Columns A & B populate the dates on the calendar which coincide with Columns C, D, E, and F.

Can anyone help me with this?

Hello,

We have a Excel which is saved to a network drive and used by multiple users. What I need is when somebody updates the excel sheet or puts any value or comments on the sheet, it will notify me or auto mail me that the excel sheet is updated. I mean instead of going again and agian to check whether somebody changed the sheet or not it will notify or auto mail to me.

Any kind of help appreciated. Whether I need any software or any VB, Macro can solve the purpose.

Thank you,
Satya

Hello,


I need help to write macro to compare two sheets, sheet1 and sheet2 on same excel book and display the result on the third sheet.

The number of rows and columns may not be equal and it can vary each time. So, we need to find the range of columns and rows first. I am struggling with this.

I tried the following code to compare the values,
Sub Macro7()
'
' Macro7 Macro
' Macro recorded 12/11/2008 by UBOC User
'
'
Range("A2").Select
ActiveCell.FormulaR1C1 = _
"=IF(SIT!RC=PPE!RC,"" "",CONCATENATE(SIT!RC,"" - "",PPE!RC))"
Range("A2").Select

Hi All,

How do I put a cell value into a cell when the range of cell contain a specfic text.
For example, in the sample below, I want to put the cell value (13/2/2014) into B3 when a range of cell (A) contain Sam.




A1 Tom
A2 13/2/2014
A3 Sam
A4 15/6/2014

B1
B2
B3 13/2/2014
B4


Is it possible as well that I can copy the cell value (13/2/2014) to all fields in column B till it reaches TOM (A1) for example?

Please enlighten me.
Thanks