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
Hello, How many times we can use IF function in single formula?
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
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
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
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
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
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
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
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
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
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
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
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
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
Hello, The date format is as follows : Dec 15, 2015 10:47:52 AM, I need to change to the format "DD/MM/YYYY". Could you please help me with this. Configuration: Windows 7 / Chrome 47.0.2526.106
Hello, I would like to know how to create automatically email notification when issue overdue. Regards, Configuration: Windows / Chrome 47.0.2526.106
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!
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
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