Excel Forum
-
Copy From Master to Different Sheets [Closed]
Hello, I am slowly making my way through macros, but can't seem to find the answer to the following:- I have a master sheet - which is a budget...
-
change the date of weekends in excel 2007 [Closed]
Hello, just want to ask how to change the date of weekends in excel 2007. please help. thanks! Configuration: Windows XP / Internet Explorer...
-
Excel macro help needed to name ranges [Solved/Closed]
Hello, I have a 10 column x 500 row spreadsheet A1:J500 I would like to name ranges as follows: Range A1:J1 should be named with the content of...
-
Need to copy rows based on values entered [Closed]
Hello, I need help with a formula or macro. My situation is this: I have one sheet of data (Sheet1) with unique values (item numbers) in Column A...
-
excel related [Solved/Closed]
Hello, could you please tell me how I get excel to automatically use a color in a cell that I write something into? The blank ones can remain colo...
-
EXCEL formulas [Closed]
Hello, I have a spreadsheet called 'TRADE' as follows: Column: A B C Sept 200 1000 ...
-
Macro to create worksheets [Solved/Closed]
Hello, I'm Mike, I'm new to Macro excel I need a Macro that read from a table the name of projects and create for each project a sheet named th...
-
In Excel 2010 modify the pasted value to link [Closed]
Hello, Configuration: Windows 7 / Firefox 11.0 Office 2010 Excel I often need to record UPS tracking numbers into designated fields in Exce...
-
cannot browse, but ping and hotmail working. [Closed]
Hello, I have the same problem on my browsers, ie has encountered a problem and need to close. Sorry for the inconvenience. error signa...
-
Create coded list in excel [Closed]
Hello my most humble computer users, I have a hard one here...And I think it will be harder to explane... I have an excel file that has a several ...
-
HELP! compare 2 cells then copy to next cell [Closed]
Hello, I need help copying the names from the master cell (A), if the other cell's (B) given names exist from the master cell, then copy to next c...
-
comparing data across dozens of worksheets [Closed]
Hello, So we track sales on a weekly basis and I want to compare the text in column C to all previous weeks and if they match to turn them red to ...
-
How to make 2 VBA codes to work correctly [Solved/Closed]
Hello, How can I correct the following 2 codes (which written in the same sheet) in order to work correctly, other wise it gives me Error (debug)?...
-
Macro to Find and Replace [Closed]
Hello, I am trying to create a macro that can Find and Replace a variable value. For example, I want to create a cell that can have any code enter...
-
delete all the rows in a spreadsheet except [Closed]
Hello, I have a simple question. How to delete all the rows in a spreadsheet except the first 6 rows by macro. Please reply me with an exact code...
-
Auto-copy of select rows to another worksheet [Solved/Closed]
Hello, This is my first time asking a question, so I will do my absolute best to follow and respect the forum guidelines and it's contributors. I...
-
I have no sounds on my browser and WindowsMP [Closed]
Hello! I lost the sounds ONLY on my browser. Alongside this soundlessness in my browser, whenever I open a file associated with Windows Media Player I...
-
Correcting VBA code in Excel [Solved/Closed]
Hello dears, I have the following VBA code : Private Sub Worksheet_Change(ByVal Target As Range) Dim cRow As Integer If Intersect(Target, Ra...
-
Copy cells in excel if cell above is null [Closed]
Hello, Can anyone help? I need to run a script that will determine if a1 is blank, paste the information from a2 into the a1. If a1 is not nul...
-
Moving Rows within Excel [Closed]
Hello, Please, please can anyone help me, how can I move dates from ColumnA (Surname) ie various dates and date formats into the appropriate Date ...
-
Highlight unique or duplicate on 2 sheets [Solved/Closed]
Hello, I have a Excel file of 2 worksheets and have a list of Usernames on column B of both worksheets. Few of the usernames appear on both sheets...
-
Excel dynamically fill cell with data [Solved/Closed]
Hello, I have worksheet ( AllUsers ) with two column A ( user id ) and B ( date ). Column A is a long list of user names and B is a list of dates ...
-
copy text frm a cell n append it thru macro [Solved/Closed]
Hello, I am trying to create a macro where I want to copy a cell content from one worksheet and append it to a cell in another worksheet of the...
-
Excel 2010 Series question [Closed]
Hello, I have a question. I have an excel spreadsheet with 25 columns of information. There are anywhere from 3500 to 4000 rows of information. ...
-
Excel problem [Closed]
Hi I have a slight problem with excel. I have inputted all my data with links on the same worksheet. Now I am trying to separate the different cate...
-
Column comparation in different datasheet [Solved/Closed]
Hello, Hello, I have one excel column A in datasheet 1 which has a list of names. In Column A of datasheet 2 I have a much longer list of n...
-
VBA to protect sheet in excel [Closed]
Hello, I need any help if some one can help me. I make an overtime sheet in excel that allow the employee to fill in the date and time only and i...
-
[Excel] Macro on Grouping [Closed]
Hello, I need help on developing a macro on grouping a set of negative amount & quantity against a set of positive amount & quantity. Using positi...
-
Using VBA code: add Borders if Conditions Met [Closed]
Hello, I am at the very beginning stages of trying to learn VBA in Excel 2007. I am trying to merge some cells in the next row, and I would...
-
VBA copy/paste cells then drop 1 row for next [Solved/Closed]
Hello, I am making a questionaire. When the questionaire is complete I want to copy the answers to another worksheet then reset the answers to zero...
-
calculations date & time in excel [Closed]
Hello, I used office 2003. In excell 2003 i formatted cells to dd hh:mm from dd/mm/yy hh:mm, in order to do calculations and it was ok. Now i...
-
Textbox on Excel Uerform Problem [Closed]
I have a userform with several textboxes on it. The info that is typed into the textbox is copied into a cell in a spreadsheet where it is used to per...
-
Microsoft Excel 2010 [Closed]
Hello, I would like to figure out how to get a web address that I use to get data from the internet to always use the date that I put in cell A1. Any...
-
Excel Formula Help Please [Closed]
Hello, I have only worked with formulas when working with numbers but I need to know what formula I can use. I need a formula to take a column that ...
-
Excel 2007 filter bringing back last row [Closed]
Hello, When I apply the filter option for a particual item, the last row of the data is being displayed even though it does not match the criteria. ...
-
multiple sheet data in one sheet in excel [Closed]
Hello, Want to copy data from multiple sheet from multiple columns in one workbook can you please help me with that macro as well Pran...
-
Excel macro - copy data from one line, append [Closed]
Hello, I have a spread sheet created from a PDF to XLS program. I have lines in which the address appears on two lines, with the extra text fallin...
-
excell delete row where column A = column B [Closed]
Hello, This should be simple but I can't find the solution. I need to delete rows from a spreadsheet where column A = column B. Please help. ...
-
Excel Formula [Closed]
Hello, I am working on log spreadsheet. The concept is to keep a log of all of our near miss activities at work like a broken chair that needs to ...
-
Excel Help [Closed]
Hello, I'm trying to set a formula in below way, but it doesn't work, why?ould u plzz help? =IF(J10="Safari 4.5",650,IF(J10="Safari 7",850,IF...
-
Formula challenge for the Excel wizzards. PLEASE HELP [Closed]
Hello, This might be a long explanation, but only because I want to be clear about the problem. I have 3 different Workbooks and the names are ...
-
Excel 2010 formula/macro help [Closed]
Hello, I'm hoping some of you excel wiz's can help me, I've been off the tools too long. Worksheet 1 Column A contains dates Column B contain...
-
Excel Logic [Closed]
Hello, I am trying to create a worksheet in excel that will allow me to add a certain amount if 2 conditions are met. So far I can only get it to a...
-
Insert row in excel by criteria [Closed]
Hello, Configuration: Windows XP / Firefox 10.0.2 I want to insert row in excel using formula because i have dates in the and there is da...
-
Copying value to another worksheet [Closed]
Hello, I am trying to copy a value for from one worksheet, do some math --> say I have three values that I want to subtract separately from cell i...
-
Excel conditional formatting row color [Closed]
Hello, Column A indicates what type of transaction I've made (ie POS/ATM/CASH/Bill Pay) Column D is the date the transaction has cleared my bank. ...
-
Excel Macro - Create new files from ranges [Closed]
Hi. I am trying to create a macro that will create new excel files for ranges of rows in a worksheet. I want to copy the range F5:S61 and paste i...
-
Enter sheet update other worksheet with text [Closed]
Hello, Can anyone help me with this problem. I am updating leave availability , As soon as I enter the name in one worksheet the other workshee...
-
How to determine cell value in Excel column [Solved/Closed]
Hello, Sorry the title is really vague, it's hard to describe with a limited number of characters. I have a column (C) which contains a full li...
-
Macro - Sort Range Error [Closed]
Hello, I've created a Macro within Excel that is supposed to Delete, Formulate and Sort data.. I've managed to get the Macro to the point where it...
Subscribe To Our Newsletter!
