Excel Forum
-
conditional hide rows in multiple sheets Solved/Closed
It didn't solved yet. I have one excel file with multiple sheets, and all of them with the same columns and rows . I need to hide specific rows in ...
-
excel drop down box Closed
hai evry1 i have small doubt regarding the use of microsoft. suppose cell A2 has a dropdown list containing football, basketball , cricket. wen ...
-
Vb code to extract selected range of cells Closed
Hi i need a vb program to extract selected range of cells to another excel. Ex: If i complete a row A1 - F1 and if i give "Update", it should copy ...
-
How to display formula in excel? Solved/Closed
hi everyone, for example i have A1=H and A2=G, and A3=A1+A2 how do i make A3 show a final result of "H+G",display text instead of calculating the form...
-
Excel Skipping a cell when calculating a tota Solved/Closed
i have a series of codes back and forth it seems a bit insane. but what im wanting is for cell b1 c1 d1 e1 and etc to add together wich i have the fo...
-
Excel problems with copying a formula Closed
My excel is behaving funny. When I copy a cell formula across the row or column, it copies the formula correctly, but does not give the corresponding ...
-
Excel Closed
Hi i want to format the cell value like this 1 A 2 A 3 A 1 B 2 B 3 B 1 C . . . any easy way? Thanks in advance
-
VBA msg box problem.. Closed
Hi, how do you change a msg box option from Yes and NO to 1 and 2??? Thanks in advance! Excel 2003 Configuration: Windows XP / Internet ...
-
copy paste macro Closed
Hello all , I need a small help in doing macro. can you please any one help me ? for example:- In sheet1 i have data from A1 to A4( this ...
-
Break [|] pipe delimited values in rows Closed
I have a text line containing information separated with pipe sign [|]. Kindly provide me a macro/code to break them into: a. Each broken value shou...
-
SORTING DATES IN EXCEL Closed
Hi, I am trying to use a spread sheet to automate my family tree. I have a birth date like 2/2/1880 and a death date of 3/8/1900. The censuses run in ...
-
<Select multiple rows by criteria in Excel> Closed
Windows XP / Firefox 3.6.3
-
Combine data of Multiple cells into one cell Closed
I have a list of Records in Excel sheet in a following format. Each record contains more than one Row. Each new Record starts from number Zero [0]. N...
-
Excel copying text Closed
Hi, Hopefully someone might be able to help. Can you tell me if I can copy text in one worksheet to another continuously? All the text is in the s...
-
Copy rows into asheet when checkbox is select Closed
Hello, I am setting up a workbook to track software as part of a project, I need a macro that will copy data from a row if a checkbox in coulum j i...
-
Macro Assistance (Remove First number) Closed
I have an excel speadsheet that is sent to me daily with numbers in column A (example: 1.1.2.1.1). What I have to do everyday is delete the ...
-
Macro to read most recent row of data Closed
Hi, I'd to create an Excel macro to read the last line of a spreadsheet with data and transfer that data to another worksheet in the same workbook....
-
date and time macro for excel spreadsheet Closed
I would like to insert the date and time in a cell on an excel spreadsheet with the click of a button every time I make updates to the spreadsheet. I...
-
Formatting Cells based on previous cells valu Closed
I want to be able to highlight a cell based on the previous cells value. Example: if cell D1 is 450 and cell E1 is 480 then I want that cell to turn...
-
Excel - Macro repeats on Worksheet Change Closed
I have set up a worksheet change event that will run a specific macro when a number is put in a specific cell. Private Sub Worksheet_Change(ByVal ...
-
Compare cell against multiple columns Solved/Closed
Configuration: Windows XP / Safari 532.5 Hopefully I can explain this as simply as possible. First here is what my spreadsheet looks like I have sepe...
-
VBA code to select particular tab.... Closed
Hi does anyone know the vba code to find particular tab if it is todays date. e.g. i have a list of tabs on a spreadsheet dated from 1st to 31st...
-
Excel date compare with system date Closed
i want to compare a any date with system date, and to expect result in number,the no of days in them?? please help me out. Configuration: Windows XP...
-
Macro Help Closed
Hi I have a query in macro. Now i have excel with two columns. eg: a b b a a c d a b k now i wante...
-
Moving Excel row values into coumn values Closed
Hi All, I am trying to move data from rows into columns which may be described with table better - Name Project 4/10 4/11 4/12 Joe ...
-
Spreadsheet Information Closed
I have one Xcel 2003 spreadsheet with 2 almost identical worksheets. How can I make what is entered in worksheet1 "automatically" appear in worksheet...
-
Hi excel help please Closed
Hi, i have two different work book which i want one worksheet to role over to different work book. i dont know how to do that.. can someone help me
-
Excel - Run Macro on Cell Change Solved/Closed
I am trying to have 1 of 8 different macro's run depending on the value of a specific cell. If I enter 1 in cell A3, I would like macro1 to run. If I...
-
Trouble with excel columns match Closed
Here is my problem, I have a defined set of numbers in one column. I have another column with variable numbers, some of which may match numbers from ...
-
VBA Code For Excel .......................... Solved/Closed
Dear Expert, Below written VBA code is being used by me to insert jpg picture in the excel file against the code number and its working very well a...
-
excel-match in col, copy some of match's data Closed
I have been struggling with a formula - help! I want to copy data from one sheet to another but only if there is an exact match of data. I need ...
-
macro to delete blank rows? Solved/Closed
I have a spreadsheet where I would like to 'record new macro' to delete all rows that are blank. If I filter on blank rows and delete....the macro wi...
-
Need formulas for accounting spreadsheets Closed
I have a few questions for a spreadsheets program I am creating... Explaining what it does, specifically in reference to my questions: Worksheet A...
-
Why won't this work?: update graph's year VBA Solved/Closed
Hi, My graph has a timeline of one year. After that year the timeline needs to be updated. To get the current year I have used the functions TODAY...
-
Moving specific data into separate worksheets Solved/Closed
Hello, I have a list in a column as follows: DAY TYPE PHASE 1 ...
-
Hyperlink Macro Solved/Closed
Hi Have a customer profile sheet that has a new customer number each time it is opened. Details are filled in for the customer then a post button is...
-
how to lookup criteria in two columns Closed
Hi thanks for getting back to me. I think my brain may be a little frazzled but I could not get it to work. Also I may not have explained wh...
-
Read 2003 Excel Spread Sheet with 2007 Excel Closed
I opened a 2003 excel spread sheet with 2007 Excel. The spread shows #REF! in my cells and did not show the numbers. What can I do to fix it? Conf...
-
multiple text to 2 columns Closed
I need to divide the text in Column A into Column A & B. Each cell in Column A has a different number of text items. A1 might say "John A Smith is h...
-
Macro to copy and paste values Solved/Closed
Hi I am a complete novice when it comes to macros. What I am looking for is a macro that when run looks in Cell Q7 on Sheet 1 to see what number is...
-
copy/pasting visible rows using macro? Closed
I am trying to use the 'record new macro' which is all I have experience with. My objective is to filter out rows by a date on my spreadsheet and cop...
-
Matching variables between cells Closed
Hey folks, So here's my problem: I'm creating an excel document to keep track of my personal expenditure -- the layout right now represent a cal...
-
Cannot use skype, or browse but connected Closed
Hi, Recently my IE and firefox would not let me browse but i was connected to the internet as i was able to use safari. My skype, limewire and MSN ...
-
Please help macro or formula excel Solved/Closed
I've 4 columns and 10000 rows like this : Month Plant Area Budget Jan ........ A1 ........01 ........ 1000 Jan ........ ...
-
multiple tabs set row count based on sheet 1 Solved/Closed
Hi Sheet 1 contains > 1000 rows of populated data. I need to create x number of tabs each containg the next 25 rows from the sheet1 data. ie 1000...
-
how to compare two cells in excel sheet Closed
Configuration: Windows 7 / Internet Explorer 8.0 I AM HAVING TWO EXCEL SHEETS HAVING DATA.THE FIRSTTHE EXCEL SHEETS COLUMN A AND SECOND EXCEL SHEE...
-
Excel Formula Help Closed
Got a tough one here I'm trying to figure out. A B C D Wo...
-
Hide rows if have zero value in Multi-sheets Closed
Please note that I don't want to make filtering, what I need is to Hide a range of rows if they have zero value in specific columns in Multiple sheets...
-
How to Attach Module with Excel Closed
How to attache Conversion Module in all New or Old Excel worksheets, or when we are open the Excel worksheet then automatically activate this module ...
-
excell if equations Closed
if product x is > 15 then multiply by 3, if x is < 15 but > than 5 then multiply by 2 and if x is < of 5 then multiply by 1.5 Configuration: Window...
