The discussions
Macros in excel so it copies onto next row
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
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
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
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
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
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...
Need help creating a macro
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
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
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
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/ClosedHello, 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
ClosedHello, 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
SolvedHello, 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
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
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: comparing two columns and output data
SolvedHello, 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...
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
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
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...
Problem with excel
SolvedHello, 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
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
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
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 ...
Macro to add columns in excel
ClosedHello, 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
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.
Hello, Computer browser services Automatically Stop plz answer me Configuration: Windows 2003 / Internet Explorer 6.0
Please help me develop an exel macro
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
SolvedGood 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
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
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
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
ClosedHello, 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
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
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
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 ???
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
SolvedHello, 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.
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
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
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
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
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
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
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
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
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...
Vba - transferring select data to new sheet
SolvedHey there, I'm trying to create a macro for an Excel 2003 spreadsheet that will take a record (a row (or rows)) that I've already selected into a new ...
Excel: how to create a complex date formula
Hello, I need to create a date formula that only includes weekdays. I want to have a formula that does (=previous date+1) for 5 boxes and then...
Excel doubt
Hello, I am using excel 2003 and pl help me to solve the below issue I want to compare two cells from one worksheet to other to write value ...
Sum using macro?
Hello, So sorry for my continuing inability to get my head around macros! I'm trying to workout a new spreadsheet and would really appreciate any...
