Excel Forum - solved topics
- Solved
-
Conditional Formatting a single cell based on another range Solved/Closed
I have been trawling around looking for a solution to my problem. I need to highlight/colour a single cell when its value appears in a row elsewher...
-
Conditional formatting a cell if a certain word is met Solved/Closed
Hi I am trying to conditionally format cell B3 if the criteria in cell C3 = NAT I am able to do it if it was a number but not if its a word, If the ...
-
if formula showing date Solved/Closed
Hi all, I created a spreadsheet that has a date in and a date out columns, the dormula I use on the date column is: =if(d2,TODAY(),""). Formula is in ...
-
Excel VBA: Application.FileSearch Error Solved/Closed
Hello everyone, I encountered error "Object doesn't support this action." when the program the line "With Application.FileSearch". Here is my codes...
-
Conditional Formatting Solved/Closed
Hello, Does anyone know if you can set conditional formatting to highlight an entire row if the date in a specific cell is less than a week from t...
-
If data matches in one column, check 2nd column matches Solved/Closed
I've been trying to figure this out for days, I'm sure it's possible but can't get it to work. I have a set of data - in one column there are refer...
-
Help to convert a date to julian date fromat yyyyddd in excel Solved/Closed
hi, i have thousands of dates in format dd-mm-yy that needs to be converted to julian date format yyyyddd. dates that needs to be converted are fro...
-
Is there a way to call out multiple values in single cell? Solved/Closed
Hello everyone, this is tricky and im not sure if i have missed something or if this is even possible, if it is it would be a huge help. I am limited ...
-
due date reminder in excel 07 Solved/Closed
Hello, dear all. I have a "credit list" worksheet having the details like. 1) date 2) invoice number 3) name of beneficiary 4) total amount 5)paid c...
-
ms excel, lookup word from a cell Solved/Closed
A B C 1 C287198 MARIQ BLDG MATERIAL TRDG C287785 C287785 2 C2...
-
Excel Formula Solved/Closed
I have a blank excel invoice that I want to be able to type the Item number on it and have it populate the vital information on it like the item name,...
-
Need Help Please: Excel Click Timer to time each Work/Task Solved/Closed
Hi Excel Pros, This is my first time to join the excel forums and have seen how helpful you guys are here. I need to come up with a visual basic...
-
Copy multiple charts to multiple worksheets Solved/Closed
Hi I have a challenge for which I cannot correctly conceptualize a workable solution so I am hoping someone here can share their thoughts on it. ...
-
Excel Macro: Rename all Worksheets Solved/Closed
So, I'm trying to figure out a way to rename all the worksheets in a workbook. the first worksheet would be "1" (without the quotation marks) and c...
-
Excel Macro help, hiding columns Solved/Closed
So I'm trying to figure out an Excel macro that would hide row A-K on every worksheet in a workbook. Thanks for any help
-
Need help to create an excel macro (Combine columns) Solved/Closed
Hello, Inputs Col A and Col B ( all data ranges are variable), need out put in C Col. (MACRO), I not good at vba/e , kindly help. Col A ...
-
add two type mix font in one cell in excel 2003 Solved/Closed
hallo i have a excel 2003 userform with textbox . I have problem in my data base . I have 2 type font in my data like DevLys 010 and arial. I want to...
-
Recurring date formula Solved/Closed
Hi All I have the following formula in my worksheet =IF($AA$2=2,B8+28,IF($AA$2=1,B8+7,IF($AA$2=3,EDATE(B8,1),IF($AA$2=7,EDATE(B8,12),IF($AA$2=4,...
-
cant format date in excell Solved/Closed
Hi, When I enter the dates as number with out forward slashes, and format them by right clicking on format cells and choosing date the date appear...
-
Lookup same Entry A1 in 2 worksheet & return B1 from 2nd w/sheet Solved/Closed
Hi, I have 2 worksheets. "Master" = Sheet 1 "Status" = Sheet 2 In "Master" Worksheet there are 3 columns, A1-User ID, B1-Username, C1-Status...
-
Macro Range Solved/Closed
Hello, I am somewhat inexperienced in the world of macros in excel. I have a looping macro that runs from the bottom and i want it to stop at ...
-
How to tranfer information Solved/Closed
I am wanting to set up a sheet that inputs information on another sheet in excel. The problem is, I want it to list the information from one section o...
-
I am just learning the basics Solved/Closed
Hello All, I am new to this community. I have just started learning Excel and am having a problem with a formula. the community here from what I have...
-
Create a macro Solved/Closed
Hello, Please help me. I am new at macros, and I need to create a macro that will automatically total a column as below: # Name ...
-
Need help with an IF function Solved/Closed
So, I am trying to get this formula to work. The situation is that one of our items have changed names. In the spreadsheet, I am trying to get a f...
-
Excel date problem Solved/Closed
Hi, How can I change the date format from a format such as 22042013 - (this is not a text format). One formula I have been given is: =IF(LEN...
-
Any part of string in cell matches part of string in another Solved/Closed
First post after hours of fruitless googling :-) Working in Excel 2010.. I have merged two data sets and where there are instances of exact dupl...
-
Conditional formatting can't caputure text...NEED VB CODE PLEASE Solved/Closed
Hello, I understand i can't use c formatting to insert text and therefore am looking for a piece of code that will perform the following. Consi...
-
Conditional Formatting Based On Changing Dates Solved/Closed
I am trying to keep on top of dates that are changed weekly based on last weeks dates, but i need to highlight the changed cells only. Example: ...
-
find and compare calues in two columns Solved/Closed
Hi i need to look for values (strings) in column A and see if exist in column B. if exist return the line number. (tried vlookup but i get only ...
-
Help with cell programming! Solved/Closed
Hi everyone. this is my first time here, and in desperate need of help from some Excel Genie to make my wish come true! Ok, here is my "urgent" pro...
-
Conditional Formatting in Excel2010 Solved/Closed
I wish to have the following CF in more than three colours. I have placed the following in Data List L1,L2,L3,L4,L5,L6,M7,M8,M9,M10,M11,H12,H1...
-
Help needed in using marcos Solved/Closed
Hi, I need to write a marco that is able to compare the specific column in 2 different worksheets within the same workbook. (i.e Names of staffs) ...
-
CONDITIONAL FORMATTING IN EXCEL - off of a range of cells Solved/Closed
Hi I've never used these forums before but this issue has been bugging me for some time now.... so i thought i would leave it to the experts.... I...
-
macro Solved/Closed
I want to write a macro from the start, I have date of employee name and their attendance on a workbook and on the other workbook I have a calendar. N...
-
Excel help on IF formula Solved/Closed
I want to say IF cell L27 equals the word 'low' then do sum of cell x * cell y, if cell L27 equals the work "expected" then do Sum of Cell a * b and i...
-
combining two separate macros into one Solved/Closed
Hello, I currently am using these two separate macros independently but would like to combine them into one with the archive one being first. I'm...
-
Macro to Search/Replace Text from another Column Solved/Closed
Hello, I didn't realize I was being rude on my previous post, that wasn't my intention. I tend to have a "too the point" personality sometimes, and...
-
urgent ansin excel Solved/Closed
a table caring 4 rows, first row is Name, second is address, 3rd row is date, and forth row is house name. how i arrange this in excel in date wise...
-
Popup reminder based on date and additional celll values Solved/Closed
Hi, I am new to this site and have seen a lot of great information and helpful tips here. I have been trying to figure this out for a very long tim...
-
Hide rows with zero value in Multiple sheets Solved/Closed
Please help me in making a macro in the Excelsheet that: I can hide the entire rows if a cell value or (range of values) has a zero value in multiple...
-
Conditional formating Solved/Closed
I have a spreadsheet with Excel 2013 that has text drop down lists. I want to use conditional formatting to highlight with a different cell color, dep...
-
Convert a date field in excel to day of week Solved/Closed
Hello, I know how to format a cell with a date in it so that it shows the day of the week. WHat I am trying to do is sort on the day of the week so...
-
some help needed about IF function with dates Solved/Closed
Hello, i m making a sheet with this function =IF(H1
-
creating pdf from selected cell range Solved/Closed
Dear all, greetings. firstly , I would like to thank those who have helped me to get below code (to create pdf file for selected cell range) whic...
-
how to compare two coloumns in excel Solved/Closed
Hello,
-
Trying to write a code to insert a blank row above a cell value Solved/Closed
I am trying to write a code that will auto insert a blank row above a certain cell value ie: existing: Column G 5 10 20 22 999 2 22 55...
-
I cant open my exel .slxs files Solved/Closed
Hello, am not able to open my exel files(office 2007) which are in .slxs formet. when am trying to open that file windows is showing this message: ...
-
Enter Time by clicking on a cell Solved/Closed
Hello, I need help setting a code in Excel. I am new to VBA but have used Excel for awhile. I would like to set Columns D & E up for time. I want...
-
Conditionally insert a duplicate row Solved/Closed
I have a table with hundreds of rows but here's a basic example: __a___b_____c____ 1 Color Dates Completed (headings) 2 red Date1 No 3 red Dat...