Excel Forum
-
bring a cellvalue from sheet2 to sheet1 Closed
Hello, I need to find the department number on sheet2 based on the list on sheet1 and then once that is matched bring the total cost that will be ...
-
Excel delete duplicate rows Closed
trying to delete all rows that are the same leaving in the excel only the rows that are unique ex: heading 1 heading 2 heading 3...
-
macro to copy info from one column to another Closed
Hello, I have a tough macro to figure out! There are 3 parts to it. Here is what I have: I have an excel worksheet that is currently filtered...
-
Macro to invert sign Closed
Hello, I need a macro that will flip a positive to a negative and vice verse. I had the following but it stopped working all of a sudden... Di...
-
Excell 2007 multiple pasting Closed
Hello, In Excell, I want to copy the same line several times within the document making slight changes after pasting each line. A change made in th...
-
Please help - run macro when switching sheets Solved/Closed
Hello, If someone could tell me how to run a macro upon switching worksheets, that would be extremely helpful. If this is not possible, perhaps ru...
-
undoing a macro to retrieve info back Solved/Closed
Hello, If I accidentally run a macro, can I (edit undo) to retrieve the information back to how it was? Configuration: Windows XP / Internet Ex...
-
macro to blank out filtered columns Solved/Closed
Hello, I have a worksheet that is filtered by a number. I would like to blank out columns M, N, S and T. (Only the filtered information) Can yo...
-
excel conditional formatting Solved/Closed
Hello, if date in cell A1 appears anywhere from B1:B30 then apply format. Configuration: Windows XP / Internet Explorer 7.0
-
Macro to get the colour of a particular cell Closed
Hello, I hope somebody can assist me with this. I wanted a macro which identifies the colour of the cell and displays the colour in a notepad for...
-
How I can count date in excel? Closed
Hello, If I have list of the dates, how I can count the dates that pass today? Configuration: Windows XP / Safari 533.4
-
Run a macro when modifying a cell Closed
Hello Guys, Maybe you can help me with this one, I am trying to run a macro when a cell changes value, the code im using is the following: Priva...
-
Code to open a tabs from combox excel Solved/Closed
Hello, I'm looking for a code, i can put in a combo box to show up different tabs located in my spreasheet. example: I have four tabs called tab1,...
-
copying and pasting certain cells Closed
Hello, Configuration: Mac OS X / Safari 531.22.7 I need to transfer (copy and paste) certain information from Column A of one tab (Tab 2) t...
-
Excel help Closed
Hello, I have an excel spreadsheet which I used to keep track of some records. A sample as below: ColumnA ColumnB Row1 07/09/09 ...
-
Excel List Closed
Hello, If i have a list of one thing in column A and list of another in column B, Can i get a full list of any column in another sheet with some f...
-
Excel 2007 days and dates issue? Solved/Closed
Hello, I was working to have the week numbers in excel and i step into a question when i entered in cell "B1" the date 05/1/2010 and i changed the...
-
Excel help! Closed
Hi. I have a formula that relies on a series of monthly updates all being populated before it will produce an outcome. What this means is that even if...
-
how to delete web script in my excel sheet Closed
how to delete web script in my excel sheet. i select the web script picture, and press delete & Cut options is not working.
-
Internet connecting but can't browse Closed
Hello, My computer was running kinda slow so I decided to run an antispyware program. It's called "SUPERantispyware" and I ran a scan and it claimed m...
-
Moving from cell to cell using arrows Closed
Hello, I am using Excel 2003. I am trying to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. It...
-
Excel formuls Closed
Hello, I have a cell which contains number and alphabets and also some characters. Is there a way to just get alphabets out of it
-
Find similar town names in Excel Closed
Hello, I have a list of towns in Massachusetts. I want to combine similar towns into one entry, so for instance, Brookline and Brookline Villa...
-
Excel formula Closed
Hello, Configuration: Windows Vista / Internet Explorer 8.0 Dear sir, I need a formula, if the cell contain a prescribed text and the c...
-
Excel Formula Solved/Closed
Hello, I am looking for a formula or script that can help me with the following. I am doing a spreadsheet for 19 different offices (on seperate...
-
Excel Sheet Counter Closed
Hello, I want to count days, exclude Sat.and Sun and Stat. holidays and have the program tell me the date 20 days, 40 days down the line. eg. I p...
-
Formula for Excel Closed
Hello, If I need to look at a cell and if its > than 5 than I need to add 1 unit to another cell. Each additional 5 means 1 more unit in that col...
-
Matching columns Solved/Closed
Hello, I have to an issue with matching columns. Column A Column B Column C Column D Column A: This has 300 lines with account #'s Column...
-
Excel Question about linking workbooks Closed
Hello, I am having a hard time figuring out how to link workbooks. I would like to have a main workbook that we number with a job number and a row...
-
merge data from two sheets Closed
Hello, Hi, I have two sheets with different data, but one colum is the same (customer name) so I want to add the data from sheet 2 into sheet 1 so...
-
EXCEL Closed
CAN I ABLE TO ACCESS A TEXT ON FIRST TO SECOND WORKSHEET IF I ENTER DATA IN FIRST SHEET IT CAN BE RETURN IN ANOTHER FILE ALSO
-
Create worksheets with links from a list Closed
Hello I have a list in excel and for each entry in the list I would like to create a new worksheet with a link from the original list. Is this possibl...
-
Excel 2007 VBA: Copy pivot table Closed
Hello, I want to copy the numbers (numbers only) in a pivot table to another worksheet by using VBA. The following code works if I use debug mode...
-
Office 2007 excell wont open excel 2003 docum Closed
Hello, Please help me this is could cost me my job! I got a new computer wirh win 7 and put office 2007 on it. I had files back in excel that 2003 ...
-
excel forumlas Closed
Hello, I have a column that contains "yes" or "no". I need to total the "yes" in each column. What is the formula to do this? Thanks
-
need a macro for the following Closed
Hello, i am have a set of numbers( indicating the product serial number) in rows having comments which include some text + date of manufacturing...
-
macro that takes multiple csv files and puts Solved/Closed
Hello, I need a macro that takes multiple csv files and puts them all in 1 worksheet. The csv files all have header info that i do not want copied ...
-
Excel 2007 "If....Then select Row and move&qu Solved/Closed
Hi all! I have what would appear to be a basic question, but can't seem to put my brain around the solution. I have a spreadsheet on Sheet 1. O...
-
Comparing 2 spreadsheets Closed
Hello, I need to compare 2 spreadsheets that are coming form different sources but have mainly the same content. I can easily edit them so that t...
-
Excel macro to find value with a condition Closed
Hello, Say, a code like C1180230 may occur more than once in column A, but its occurence with name "Recipe" in the previous cell is unique. I wan...
-
Excel function query Closed
Hello, I want your help for calculating the balnk cell in the row in a particaular cell and paste the top row column value in that cell. Means ...
-
Macro for copy pasting Closed
Hello team , 1.Can you please help me with the macro to copy paste the filter area to another work sheet . 2.Also the tab from which it is copyi...
-
Insert rows Closed
Hello, I have a question about "if End If" nested in a For Next structure in excel vba. I have been trying to write a code but I cannot get the...
-
Copying data in a dfrnt sheet w/ condition Solved/Closed
Hello, Greetings everyone... I want to copy data from one sheet to different sheet but only if a condition is true. For example, 1st Shee...
-
none of the browser sounds are working Closed
all the media player sounds are working... and the game sounds too... but none of the computer system sounds are working( startup, login, windows...
-
Copy certain Excel cells to new sheet Closed
Hello, I have data that is inserted in a row. I'm trying to create a macro that will copy certain cells within that row and paste them into cells...
-
Excel: Find & Offset Solved/Closed
Hi can someone help me to get a macro code to make following: I have a file in which some cells having data as 10000, > 10000 and some others 10000...
-
Copy/paste cells from different sheets Closed
Hello, I am trying to create a diary using excel to keep track of everything. As I am a referee I want it to have all the games I have refereed on a...
-
Autofilter tp leave out #N/A in macro Solved/Closed
Hello, I have a project id in column C , which iam checking from another source data which is there in a differenr tab .So ihave a vlookup fprmula...
-
Inserting rows through excel macro Closed
Hello, I have 29 rows of product numbers composed of 6 different products in an Excel spreadsheet. I need a macro formula that will insert five ro...
