$$Excel-Macros$$ Need some help to change data format - urgent

Hi All, Need some help on excel calculations: I have a data of employee attendance (daily in/out time). The extract from timekeeping software does come in format for me to analyse it further, Sample file of base data and output required is attached. Request you to pls provide me a solution so th

$$Excel-Macros$$ Invoice rate verification

Hi All, Need your help. I have Item Master (which has effective date of price applicable for a product) and Sales Register (actual date of invoice with item and price charged). I need to check in Sales Register whether the rate applied is as per Item Master. Sample file attached. Please assist.

$$Excel-Macros$$ Staff planning template

Hi All, Need your help to develop a staff planning template (pls refer file attached) I have 3 Team Leads who submit data about proposed assignment and clients, its status, person involved, etc as per the input format sheet. >From the data received from 3 individual TL, every week I need to cons

$$Excel-Macros$$ Excel query

Hi All, I need help on two things: a) I have filtered data from a large range (say A1 to A20). When in copy and paste a formula in visible cells, excel 2007 throws error and copies data in the entire range instead of only visible cells. How do i copy and paste only in visible cells. b) Is

$$Excel-Macros$$ When some data is filtered how to find unique values in excel

Dear All, Need a small help. Is there a way to find unique values in excel when some data is filtered. Eg: There are 1-100 rows in a particular sheet If the filter contains some 20 odd rows based on certain selection criteria, is it possible to find unique values in those filtered cells (20 ro