Excel Forum
-
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 pro...
-
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 sheet ,...
-
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 increme...
-
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 then d...
-
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 leave it...
-
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 to ...
-
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 column ...
-
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 with Ex...
-
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 data. ...
-
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 Day...
-
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 elsewher...
-
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 Equivalen...
-
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 into a ...
-
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 the Ma...
-
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 the ...
-
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 into ...
-
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 please he...
-
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 ent...
-
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 to h...
-
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 a t...
-
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, then ...
-
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 disable...
-
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 another da...
-
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 - 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 (rou...
-
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 presente...
-
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 differen...
-
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). I ne...
-
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 contains. I...
-
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 (exa...
-
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-10800 th...
-
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...
-
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( or in...
-
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-Nov13. t...
-
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...
-
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), copy ...
-
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 button...
-
Macros for create new excel sheet from active workbook [Closed]
Hi, could you please provide a logic for create new excel sheet from active workbook, please find the my code below. Private Sub cmdCFUploadFile_Cli...
-
Comparing two spreadsheets - deleting rows in one [Closed]
Hello: I have a requirement to do the following: - Spreadsheet #1 contains several columns of product data, including SKUs. It has several thou...
-
if function with dates [Closed]
I'm building a personal finance tracker, and I'm attempting to get a function to tell me which week of the month I purchased something in. Right now ...
-
Comparing text values in 2 Excel sheets [Closed]
Greetings all, I am looking to compare the text values in 2 Excel sheets and output them to a 3rd sheet. Trying this in Excel 2010, and am a littl...
-
Conditional formating issues [Closed]
I am using the NETWORDAYS function in column T comparing column H and I. So far so Good, I then apply conditional fromatting to the values to where ev...
-
vba for selecting names one by one from the drop down list [Closed]
I created a Report Card using excel for my students' to see his/her marks after each exam. The Excel file contains three sheets. First sheet contain...
