Excel Forum
-
attach and excel file in kioskea [Closed]
can you send me a stepwise info to attach an excel file. I am new to Kioskea and do not see any button or option. I have a question but need...
-
looking for a excel formula. [Closed]
Hello, i have rate sheet of 20,000 entries. rate sheet have data like this. ---------Rate-1------Rate-2-------Rate-3 A-------0.16211 B-...
-
How do I create a seperate .XLSM workbook for each list item? [Closed]
Here is the data: A B C 1 Data1 Data2 Data3 2 0002 ABC $3.00 3 0002 ABC ...
-
Excel to find a word within a cell within a sentance [Closed]
2 things... 1. I need to find a word (several individual words actually) within a cell that is part of a sentence. The search will need to...
-
How do I change the formula based on text in another cell... [Closed]
Example: In column C, I have either "C&D", "Concrete", "Dirt", or "Asphalt". Column D is a weight. Column E is the weight *$30 for "C&D"...
-
using VBA to assess the result of different input variables [Closed]
Hello, I have absolutely no idea how to go about this problem, and my VBA skills are quite weak. I have this data, consisting of 3 columns and...
-
Creating search and update command buttons in a userform [Closed]
Hello, Good afternoon. I am just new here. I am glad that i found this forum where in every one has right to inquire about solutions to there...
-
add blank rows [Closed]
Hello, I am facing a problem in my excel sheet. i shall highly grateful to you if kindly give me a solution to my problem. In b column of the...
-
excel VBA [Solved/Closed]
Hi all, Greetings, could I get help, I am trying to write data into cells in a spread sheet, using an initial value, then adding a specific...
-
YES OR NO...IF SO.... [Solved/Closed]
Hi I need to ask a cell to do two functions. So if a cell (drop down list) has yes/no...then another cell will.....when yes is selected...
-
Need to move data from one sheet to another with a comparesion [Closed]
i have a column name bld_id in both sheets , need a compare if value is same then move the second column to sheet 2
-
Regarding email notification in Excel 2010 [Closed]
Hello, I am preparing a sheet for my company leaves and in this sheet I want users to put their leave date and once they make changes in the...
-
changing date format [Closed]
i am unable to change my date format in excel sheet. please help me
-
Macro to Export Data to New Sheet with tabs [Closed]
Hello, I am trying to create a way to export select data from a spreadsheet to a new one and send certain bits of data associated with a number...
-
add row [Solved/Closed]
I am trying to create a macro that will insert a set amount of blank rows into an existing spreadsheet Here is a sample: Currently: in...
-
Converting Rows of data into Columns [Solved/Closed]
Hi everyone, I hope you all can help. I have a file in with 17,000 lines of data in rows that I need converted into columns. I don't work...
-
How can I create a macro for a new spreadsheet [Closed]
Hi I need to create a Macro that generates a new spreadsheet based on the values that have an X on the third column. Here is an example of the...
-
Macro to traspose data [Solved/Closed]
Hi I need a help I need to transpose my data following way for a longitudinal analysis; ID Day1 Day2 Day3 Day4 Day5 ...
-
want one cell to be highlighted if i type something in next one [Solved/Closed]
Hello, I want B1 to be highlighted as green if i type any text in C1. Please help me. Regards Saurabh
-
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...
-
Change Event [Closed]
Hi, Excel Change Event : VBA Break up :1 STI Current Investments 0.000 2,616,970.000 INV Inventories 125.000 125.000 CS Cash & Cash...
-
Auto Generate Worksheet from a List [Closed]
Hi Can anybody help me please..........:-) I am trying to set up a "defect register" in an excel worksheet whereby information inputted...
-
VBA code which append all the data to the Master sheet [Closed]
I have A Master Excel sheet which I have linked to 15 different excel files with same variables. I need a VBA code which append all the data to...
-
excel vba [Closed]
please know how create in userform in excel and vba of Find Add, Update and Delete Just from User form | I have already made User form
-
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...
-
transfer row entries onto another spreadsheet/form [Closed]
Hi Can anyone help... I am trying to link information from one spreadsheet onto a form my office are using. At present they make an entry...
-
need some excel help please. [Closed]
Hello, I am trying to auto populate a singal didget number from a date off of a spread sheet into another spread sheet. could someone...
-
How to capture highest/lowest values/dates over time [Closed]
I'd be grateful if anyone knows the answers. I've been using an Excel spreadsheet to determine the total value of stocks I own. Basically I...
-
conditional formatting [Closed]
I want to do conditional formation in that i have two columns where A (Due Date) & In B ( Remark) if my validation due date is pass then i want...
-
Excel to Word [Closed]
How do I take a document which was created in Excel 97-2003 [spread sheet] and transfer it to Word 2007? Thank you
-
Reference one column and compare to columns on other worksheets [Closed]
I am trying to compare zipcodes from other worksheets compared to the main worksheet to return a true or false value. Help please!
-
Create a Macro to Copy Columns and Paste in New Workbook [Closed]
I have a current workbook and want to be able to paste certain columns in a new excel file if the first column value = upload. The new workbook is...
-
build macro routine [Closed]
I've tried but failed. Can anyone build an excel macro just to copy a row of 3 cells and paste down the blank cells until the next filled cell,...
-
FILTER Function Not Working [Closed]
Good Morning Sir, I m suren from chennai, i m working in excel i have filter but sudden it was not working in the menu bar filter oprion is...
-
Date manipulation [Closed]
Hi, I have 4 columns approx 250 lines long. They contain expiry dates in the dd/mm/yyyy format. I wish to compare these dates against...
-
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...
-
Excel - Calculation Based On Dynamic Criteria [Closed]
Good day, I have this question as followed:- I have a table as attached file where I already created a macro to repeat the lines based on the...
-
Individual Scorecard Template [Closed]
Hello: Recently I have been tasked with creating individual scorecards for 300+ employees. The data is derived from 4 .oqy cubes that are...
-
Individual Scorecard Template in Excel 2007? [Closed]
Hello: I've been tasked to create customer service scorecards for approximately 300 employees from pivot tables that come from at least 4...
-
EXCEL Formula for percentage of... [Closed]
Hi there, I'm having tough time with this one and I would really appreciate help. My 'F' column contains different values including 0 (zeroes)....
-
How to split a cell based on #27 line break [Closed]
Hi All! First to all thanks a lot for your assistance! :) I'm trying to split a cell into two based on the # of linefeeds that it...
-
Auto email send to Recipients update in spreadsheet using Excel [Closed]
Hello, I'm new to this forum. Currently I have a shared workbook that link to multiple user for update. I have a column for having the person...
-
Nested if problem [Closed]
What is the problem in my formula IF Salary is less than 5000 than house rent Salary*55% but not less than 2500 IF Salary is less than 5001...
-
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...
-
Comparing and copy cells VBA script [Closed]
Hallo, I need some VBA script to compare two cells like ex: A2 with B2, A3 with B3 and if B2 or B3 is empty should A2 or A3 be copied to Sheet2(...
-
List Dates in Column A1 [Closed]
In column A1 i need dates lets say 1-Nov-13 numbering for an entire year. The tricky part is i need Cell A1,2,3,4 to have the same date. 1...
-
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...
-
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...
-
code this in VBA for Excel [Closed]
Can anyone code this in VBA for Excel? If active cell is not blank, then select range from current cell plus 2 cells to the right (ie A1:C1),...
-
Delete Row [Closed]
morning im trying to get a macro that can delete a row in my table. i either need it to be a delete button on each row or a delete...
