The discussions
Compare two excel columns
Hello, I have two excel sheets. One has Server Names only. Second has server names with other columns with more data like OS,Supplier,Application...
Excel - formula in text count
SolvedHello, I Need a formula in text count For Example P=1 P+P+P+P+P= 6 What is the formula in excel please defineConfiguration: Windows XP / ...
Copy / paste specfic date to other worksheet.
SolvedHello, I've got a few columns of data in which 3 columns contain dates (in date format : dd/mm/yyyy) . Now, I want excel to seperate the entire row ...
Date counting in excel
Hello, How can I count rage of date in excel? Configuration: Windows XP / Internet Explorer 6.0
Find and replace cell value macro help pls
SolvedHello, i have these 20 formulas (1 per stock code) in my spreadsheet that come from etrade =PROStaticData(2, "mqg.ASX", "2010/08/10;2010/08...
Need help with excel!!!
Hello, I have two sheets with 5 columns each; item number, description, quantity on-hand, price & total value. I want to match the columns on shee...
Macro: watch a cell and copy if changed
SolvedHello, The problem in a nutshell is that I have 5 pivot tables on one worksheet, each with a field called "date" above the main text. Each day the...
List unique values from multiple columns
Hello, I am kind of new in advanced programming with Excel. I have a table that gathers a number of sentences which I classify with 3 category c...
Excel2007 copy cell from sh1 to sh2 range
Hello, I would like to copy the variable text content of Cell K8 on Sheet2 to a cell range of D6 to D35 on Sheet1 so that the text entered into K8...
Search for accounts balances excel or access
Hi guy's, I need your help with the following problem. I have a list of accounts in an Access Database, each account has a balance next to it. ...
Excel formula add data if columns match
Hello, I am basic excel user who is slowly needing to use formulas. I have two seperate charts that I've put into 2 worksheets with similar informati...
Matching a cells in different columns
Hello, I want every cell in Column A find a matching cell in Column B, if there is a match, then I want results shown in column C in the same row ...
Read data from excel 2003 to write to sql
Hello, Help please I have to read data from Excel 2003 to write to SQL server using .net, so every time user modify data it shuld refelect to...
Excel formula help
Hello, I have the following problem and need someone to help me solve it. I want to concatenate items in column A, but it must only concatenated ...
Excel formula clarification
Hi Guys and Gals, Is there a formula that can make the value of any given cell always display the 1st day of the current month? I am aware of th...
Auto populate cells from bottom to top vba
Hello, i would like write a vba script to fills the blank cells with the value of the cell directly below it starting from top to bottom with a loop...
Copy paste row to a new worksheet
Hi everyone i am stuck with this problem, i have 40 lines in my excel spreadsheet..how can i do a macro that it will copy and ...
Retaining similar values in cells
Hello, I need a solution with retaining similar values in excel sheets. I have a list of words like: Mount Prospect IL Multi-Family Mortgages M...
Ms excel
Hello, I want to know whether a particular information from one excel sheet can automatically get copied in the other one as soon as a particular cr...
Excel autofill macro for different data cells
Hello, I am looking to create a macro that will enable autofilling different rows with the data in the top cell. Here is an example: Row ...
Create a macro to format a column
SolvedGreetings, I am not a programmer but I know how to create basic macros that would perform simple repeated tasks in a fixed range within a sheet. ...
Macro to delete duplicate items -help please
SolvedHello, I'm trying to create a macro to delete the row that has a word at the biginnig and the same word at the end. Example: MIA/SFO/MIA ...
Lost information on excel after saving it
Hello, I have lost all my work that I have entered into Excel after saving it in Excel 97-2003 Workbook. How can I get the information back? I h...
Excel: date+1 year?
Hello, I am trying to set up a simple way to let my excel illiterate boss have a simple way of knowing when a list of products need to be updated. So...
Connected to the internet but browsers won't
Hello, For the past couple of days, my computer has not let me get onto the internet when I open my browsers. The computer will be connected to th...
To format columns based upon value in a cell
Hello, I want to make a leave tracker in Excel 2007 for the employees of my project. I am designing it per day per month basis. In that I want all t...
Excel: retrieve rows based on string search
Hello, I'm trying to write a fairly simple piece code (or so I thought) to do the following: In column A on sheet1 in my Excel workbook, I have s...
How to make add cells together after a partic
Hello, I am setting up a checkbook ledger in Excel. I am trying to figure out how to make a cell add after the first day of the month. The D2-...
How to compare two columns in two worksheets
Hello, i need a macro code that can compare two columns in two excel files as : File1 ...
Create excel worksheets-week days of a month
Hello, I need code to generate new workbook pages in an Excel spreadsheet - one for every week day of a particular month. -Sue Configu...
Excel 2007
Hello, I have a spread that has a column for dates however my boss just typed the date, with no formatting in that cell. The formatting is "Genera...
Merging 2 excel sheets
Hello, I have run a report from our system into excel and would like it to populate a different Excel spreadsheet template that I have made up. ...
Macro to copy and paste to new sheet
Hello, Im not great with excel macros and VBA so bear with me. I want to create a macro that will Copy and then paste the current highlighted s...
Problem with vba code
Hello Lets say I want the value of the cell defined by row "Banana" and column "Old". You can abviously tell it is the value "40", but how...
Excel code need to conditionally copy rows
Hi there, I have a spreadsheet with many worksheets which are task lists for each of our clients (e.g. CTC). Each sheet has a 'who' column (starts...
Excel auto fill based on criteria
Hello, I am looking for some help. I have a current excel worksheet that has: a1=tech name, b1=address, c1=zip. We have to manually look up the zip a...
Excel issue
Hello, I have a problem that if i have excel sheet of 20 rows and 200 columns and i want to perform some function like comparing each entry with ...
Excel macro help for a noob
Hello, I need to create a macro that copies cells A1:R1 from "Workbook 1, Sheet1" to cells C24:T24 in "Workbook 2, Sheet 3". Weekly "Workbook 1"...
Date excel userform's textbox
Hello, i have a problem in excel userform's textbox(txtDateofBirth) if date of birth is between 01/01/1981 to 01/01/1991 then msgbox show "Adult"...
Excel formula to copy and paste cell data?
I enter customer orders in my excel invoice worksheet. I would like for excel to automatically copy and paste (dump) the orders from my invoice worksh...
Excel formula to copy over hyperlink?
Hello, I've been working at this for awhile trying to find a formula that would allow me to do this: I have this formula : =IF(LEN(Master!D13)...
Excel - if functions
Hi , I made a forumlua that finds the difference between the date of one cell against todays date to get the total number of days that have gone p...
Excel help
Hello, I am trying to figure out how to program a specific function in Excel. I need to create a spreadsheet that will select the next later date...
Vba on command button to check blank cells?
Hello, I have the following code on click of a command button, but i want it to check to see if certain cells are blank and error message if there...
Vba code copy that data from one sheet to uno
Dear Expert, With reference to macro i have a question, is there any vba code which can copy that data from one sheet to unother sheet after evr...
Please help me with the macro code
Hello, Please provide me with the macro code for the following problem ,as I am new to excel macro i have four columns Batch No,Title,Query,Asse...
Auto insert 'x' rows depending on value 'y'
Hi, I have an excell spreadsheet that contains a table. I want to be able to insert a given number of rows dependant on the value inserted to a part...
Excel row sorting question
Hello, I'm a very basic excel user. I am trying to create a workbook that has seperate sheets that track different things for the same people. I w...
If condition in excel
Hello, i want to implement the IF condition in Excel,the logic is if my sales entry is of A type then dedudct 16%sales tax on total sale and if my sa...
Excel, filling in cell values automatically
SolvedHello, I have two worksheets in Excel 2007 and am trying to automatically fill in cells in worksheet two based on values in the first worksheet. A...
