Excel Forum
-
microsoft excel large file [Closed]
Hello, Im working on huge file of excel. I have many different collums and rows. What i need: I need to copy all data from on generated...
-
vba find replace adjacent cell and go to next find if not found [Closed]
Hi, I am trying to write a code to find REO in column A and if found replace cell in column B with "(((". Then I want to find AAA in column A...
-
"COUNTIF" function for day of the week formatting [Closed]
Hello there, Please help! I have a column of dates, where the formatting I've set for "Day of the week, month, day, year". How would I run...
-
UserForm ListBox save data and modify [Closed]
Hi, I'm new to this forum and certainly new to VBA. I have a UserForm with 4 listbox. The users select items from the first listbox, they press...
-
Automatically move a row to another sheet [Closed]
Hello, I have a sheet named SENT SMS with information about clients, the service they got, price, if paid or not. In the column P named PAID ,...
-
Excel macro [Closed]
Hi, I'm doing a project which requires excel macros but I'm not familiar with it. There are 2 worksheets 'AMBS Master' and 'fy2013'. The data...
-
Transferring Selected Data from Multiple Worksheets to One [Solved/Closed]
My team uses an excel to track our projects. We have many tabs (8) , but on each tab on Column A, we have a drop down menu that we can select if...
-
Automatically insert multiple pictures in excel under 1 ref [Closed]
Dear all, I hope to find some help here as I would really like to find an easier way than just insert each picture manually. I am not a pro in...
-
More than one rule in excle [Closed]
From the image posted I want to be able to highlight the row when the done column is empty and is not today's date.
-
locking a range based on a value of a cell [Solved/Closed]
Hello, first I would like to thank every one working at kioskea my issue is , I want to lock a set of cells ( A2:M2) if the cell M2="app"...
-
Removing duplicate data [Closed]
A call for urgent help to anyone out there. In capturing data from archived files I saved this both on my laptop as well as on a plugged in...
-
require help to count number [Solved/Closed]
1652 1646 1650 1658 1622 1651 1659 1582 1599 1606 1611 1657 1745 1937 1936 1648 1666 1656 1636 if i type like this in diffrence...
-
Grater then , less then with number range multiple [Solved/Closed]
if the numbers cell A110 means the cell B1 have to calculate the C1 cell and if A1 20 means the cell D1 have to calculate ...... please let...
-
Macro-Microsoft Outlook-Export Subjectline, To:, cc: and Subject [Closed]
Greetings Kioskea Experts, It has always been a pleasure to approach Kioskea team who always welcome problems with open arms, that is not...
-
Relative worksheet reference in formula for chart data ranges? [Closed]
Hello, I am working on a project and was hoping for some help any and all excel wizzes if you have the time. Does anyone know how or if one...
-
converstion of xls file to xlsx format [Closed]
Hi I had recovered my lost xls format file and tried to open it with excel 2010 version. how can i view it in the new version. Is it possible to...
-
Excel "If Then" Formula [Solved/Closed]
I am looking to create a "If Then" formula for Excel that can put an "X" in the cell if the date I am reffering to (Cell A6) is 0-5 days, next...
-
comparing three columns and giving back specified values [Closed]
I want search for strings I have in source(A) in both source(B) and source(C) and when it finds those documents give them the three revisions I...
-
Search and transfer data between workbooks [Closed]
Looking at reviews, I know this request will have a simple answer. I am new to Excel, and I need help on this spreadsheet. I have workbook open....
-
Moving data from one spreadsheet to another on Excel [Closed]
I really need to be able to set up a macro & formula so that once I pick an option from a drop down list on my work book, that will automatically...
-
Need help comparing dates... [Solved/Closed]
I have dates in one column, I want to enter a $0 value in another column if that date is >= 5 years in the past. Obviously, I'm a relative newbie...
-
Grey out an entire row in Excel 2010 depending on a cell's value [Solved/Closed]
Hi all, I am trying to grey out an entire row in excel 2010 depending on a cell's value. Each cell has a drop down list: Yes, No, Maybe etc...
-
automatic copy on excel [Closed]
hi sir/mam, i want to automatic copy a data from sheet to another. all those qty on out column in big warehouse sheet must be copy to small...
-
Excel 2003 Date format [Closed]
Hello, Excel 2003 Date format yymmdd I use Excel 2003 (because I like it) and use the International date format yymmdd (it is the shortest...
-
Step by Step help creating a link [Closed]
Good afternoon all, I would like to create a link in a cell that will create a new worksheet in the same workbook. I am new to VBA and Macros...
-
If function with dates in one cell and numbers in other one [Closed]
Is it possible to use if function for following: I have dates in on cell and numbers in other one. Dates are for the whole month and numbers are...
-
How do I make relative worksheet references?-excel 2010 [Closed]
How can I reference the current sheet in a formula for a chart data range?
-
Reference the current sheet in a formula for chart data ranges? [Closed]
How can I reference the current sheet in a formula for a chart data range? I am making a large number of graphs; each one references data on...
-
Less than/greater than [Closed]
I need a formula that will allow me to show if any cells in a range have a greater value than 100,if so show "YES". If not, have cell remain...
-
Create a worksheet when information is typed in a cell. [Closed]
Hello, I am trying to have a new worksheet created (from a template) when I type information in a cell. For example, if I type Ellen McKay...
-
Auto Generate a new worksheet from list in another worksheet [Closed]
How can I automatically create and name worksheets in a workbook based on a list that exists in another sheet "Summary" in the workbook? The list...
-
Automate Excel to shift data so the values in two rows match? [Solved/Closed]
Hello! Please help me with this quandary for my internship. I would greatly appreciate it :) Here is my problem: I want to match ID numbers in...
-
Excel Auto-Data Transfer [Closed]
Hello, 1. How do you transfer a whole row of data into a new tab if an X is put in the first blank column of data 2. How do you move a whole...
-
Copy X Row N Number of Times [Solved/Closed]
Hi. I need the formula to Copy X Row N No.of Times. For Example Col 1 Col 2 ABC 3 DEF 5 GHI ...
-
copying data in excel -only figures but not formulas [Closed]
I would like to copy data from one worksheet to the other but do not want the formulas and calculations to pass from one worksheet to the other -...
-
Need help for Combination macro [Closed]
Hi someone, Please help me out the following problem. I have 10 nos. of machine as A, B, C, D, E, F, G, H, I, J and K. Combined to 2, 3, 4, 5,...
-
Need to total a column with text in it? [Closed]
Hi I am looking to total a column that has specific text in it. e.g My column has the words Leave, Public Holiday or Sick in it so at the...
-
DATABASE FORMAT [Closed]
I kindly needed help on developing a workplace using database format for entering my medical equipment such as specification, model, serial...
-
Conditional formatting based on information in two sep. Cells. [Closed]
Hey guys. This is for Google sheets, but since its mostly the same, the answer should work. Heres my problem. I have a Data point in B3/B999....
-
Vba Code worksheet with a list of 67 competencies and 3 criteria [Closed]
Hello, I have a worksheet with a list of 67 competencies and 3 criteria for each competency. A button is created on the same sheet such that...
-
Who to identify least one in excel [Closed]
Hi, I have 10 Cells can be filled with between the text "L1" to "L20". In that we want find what is the least LXX text is . Someone can we help...
-
Macro Help Needed - Copy data row(s) from column into new file [Closed]
Hello and thank you in advance. I was trying to follow along with the answer given here, but I'm not well versed in macros....
-
Change Date Format - dd/mm/yyyy HH:MM:SS to mm/dd/yyyy HH:MM:SS [Closed]
Hello all I have some 1000 cell of date format. which has " 13/05/14 16:53:59 " Excel not recognize as date.. How can I change.. Tried...
-
Running a Macro Automatically [Closed]
Hi Guys, I'm using the below code in VBA to hide and unhide colums in Excel. Sub Hide() If Range("A1") = "Summary"...
-
add blank rows based on the value in a cell. [Closed]
Hello, How to add blank rows based on the value in a cell. Say if value in cell is 9, then 9 number of blank rows to be entered...
-
Change the text colour based on the value in the cell [Closed]
Hello, I want to change the text colour if the value is between -10 to 5 to green and the value between 5 to 40 amber and value between...
-
Automatic data transfer [Closed]
Hello, I have two tabs in a work book, Materials and Hire. In materials I have column A - PO Number Column B - Job Number and Column C - Date...
-
Autofill cell with color based on deadline [Closed]
Hello, I would like to ask for help on a task I need to do dealing with dates and deadlines. I have "C" with the due date of the task and...
-
Need to pull data from particular cells and add to another sheet [Closed]
I've got about as far as I can with my limited knowledge of Excel so am searching for guidance, any and all appreciated. I have a sheet which...
-
Split of row data into different subsequent rows [Closed]
Dear Sir, I have query relating to split of data of one row into other subsequent rows upto certain number of characters till the width...
