Excel Forum
-
Text in Macro Closed
Hello, I'm new to writing macros and wonder if anyone can help me with a couple of areas I'm stumbling on? Firstly, let me say that I am wr...
-
Conditional Formatting Excel 2007 Closed
Hello, I am trying to create a rule that when "yes" is selected in the drop down menu in cell F3 cells from A35:D39 are filled yellow, and if "no"...
-
setting up Excel to pick numbers for my list Closed
Hello, I would like to use Excel program to pick 6 numbers for a list i have. can ths be done? Thanks Configuration: Windows Vista Internet Explo...
-
Open Excel document from desktop Closed
Hello, When I right click the mouse on the desktop, I am unable to open the excel document from the shortcut menu. The excel document does not sh...
-
Macro to create files based on the contents Closed
Hello, I want to create a macro which creates files based on contents in column AJ. I want the macro to copy the data from original sheet to the re...
-
Excel Date Format Closed
Hello, I receive a report that has the date displayed as just numbers. Example: 20120131 How can I change the data to read: 01/31/2012 ...
-
Macros in Excel so it copies onto next row Closed
Hello, I'm trying to copy values from one sheet to the other in excel via use of a macro. The data is in rows, and is there anyway that I can progr...
-
Excel help Closed
Hello, I have a sales performance sheet where I always update the sale. There is a column for the overall average sales where I need to upd...
-
Excel: Replacing a Range with another Range Closed
Hello, I am trying to create a drop down menu with 12 options in it that will replace a range of data with another range of data based on what you...
-
Macro: Insert blank row variable n times Closed
Hello, I am building a University Timetable. Each subject we offer occupies one row on an excel spreadsheet, we have about 200 subjects in total. ...
-
both rows and columns lookup Closed
Hello, Can anyone please help me on how to set up a formula for both rows and column lookup? here's an example Fruit Price1 Price2 Apples 0.69 0...
-
Excel 2007 Dropdown list from multiple column Closed
Hello, I hope all is well. I am back again with some questions and would appreciate any ideas/tips you may have. I am trying to create a dro...
-
Excel - Calculating # of people per job title Closed
Hello, I have a list of employees and all of the pay types that have been paid to them over the year, and their job title. i.e. Joe s ...
-
Need help creating a macro Closed
Hello, So here's what I have.... 7+ files with multiple contracts created in excel. Each contract contains many different fields of informatio...
-
excel conversion Closed
Hello, Need assistance setting up a formula to change this format yyyymmdd to mm/dd/yyyy. Is there someone who can provide step by step instruction...
-
Excel Formula to auto move & populate field Closed
Hello, I am builidng a spreadsheet that shows progress week by week on two sheets. Weekly Status and Project summary sheets. I am building it so...
-
Excel Help ASAP - New PC at Work Closed
Hello, Hi there, I jsut got a new PC at work and although I have my date coloumns formatted to dd-mmm-yy, when I try to key 7-31, instead the ...
-
macro to compare two excel sheets Solved/Closed
Hello, I need help to write macro to compare two sheets, sheet1 and sheet2 on same excel book and display the result on the third sheet. The ...
-
Help in Excel Closed
Hello, How to update the cell automatically? Eg: If the cell N32 assume the figure is 250 on 23/07/2012, then the cell N33, should be =...
-
Excel Help Solved/Closed
Hello, I have a schedule for the employees, and it contains seven columns as 7 days in a week. If any range of the columns contains text " ...
-
Same values in different cells in row Closed
Hello, Sub: Auto fill of Same value in different cells in a row using Macro button Hi frnds, Can anybody tel me how to auto fill of same value i...
-
Help required to create autofill macro in row Closed
Hello, Sub:Auto fill of Same value in different cells in a row using Macro button Hi frnds, Can anybody tel me how to auto fill of same value in...
-
excel - compare 2 files Closed
Hello, here's my scenario: I want to compare 2 columns from 2 different excel (2003) files which contain similar data, e.g. file1 column1 1....
-
Excel: Comparing two columns and output data Solved/Closed
Hello, I'm using Excel 2007 and am trying to figure out a way to analyze and sort some data. I have two sets of data in 6 and 5 columns in the sa...
-
Data to another worsheet in excel based on... Closed
Hello, I have got an excel file where I have collected datas each second. I would like to copy rows of data to another worksheet based on the t...
-
excel query: linking data Closed
Hello, I have three workbooks. A, B and C. columns in workbook B are linked to columns in workbook A. Now i want to link one of the columns (eg c...
-
Excel spreadsheet comparisons Closed
Hello, I have a large spreadsheet that I need to compare weekly. I have 5 sets of 4 columns within the same worksheet that need to compare to a sin...
-
How to make Excel Dial Pro work? Closed
Hello, I have been trying to make Excel Dial Pro work but every time I double click on the number (on the excel spreadsheet) it just dials the num...
-
Problem with excel Solved/Closed
Hello, I was trying to write a formula in excel where IF A1 is greater than 7 then 1 would be substracted from it and if it is greater than 5 but...
-
Excel Query - Matching more than variable Closed
Hello, Hope you can help! I am trying to match two values in two seperate columns and then return the value in the third column? For insta...
-
Doubt in Excel macros Closed
Hello, Hi ppl, I have a small doubt with respect to using macros in Excel sheet. My requirement is as below. I have a large piece of data in...
-
Trying to merge rows Closed
Hello, I am trying to merge various rows of data with a common heading in Column A. For example I have the following data: A 1 0 0 0 0 A 0 ...
-
Excel Text to Column for Multiple Column Closed
Hello, I need help on a task envolve with Text to Column. Below is example. select all / copy / paste on excel spread sheet, you will see it bet...
-
Macro to Add Columns in Excel Closed
Hello, I have a spreadsheet to track patient information. It has the potential to grow out to the right based on number of contacts made. I need...
-
Excel formula - sumproduct Closed
Hi there, I have a formula that I pieced together, which I thought would work but unfortunately it doesn't and I can't figure out why. The need the...
-
Computer browser services Automatically Stop. Closed
Hello, Computer browser services Automatically Stop plz answer me Configuration: Windows 2003 / Internet Explorer 6.0
-
Please help me develop an exel macro Closed
Hello, I need help developing an excel 07 macro that will allow me to copy a selected cell and be pasted in a black cell in a certain column. Ex: cop...
-
Excel: Splitting of data based on calculation Solved/Closed
Good day, I would like to seek help to how to split and populate data based on the result of certain calculation. Here are the criteria for the...
-
how to show my result from macro to worksheet Closed
Hello, I need help... how show my programme result from macro to worksheet in excel? please give me some example? thank anyway Configuration: ...
-
Finding matches within groups of cells Closed
Sorry for the confusing title! An example should clarify. Here is a link to an image of the excel program I reference in my question: http://i.st...
-
Excel formula not working right Closed
Hello, I am trying to write a formula for the following situation and for some reason anything I come up with is not working properly: if R2=...
-
Add rows in sheets based on an entry in theor Closed
Hello, I am trying to create a row in a separate sheet with the data that was inputed in the original sheet. Can you help? Configuration: Windo...
-
Compare two columns text Closed
Hello, If the text of any cell in column-A matches with the text of any cell in column-B, copy entire row to next sheet. Like Column-A ...
-
Excel '03 Formula to count items in 2 columns Closed
Hello, I just need a little help. I'm trying to use the CountIf formula to reference two columns of data. I've been using this formula: =COUNTI...
-
Excel Closed
Hey - created a speadsheet - has 13 sheets. A "Master" and one for each "month" of the year. Master containes rows of information: Unit numbers, date ...
-
macro error when trying to paste ??? Closed
I wrote a macro to search for a value in a different file/workbook, copy the row (if the value is found), then paste it back to the original workbook....
-
Excel 2007 IF function Solved/Closed
Hello, Need formula to say if cell has NA put 0 but if the cell has a date (yy,mm,dd) then subtract cell L1 from cell E1. Trying to determine how ...
-
Macros for making a graph in different tabs. Closed
Hello, Hey Experts, I recently tried to use macros to make graphs. I have more than 15 tabs on my excel. Each of them have a similar data with ...
-
Macro/Formula in Excel Closed
Hello, I want to search for a word in the format eg.ABC-2012-123( where only ABC is fixed and the other numbers after hyphen keeps changing) in ea...
-
VBA - Search engine help Closed
Hi guys, These threads are really helpful but i still cant get mine to work. I have created a knowlege base on excel for all the fixes on my serv...