Excel Forum
-
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...
-
getting data from another worksheet [Closed]
Hello, I am having 2 worksheets in a workbook sheet1 consists of a data like this: Country name Site engineer Name Contact Details Ben...
-
Copy/Paste Macro for Excel 2011 for Mac [Closed]
Hello, I am in of help! I've tried searching the forum for a code that will work but sadly i've not found one. I am try to create/code a macro or b...
-
Excel macro to create files based on column [Closed]
Hello, I want to create a macro which creates files based on contents in column AJ. and I want the macro to copy the data from original sheet...
-
macro to search, find, copy rows and replace [Closed]
Hello, I am trying to create a macro to search for a number from one workbook in another workbook, and then either copy the entire row or copy the ...
-
Copy particular columns to next sheet [Closed]
Dear friends, Plz help me to do the below requirement Current situation sheet one PTS invoice# status amount proc.date 1234...
-
find data in another spreadsheet [Closed]
Hello, I need my stock checker to pick up data from our suppliers spreadsheet which they change daily. So what i need for example is: To mat...
