The discussions
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...
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...
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...
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...
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 . ...
Transfering data for a spreadsheet to another
Its not working. May be size (row height & Column Width) not same. Is there any other way to solve this problem.
Auto-copy cells one to another + formation too
ClosedHi! I want to make intelligent excel, like.. i have many sheets and i want it to work the way, that sheet2 takes data from sheet1. so 1) ...
Strike through when entering date
SolvedHello, In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the last d...
Place new code to working code
SolvedHello, I would like to request that some line of code (marks as bold) I have to place in the Working Code which is given below that I cannot figure...
Printing selected columns from multiple sheets
Good day, I recently made a workbook with multiple sheets. I am a newbie regarding Excel. I would like to know if there is a way for me to have ...
If statement or something else to copy from sheet 1 to sheet 2
Hello, I am looking for a bit of help. I am not sure if this has been asked I tried looking at other post. Any Help to point me in the correct dir...
Please helpin creating a macro that will create a new spreadshee
Hello, I would like to kindly ask for help in creating a macro that will generate a new spreadsheet based on the letter entered in a specific colu...
A macro in excel
Issue : I have a worksheet with two columns. First column contains some individual names, and second column contains Residence PIN number of the in...
Export data from worksheet to another excel file
Hi I would like a macro that cam help me export data to another file. I have an Excel form which I would like to move the entries into another ...
Overflow error
Hello, I USED THIS MACRO BUT AN OVERFLOW ERROR MESSAGE APPEARS. KINDLY, HOW CAN I SOLVE THIS PROBLEM ? Configuration: Windows 7 / Chrome 47.0....
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...
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...
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...
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 ...
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. ...
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. ...
Automatically email notification
Hello, I would like to know how to create automatically email notification when issue overdue. Regards, Configuration: Windows / Chrome 47...
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 FIELD...
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 recei...
Vba script to copy data to another worksheet if the conditions
Hi , Can someone help to give some VB script copy data from one sheet to new sheet if the conditions matches. I have a guest list with name, email ad...
Hello, where am i going wrong with this formula?
Solved=P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3),IF(M10>11.8,"CNB",P10) The final result in cell AV10 must be the value in cell P10 plus ROUND(SUM... [H...
Conditional formatting
I want a cell to change colour if the value in another cell is negative
Code macro how to select used rows of a column
Hello everybody, I'm struggle with my macro code. I would like to copy data to a worksheet and paste them to another. My problem is everyday the...
I want to build intelligent excel
SolvedTask is: For example I have list of different fruits in cells in separate rows Apple Pear Plum I want the data to be copied to third cell,...
Extracting multiple date from master sheet to new sheets
SolvedHi I run a sports tipping site and I want to extract data from my master sheet to make other sheets. I.e in sports cloumn I have multiple sports and w...
Specific price depending on the words in 2 cells? please help
SolvedHello, I am using excel 2008 for Mac, i need help with the following: example: A1 has a drop down box of 3 choices, apples, pears and peaches ...
Excel 2013 has stopped working
SolvedHello, Every time I'd open Excel 2013 under Windows 8, it would crash instantly, leaving me a message: "Excel 2013 has stopped working". I looked ...
Format one cell based on a text value in another cell
Hi I'm trying to change the colour format of one cell with a text value based upon the text value of another cell, but cannot get it to work in exc...
Popup message
Hello, I have a worksheet with several column displaying numbers. I wish the worksheet to popup a message when the number decreases below 21 to po...
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 woul...
Make in to single row in exce;
Hello, I HAVE EXCEL DATA IN THE BELOW FORMAT 93456787 BR129 11-10-2011 12:34:00 PM 93456787 BR140 16-9-2012 11:24:00 PM 93456787 BR1...
Formula to pull out text in description
Hello, I am looking for a formula that will produce the following results: Actual: A1. Cash 10/2/15 A2. CC Application 10/4/15 A3. Check 10/1...
Date and amount
Hello, I need to write a formula to give me alarm by turning the cell to red color and the formula is about the following: If the amount in Cell...
How do i code using a cell?
Hello, I want to make a code that takes "50,41,62,62,60" and change each number to a letter so it's says something like a phrase such as "hello" h...
Find data and copy dynamic range
SolvedHello all, I would like to find text in one column and copy the range values which is adjacent to the text searched. I've attached the sample...
Resize the range
SolvedGreetings, I would like to resize the range without keeping the starting position. I've attached the image In the above example, while usin...
Macro to cut and paste into next available row in another sheet
Hello, I am very new to Macros and I am trying to write one that will cut the data in cells F3:H13 on sheet 1 and paste them in the next available...
Comparing two sheets in excel to eliminate date
I have two lists in excel, one is a full list of data and one is the list of data that I need to eliminate from the first. How do I compare the two li...
If formula
Hello, I have to keep track of utility bills for my company on a month to month basis; is there an "if" formula that I could use to alert me if I have...
Excel 2013 macro
Holà! I am currently using this macro created by a former coworker to create & save as, a couple dozen excel workbooks. (This is just a section to...
Using the if function for dates
SolvedHello, I am trying to figure out in Microsoft excel 2010 the appropriate IF formula to use. I am trying to calculate the number of working days th...
Number conversion to code
Hello, Hello, I appreciate any and all who may give this issue some consideration. This is to change a number to a code of letters to hide ...
How to separate the worksheet based on data
Dear Sir. I had the data as mentioned below for your reference CODE EMPNAME EB HRA GROSS 175702 MAURICE J P 10,140...
Copy data without opening workbook using vbscript
Hello all, Is it possible to copy data without opening workbooks using vbscript? Thanks in Advance!
Help writing a if formula
SolvedHello, I need to write an IF formula for excel. Cell A2 will either say ''receive'' or ''deliver''. This formula works IF(A2=''receive'',1,2);...
