Registration date
January 28, 2010
Last seen
February 12, 2016
Contributions
4,475
Gender
Male
Location
UNITED STATES OF AMERICA

Single Quote - Excel 2007 [Solved]

Hi, Does anyone know what the single quotation mark ' means when entered at the beginning of a cell? I notice that the quotation mark does not actually appear in the cell. In other words, it appears in the formula bar when entered but disappears from the cell once you press enter. I want to to get rid of that. I need a single q... Read more

Macro Help

Hello All, In short, this is the issue I am facing: I have created a macro to copy and paste data from one spreadsheet to another. Specifically, it takes Columns A and B from spreadsheet 1 and pastes them into Rows 1 and 2 of spreadsheet 2. However, I need to insert spaces so that there are three blank columns between each pasting. ... Read more

Can I get the Autofilter to work automatically without

I have the following which is filter my data based on a cell: Private Sub Worksheet_selectionchange(ByVal Target As Range) If (Intersect(Target, Range("T4")) Is Nothing) _ Then Exit Sub End If Cells.AutoFilter Field:=1, Criteria1:="=" & Range("T4") End Sub However, the cell it is using T4 updates when another... Read more

How to transpose and move data

Hello, Have a data set which is 2 columns and 596 rows, in which I need to transpose parts of the data set, remove empty columns, and then line up the data in 6 columns, 40 rows. Example starting data set (with 4 empty rows between each row of data): 1 1 2 2 3 3 4 4 5 5 ... Read more

fill in automatically

Hello, I have two colum in excel sheet colum A1 contain big list of job titles each one of it have a code for example: Job Title name Code Director of Regulations Administration 1217201 Director of International Trade Departme... Read more

conditional data display depending on a dropdown list

Hello, I would like to creat a form which would display certain data dependent on what was chosen in a dropdown list. For example, if my dropdown list features a number of International Organisations (NATO, African Union, United Nations, European UNion, ...) I would like Excel to display the countries that are members of that one par... Read more

copy data from 2 sheets in 1 workbook to new workbook

Hello, I am new to macros in Excel and could use any help. I want to copy the basic name and customer info from 1 sheet(1) and create a new workbook with that customer's name as part of the file (and copy several cells of data) and then have the new workbook have several rows of checkboxes with titles that I can have set up in the or... Read more

IF Formula Query

Hi there, I have a spreadsheet which using the IF formula should be bringing back either "update Required" or "N/A" depending on if the date in the cell is +21days and greater than today's date. However it is not bringing back the "N/A" false response? $M$1 is ref for TODAY() date. The J column contains either dates, blank cells, or 'T... Read more

Data consolidation

Dears Need your expertise advice. I have an excel data in below format , need a formula Column 1 has text like ABA, ABA , ABB, ABC, ABC, ABC . ( pls note the dublication) Column 2 has numeric value Now my requirement is : In column 1, if 1st row and 2nd row is equal , then the numeric value in column 2 needs to be added and... Read more

Conditional Formatting Problum

Hello, i have excel 2010 i have two rows. a & b i want if row a cell value not equal b cell value then change color cell b. (Note this format apply only one cell i want to copy & past down side then pick value of cell A1 not change A2 or A3. Please Solve this Problem. Thanks Read more

Format cell values to be included in another cell

Hello, I am currently creating a holiday planner for all my employees on Excel 2010. I also want to create a separate cell for each day that shows how many people are available according to their skill set. E.g. I have 4 people that can sign certain documents and I need to know how many are in each working day. The planner is set up s... Read more

Using cell A1 to reflect status of A2-A15

Hello, I have conditionally formatted A2-A15 to visually represent a stoplight for a series of equipment dependencies (RED, YELLOW, GREEN). I have used r=RED... y=YELLOW and g=GREEN for the conditional formatting factors. What I am trying to do now is have cell A1 turn RED if any cell in A2-A15 is RED... YELLOW if cells A2-A15... Read more

excel

Sir I ve the following fields in my database Date Receipt No Ref No Name of the student Fees Tc total 01/04/2015 1201 001 RAMU 300 500 800 01/04/2015 1202 002 RAJ 400 600 1000 02/04/2015 1203 003 K... Read more

Import multiple xmls into a single excel file

Hello, I have > 100 xmls to be imported into excel. Is there a way to import all the XMLs into a single excel? Please help need this urgently. Thanks. Regards AshJey Configuration: Windows 7 / Internet Explorer 9.0 Read more

automatically email notification

Hello, I would like to know how to create automatically email notification when issue overdue. Regards, Configuration: Windows / Chrome 47.0.2526.106

HOW TO GET FILTERED DATA INTO A SEPARATE SHEET

I HAVE MY DATA SHEET WITH FIELDS GROUPED UNDER NAME, REF.NO, SALES . I WANT TO SORT IT ACCORDING TO THE REFERENCE NUMBER AND PLACE THE PARTICULA FIELDS IN SAPARATE DATA SHEETS IN A TABLE FORMAT. KINDLY HELP ME TO DO IT. THANKS IN ADVANCE!

database report

Dear Sir I have the following fields Month Receipt No Ref No. Name of the student Fees Transport Total. We enter the data according to the receipt No that is amount collected from each student. I want how much amount has been collected from each student in table format. So that outstanding amount can be easily taken. Kindly help to ... Read more

Creating an order list from a sales sheet

Hello, I am working of an excel sheet which is updated every time a sale is made. what i would like to do is have a list auto populated which would show all of the items and suppliers that we would need to make an order from? so for example I have sold 3 x model kits from supplier A, 2 x boats from supplier B and 12 tool kits from ... Read more