The discussions
Looking for a excel formula.
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?
Here is the data: A B C 1 Data1 Data2 Data3 2 0002 ABC $3.00 3 0002 ABC $4.00 ...
Excel to find a word within a cell within a sentance
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 cover...
How do i change the formula based on text in another cell...
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" only....
Using vba to assess the result of different input variables
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 a n...
Add blank rows
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
SolvedHi 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....
SolvedHi 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...
Regarding email notification in excel 2010
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
i am unable to change my date format in excel sheet. please help me
Converting rows of data into columns
SolvedHi 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...
My outlook e-mail is not working
Hello, I am having a problem sending and forwarding e-mails from my Outlook. Do not know how to solve the problem. Can you help me? Configurati...
How can i create a macro for a new spreadsheet
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
SolvedHi 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
SolvedHello, 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
SolvedI 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...
Auto generate worksheet from a list
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
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
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
SolvedHi 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
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.
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
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
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...
Adob reader can't save form
Dear All, I created pdf fill form from Bluebeam and when i open that pdf form with Adobe Reader, even i can fill out but i can't save direct to that f...
Reference one column and compare to columns on other worksheets
I am trying to compare zipcodes from other worksheets compared to the main worksheet to return a true or false value. Help please!
Build macro routine
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 ...
Date manipulation
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
SolvedHi 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
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...
Excel formula for percentage of...
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
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
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
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
SolvedHello 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
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
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
SolvedHello, 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
SolvedI'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
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 ...
Macros for create new excel sheet from active workbook
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
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
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
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...
Publisher
I've downloaded the free version of publisher from yourselves but its now asking for a key. How do I get that? Ta
Office instant messenger
Hi, I require a software for internal office communication among office staff. Which will you recommend. Please exclude free IM (Skype, Yahoo, Gtal...
Help to convert a date to julian date fromat yyyyddd in excel
Solvedhi, 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...
Excel:password protected sheets
Hello, I hope someone can please help me in adding a password to excel as admin and user..when a username password is entered it will show sheet 1...
Macro for sending gmail
Sir I need some help my problem is follows. I have a data sheet. I will be updating every day the data sheet. I use a macro to generate a sheet ...
How to return all values matching two criteria
Given this table A B C Number Sector Name 1 21144 P John 2 21144 P Mark 3 21144 P Bob 4 ...
