Excel Forum
-
How to find a blank cell in Particular column? [Closed]
Hello, I want o identify the blank cell in Particular column, and in this my blank cell is my last cell even it would be helpful if anyone suggest...
-
How to copy multiple lines with a Macro [Closed]
Hello! I have never worked with Macros but I strongly believe they could save my current data crunching work (that I need to finish by tomorrow or ...
-
Conditional Formatting through Macro [Solved/Closed]
Hello, I would like to request that how Conditional Formatting would apply through Macro and the Conditions are Range is E11 to E510 if Colum...
-
excel formula needed [Closed]
Hello, Need excel code for min(1-5), N or X Example data: 1. 3. 5. 2 X. --> 1 X. N. X. X. N. -->N X x x x x x x. --> x X 3 2 N. X N...
-
Sum values from one column if another column equals x [Solved/Closed]
Hello, Is there a formula that can calculate the sum of cells from one column if the value in another specific cell equals x (or not blank)? I tried...
-
VBA - Copying Data to new sheets [Closed]
Greetings Excel experts, I'm trying to figure out how to tackle a problem. Basically, I have a master sheet with a bunch of data and I would like ...
-
Weird date display in excel [Closed]
Hello, This seems like a really simple problem to solve but totally has me stumped. I have entered my date as 30/11/15 (DMY) into the excel cel...
-
Worksheet_Change event [Closed]
Hello, I have a vb script worksheet_change I am trying to get a conditional If like statement to work in the code where a condition is met from...
-
Retrieve data from Column A based on condition from Column B [Closed]
I have a set of data in a column. Say like below: Col A Sets Apple 1 Apple 1 ...
-
Autocopy row based on whether the cell in a certain column is [Closed]
Hello, I have a detailed aging report that I am attempting to create monthly tabs in. Basically what I need is a macro that will auto paste the en...
-
Transfer worksheet [Solved/Closed]
Hello, How can I transfer an excel worksheet into another excel file. And when transferred I won't have to modify anything. Right now i'm cutting a...
-
Problem when format date option [Closed]
Hello, I have a date "17/07/15" and "01/07/2015" i want to change it to "July-15" format for all cases. I go through format option and select the op...
-
Excel and dates [Closed]
Hello, I have three columns, for example 19-Nov-15 then 26- NOV-15, I want the third column to = the most recent date of the two +7. because I nee...
-
Copy invoice dates to ledger [Closed]
@vcoolio Read your reply in an earlier post. copied it to my use, but this did not work. please help. I am copying a list of cell entries from invoi...
-
Custom Message Box in Macro [Closed]
Hello, I would like to ask that how could custom message box having custom button will be created. I have a code given below I need a changes wh...
-
How to convert number into words [Closed]
Hello, pl give the solution
-
vlookup or is blank?? [Closed]
hi i need a formula to copy cells that are not blank or error if possible. in th picture attached i want the time to copy to the names with out th...
-
match col A sheet1with sheet2 found write row sheet3 [Closed]
Hello, Need help. I have 2 sheets both contain same type of data in random and also duplicate rows. I need to 1. copy sheet1 row and sheet2 row i...
-
Transfer data from excel sheet to excel sheets. [Closed]
Hello I have a table contains about 5000 rows and 4 columns. The columns are Date, Codes, Department and Amount. I entered one year's data in that ...
-
EXCEL FORMULA [Solved/Closed]
Hello, I'm trying to do a formula like: If value of celA3=sunday, then write dimanche Any help would be appreciated. thanks
-
Scroll mouse in ListBox [Solved/Closed]
Hello, I would like to know that How do I enable mouse scroll in listbox inside a userform. Thanks Configuration: Windows 7 / Chrome 46.0.24...
-
Date Change to dd/mm/yyyy to dd/mm/yy [Closed]
Hello, I Want to change date format dd/mm/yyyy to dd/mm/yy in MS Excel 2003 Please revert me urgently Configuration: Windows XP / Chrome 46.0...
-
Calculation of age [Closed]
Hello All, I have been trying to calculate the exact age of a person from two dates in Office 2007. In the first cell I have the current date and i...
-
create a summary table from a master table [Closed]
Hello, I need a formula to create a summary table from a master table as below : Item Des. year ...
-
Get other cells value [Closed]
Hello, I am stuck in a formula and I cannot solve it. Please I need help. I am making a survey on excel, and I need the result for a whole month ...
-
Compare Excel Sheet1 to Sheet2 and highlight changes in sheet2 [Closed]
I have explained my query in screenshot. Somebody please help me get this resolved.....
-
Export data from one sheet to another [Closed]
I need help. I have a form call Purchase Request from where I want transfer data to different fields in next sheet and then need to raise Purchase ...
-
copying cells if criteria is met [Closed]
Hello, I have multiple sheets with sheet 1 as the main sheet for entering data. A cell for entering a order number Cells for entering invoic...
-
Copy a 'Template' sheet onto multiple other sheets [Solved/Closed]
Hello, i have been trying to create a sheet that creates new sheets from a list and i have been using the following macro to generate the sheets from ...
-
AverageIf function using dates [Closed]
Hi there. I'm trying to set up an average function based on dates entered in column a, for the data in column b. I want to use the data in b if the...
-
compare to columns in v lookup [Closed]
Hello, hii i want to compare to columns in v lookup.. Pls advise ... Configuration: Windows 7 / Chrome 44.0.2403.155
-
Add Sheets to ComboBox [Solved/Closed]
Hello, Hi I would like to know that how to add sheets (which are exist in active workbook) in ComboBox used in Userform. Thanks Configurati...
-
conditional formatting on multiple criteria [Solved/Closed]
hi, i am trying to create an excel vba code for creating a conditional formatting where i want to insert colour on the basis of multiple rules. i am ...
-
Conditional formatting cells containing IF rules [Closed]
Hello, Cell D11 contains the rule "=IF(D4>0,D4,"0")". I have set conditional formatting on the entire spreadsheet to show that if value is grea...
-
Copy data from another sheet if the condition is met [Closed]
Hello, Can you help me how can I create macro that will copy the data from one sheet to another sheet in the same file? Wherein if the Posting Acc...
-
Transfer Data IF.... [Closed]
Hi, I am in the process of building a database for injury management (I am a Sport Scientist). I have a master sheet which is basically a monthly ...
-
Multiple formulas for multiple sheets [Closed]
Hello, I have multiple sheets with sheet 1 as the main sheet for entering data. A cell for entering a order number Cells for entering invoic...
-
Comparing columns in Excel 2010 [Solved/Closed]
Hello all: I have an excel spreadsheet with 95 columns. I want to compare column 1 to column 95 and highlight in column 1 any line item that is mi...
-
Set Rows Height also Exception in Range [Solved/Closed]
Hello, I would like to request that rows from 10 to 40 their height will be Set to 12.75 but exception rows 11, 16, 21, 26, 31, 36 height will be...
-
Sheet List Window [Closed]
Hello, I would like to request that If user want to go to specific sheet it has to either press shortcut key or click arrows button in the left ...
-
Comparing Rows on two worksheets and pull data into a new sheet [Solved/Closed]
My requirement is following: I need to compare Column A, B and C of worksheet 1 to column A, B and C of Worksheet 2 If Above condition is met then I...
-
Find duplicates and highlight them across two worksheets [Closed]
Hello, my request is somewhat simple... I have two list of contacts, name, business name, address, phone number and email address. One was provide...
-
Listing ignoring blanks and avoiding duplicates [Closed]
I have a query but need to send a sample excel file for that. How do I attach a file as I do not see any link for that. Regards. jsexcel
-
IF formula [Closed]
Hello, I've got this formula that is supposed to give me two values however when ever I implement it, it seems to just give me one value all of time...
-
convert a number to a letter code [Closed]
Hello, This is to change a number to a code of letters to hide info in plain site. if my code table is 1 = C, 2 = D, 3 = E, etc thru 9 = K a...
-
Conditional formatting based on text in two different cells [Closed]
Hello, I have created a table with column A,B and C containing text for a risk register. I want to format column C in colours (red,amber or green...
-
Excel: Get Value from Sheet 1 to Sheet 2 [Closed]
Good evening, I need help please about what I am wrong. I have Cells A6 to F6 in Sheet1 has formula in it and I was trying to get the value of tho...
-
Macro to tell which sheet in master workbook is empty [Closed]
Hello, I will be grateful if someone can help me with below code. The code - Sub Demo() Application.ScreenUpdating = False Sheet1.[F2].C...
-
today function [Closed]
Hi, i am using today function in excel, i don't want change the date, when i open other day, it should show the previous date. Thanks Bbbp
-
Remove (Shape) Straight Line [Solved/Closed]
Hello I would like to request how to remove straight line shape through vba It was made through the following vba code Sub Str_line() ActiveSh...
