Excel Forum
-
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...
-
EXCEL FORMULA [Closed]
Configuration: Windows XP / Internet Explorer 6.0 I HAVE A FORMULA THAT ADDS COLUMN A AND B AND IN COLUMN C IT ADDS COLUMN A AND B AND THEN MULTTI...
-
Comparing Columns and returning value [Closed]
Configuration: Windows Vista / Firefox 3.6.3 Hi, Hopefully somebody can help me here! Basically, I have 4 columns. Column A has a li...
-
copy and paste cells until reach end of data [Closed]
Hi, This is my first time trying to program in VB and I have no idea what I am doing! I have data that I would like to copy and paste within the same ...
-
Hours by job in timesheet in Excel [Closed]
Hi, I have the following time sheet that lists each employee and each day they worked, the job they were on and the number of hours worked on that...
-
IF/Then using an external text file macro [Closed]
Is there anyway to write a macro that will scan an external text file for possible column values? I have very large datasets that I have to "clean"...
-
Copy filtered table columns in VB [Closed]
On change of cell content in Sheet2:A1 from defined list, I want to filter a table in Sheet 1 and then copy the contents of a column from the filtered...
-
Macro Application [Closed]
Hi, I wanted to create a application, like i have excel sheet contains 1000s of employee details, at the end of the column (Column H), managers name w...
-
vba inserting row and keep range membership [Solved/Closed]
In VBA, how do I copy/insert (in place) a row and ensure that if the source row intersected a column range, that the new row would also be in the rang...
-
excel macro to change a cell formula [Closed]
Hi, I have three spreadsheets, one in which I enter data on a daily basis. The second collates this information by using referencing directly from t...
-
Email 2007 Excel Gmail [Closed]
I recently bought a new computer with WIndows 7 and Office 2007. My email is Gmail. I was in an excel spreadsheet and wanted to send it as an attach...
-
Excel Script help! [Closed]
Hello, I have a question about creating a (basic?) script that will pull some information out of a rather large excel file for me to eliminate a lot o...
-
Pop-up message box help in Excel 2007 [Closed]
Configuration: Windows Vista / Internet Explorer 8.0 Good morning, I am trying to create a pop-up box in Excel using VBA. I have to admit I have o...
-
Conditional Formatting in Excel [Closed]
Below is a small sample of the data that I am working with. Each column represents a year and each row represents an account number. What I would li...
-
Excel Conditional formatting [Closed]
What if the data i need to compare is in the other Tab!!!! ... How can i Compare it!!>> Pls. Help
-
I need to get a sum from multiple 'IF' cells [Solved/Closed]
I have a spreadsheet with the following formula: =IF(ISNUMBER(E5), "20.00","") If data is entered in cell E5, the cell below it will have 20.00....
-
convert mm/dd/yyyy to mm/yy in excel 2007 [Closed]
How do I convert mm/dd/yyyy to mm/yy in excel 2007? Configuration: Windows XP / Firefox 3.6.2
-
Excel VBA User List [Closed]
Hi. I would like to create an excel spreadsheet that opens up to a dialog box where the user has to enter in 4 different values. For example, t...
-
Excel masters plz help [Closed]
dear all, I will tell you the question in more detail. In sheet1 I am entering the data for the whole year, in column f I am entering names.(10 di...
-
Excel MsgBox Alerts - PopUp [Closed]
I am trying to create a stock trading template in Excel. The template/worksheet will be minimized/running in the background while other applications r...
-
how to run a macro in excel [Closed]
sdfad Configuration: Windows XP / Safari 532.5
-
Is there a macro which will sum cells [Closed]
Hi all I wonder if you could help. I have a long grocery list which although I can sort alphabetically I am finding it difficult to sum similar gr...
-
reading excel file dynamically [Closed]
Hi I am preparing a master excel sheet say it is "master-1" work book. When I enter the data sheet (another excel work book but in that sheet name i...
-
number to word in excel [Closed]
Hello, How to convert a numeric value into English words in Excel plz show that formula Configuration: Windows XP
-
match with conditional format in excel 2003 [Solved/Closed]
Hello Internet, I am in a bind here as I have exhausted my excel knowledge on this problem. I am looking for a way to highlight (in red) a cell wh...
-
Excel 2007: Reading data from sheet to sheet [Solved/Closed]
I am trying to read data from sheet "a" cell to cell on sheet "b". I entered function "=sum('sheeta'!f20) in destination cell, but all I am getting ...
-
Excel Formulas [Closed]
I need a formula that will allow me too add the number of red cells. Can anyone help please Configuration: Mac OS X / Safari 525.13
-
Excel [Closed]
I am working on a balance sheet i want a macro that can adjust the difference between assets and liabilities by increasing long term debt and i want i...
-
web sheet design [Closed]
Can I build a spread sheet in excel with several columns of information and import that to a web page? I have no experience building web pages but I k...
-
Excel Formula [Closed]
Hello, I am a total beginner at Excel and I (really) need a formula... If you could (please) give me the formula for this, I could alter it myself to...
-
Import web data into Excel [Closed]
Hello, I'm currently importing stock data into a spread sheet, and it works pretty well. What I would like the "update All" button to do is automatica...
-
Excel VLOOKUP Macro [Solved/Closed]
Hello, I am working on a project to create a simple VLOOKUP. I have created the macro and it works well, but now I am looking for some advise on ...
-
CONCATENATE multiple rows into one row excel [Closed]
Please need help in macro, I have thousands of data from .txt to .xls. Example of data value Description gem-967869 C...
-
Excel '03 Data Filter puzzle [Closed]
I'm using Excel '03 and I have two columns with data, A & B. Column A holds the name of a letter and Column B stores the body of the letter. When ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Get Free Diamonds in Free Fire
- Computer Boots to Black Screen
- How to Install a VPN
- How to Disabled Write Protection on a USB
- How to Recover Your Yahoo Account
- How to Create a Gmail Account
- How to Upload High Quality Photos to Instagram
- How to Fix a Blurry Snapchat Video