rizvisa1's profile

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

Hi, That means the value being enter is text. It is like if you want to write 001 in a cell, generally Excel would convert it to 1 but if you write it as '001 it will stay as 001.

IF Function

Hello, How many times we can use IF function in single formula?

in versions of Excel 2007 and up, you can use up to 64 nested IFs. In older versions older than 2007, the threshold is 7 nested IFs. Any ways some thing is really wrong is such deep nested if is used (IMHO)

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

It is hard to see here, Could you add a screen shot of how it looks like and how you would like it to be

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

then why not make selection off that cell.

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

How are you transposing the columns. To me it looks like you just copied to data from Column 1&2 to column 3&4 and column 5&6 then moved one row down and did similar for others

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

Since you said the list is big. Best option would be to have a hidden sheet or a visible sheet, where all the titles and codes are listed. The you can use the vlookup to populate the codes on your regular sheets

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

You said Form. Do you really mean form or you mean sheet. In either case you would have to have this information saved where country and organization to which they belong to is stored to be then later use for the dropdowns

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

Little confused. In you new workbook there is sheet named Bielen. However there are other sheets too (McGregor) It looks like to me that you have a template workbook. Based on the data entry, you want to populate that template workbook and save it with a new name

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

Try this =IF(AND(ISNUMBER(J35), $M$1>=(J35+21)),"Update Required","N/A")

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

you said later you would delete the duplicate data so ideally you would rather see data like this Column 1 Column 2 Columen 3 ( result ) ABA 2 3 ABB 3 3 ABC 3 8 Is that so ?

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

So from what I am getting is that lets say you have 3 rows populated R1, R2, and R3 you can to compare a cell in R2 vs a cell in R1 and if not equal apply format to whole row R2 then you want to compare a cell in R3 vs cell in R1 and if not equal apply format to whole row R3

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

How is your sheet laid out. A sample of how things are and how ideally you would like to see would help

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

You will not be able to use color to conditional format. What you can do is have A1 be a conditional format based on a OR conditions example for red a1 =OR(A2 red condition, a3 condition... a15 red condtion)

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

Actually, this sentence of yours feels very rude "I expect appropriate answer for my question. " People here, are giving time out of their own good will. At the most you should "hope" rather than "expect" See this thread https://ccm.net/forum/affich-258700-interesting-question-for-excel-champions

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

into single excel means into single workbook or into single sheet. Single workbook is quite possible, but into single sheet would depend on amount of rows

Date format change

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

i am sure you are aware of using of formatting. So I am presuming that change of format is not making any difference. It would be due to that in excel dates are internally stored as number. So if you click on the date and then go to Data, text to columns, make sure Delimited is highlighted and press next. unselect all check box and choose...

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

do you plan to keep workbook open all the time, or do you plan to send email once the workbook is open

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!

see if this helps https://ccm.net/forum/affich-258700-interesting-question-for-excel-champions

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

so potentially you would have two rows for a student with two receipt number(lets say one for transport and one for fee)

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

I thought you said the sheet is already auto updated.