Excel Forum
-
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...
-
Worksheet_Change from a data validation list Closed
Hello, I want my pivots to rebuilt when a value in range("Book_Select") is changed. This range is a drop down data valiation list. What is wrong w...
-
Comparing values of 1 excel cell with column Closed
Hello, Please can you assist me with this excel formula? In sheet 1 I have business rules specified in column A and all the requirements that exe...
-
Excel Macro Solved/Closed
Hello, I wonder if anyone can help me with a small (I think) problem, please? I'm trying to write a macro to manipulate a spreadsheet sent to m...
-
Pull data from one tab/sheet to another Closed
Hello, Configuration: Windows Vista / Internet Explorer 9.0 Reading all of these posts I get a lot of ideas, but since I am a novice at this ...
-
Hide rows without conditional formatting Closed
Hello, I'm creating an Excel spreadsheet and want to give it a cleaner look by hiding the contents of a row based on the value of a cell in that ro...
-
Macro Help Closed
Hello, I am new to VB and Excel. I've got the following code: I've got everything working fine, but need the entire row to change colors...
-
Excel search and save problem Closed
Hello, I'm a total Excel noobie so I hope you can help me, I will try and be as brief as posible. Each week I will be getting an Excel CSV of 4...
-
Excel Copying Columns Closed
Hello, I have a spreadsheet for labor hours - Reg & OT columns per employee for 26 pay periods. I have the spreadsheet sorted by employee. Each ...
-
How to make secondary cells color of primary Closed
Hello, Is there a way to make cells automaticaly change to the color I chose for another? Example: I decide to make cell A1 red. When I do this ...
-
filter-cut-paste to other sheet Closed
Hello, Could you please help me on this one, i have a data sheet and i want to filter then cut the data if the criteria is met (Adhoc,Chaser,Excep...
-
compare cell a1 to entire A col in sheet2 Solved/Closed
Hello, I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to ...
-
Excel problem Solved/Closed
Hello, Hello, I am hoping that someone can help with the following problem, I have a list of numbers, golf staplford scores, located in cell...
-
Macros and histograms Closed
Hello, I want to create a histogram on sheet2 while the data required is on sheet1 using a macro. everytime I try, it either says no data availabl...
-
Excel - copy data macro Solved/Closed
Hello, I am currently learning the tricks in excel but have become stuck. I have created an expenses sheet where employees record various expenses...