Excel Forum
- Solved
-
Copying Data To Another Worksheet [Solved/Closed]
Hello, I have the following data in worksheet named "Auto Entry" Cell A1= X Cell A2 =Y Cell A3 =Z Cell A4=Input Value(1,2,or 3) In Cell...
-
Excel: matching and sorting [Solved/Closed]
Hello, Ok, how sould a computer dummy to this (the dummy is me): I have a list of 300 bike racers. In the columns next to the racer is items...
-
can someone please write me a macro for excel [Solved/Closed]
I want to be able to input a number into a cell and have that number recorded in a list elsewhere within the same sheet. Then be able to replace...
-
copy selected cells to new sheet in a row [Solved/Closed]
Hello, dear all, I have an invoice template in the range b6:f57 in one sheet.. I want to select only some cell contents like c17, f17, f 19 , f...
-
macros help [Solved/Closed]
Dear Friend i want to convert number to text in excel programme Example : ( 055555 : Zero five Five Five Five Five ) As This...
-
Transfering data to a new sheet [Solved/Closed]
I'm running excel 2007 on windows 7, if that's important. I'm trying to find a way to transfer data from a master sheet (or basically sheet...
-
Format data in excel for Db transaction [Solved/Closed]
Hello, I have a simple question, I have a range of cells with numbers in each cell. I want to add a single quote or apostrophe in the start and...
-
Excel Macro to copy text and append [Solved/Closed]
Hello, I recorded a macro in Excel where I copied the text from one cell and appended that text to the values in several other cells. The...
-
cell reference to locate /store data in excel [Solved/Closed]
Hello, Hello , I am working for a newly started airline agency. I am enclosing my working file (for privacy sake , I have changed names and...
-
Excel macro help [Solved/Closed]
Hi there, I am getting an error when I try and run the following macro. I am trying to find the value in one worksheet (final) in another...
-
Delete AllowEditeRanges by VBA [Solved/Closed]
Dear All, Can some-body help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As...
-
Delete AllowEditeRange by VBA command [Solved/Closed]
Dear All, Can anyone help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As...
-
Excel Conditional Formatting Rows to Columns [Solved/Closed]
Hello, I have a data set that looks like: A B 1 20 2 21 3 21 4 03 1 19 2 34 3 23 4 25 1 ...
-
HELP about macro copy and paste [Solved/Closed]
Hello, Just want to seek help to anyone about my problem about copying and paste multple raw and column thru new sheet also with designated...
-
Copy to first open cell in rowB/sheet 2 [Solved/Closed]
Hello, Thanks for trying to help! I have a sheet as shown below. We do sales every day and would like the values/ estimates and sales that...
-
VBA - how to replicate the value n times [Solved/Closed]
Hello, I have to write in VBA a macro that allows to replicate value n times (input). Let's say, I have a list one two three and I have...
-
Help required in MS Excel [Solved/Closed]
Hello, I have a list of text strings in rows separated by blank rows. For example: Row 1: Name of the publication Row 2: Authors Row 3:...
-
how to compare columns of 2 different Excel [Solved/Closed]
I want to compare column named employeeid in two different EXcel sheets and have to retrive the rows with same employeeid ex: sheet1 emp...
-
Excel If Then, create a new column [Solved/Closed]
Hello, I'm trying to write a VBA code, because I have too many factors to create a nested function. I can do it fine if there were less than 7...
-
VBA to Protect sheets & keep some options on [Solved/Closed]
Dears, I will be very grateful if some one can help me. I have excel file include 50 sheets, so I made one sheet that include all the basis...
-
Indirect function on Excel [Solved/Closed]
Hello, I need to know how I can add the following to an exsiting cell reference in a whole column. ='Sheet1'!A2 to show ...
-
searching names in drop down list in excel 07 [Solved/Closed]
Hello, I have placed a drop down listbox in my excel 2007 work sheet and selected the range of names which are in the same sheet. In the list I...
-
Excel formula problem [Solved/Closed]
Hello, Please Help =IF(V12=1,2*(R12*50%)) I have a problem with this formula: What I need, is if v12 = 1, 2, 3, or 4 count R12 times...
-
Excel: If A1 = a 4 the comy content of b1,2,3 [Solved/Closed]
Hello, Please help! If A1 = a 4 the comy content of b1,2,3,4,5 to c1,2,3,4,5 The 4 in a1 are generated by a formula. Thanks...
-
Excel - Help! [Solved/Closed]
Hello, I require a formula which will recognise months in a column and select taht value from a different cell on the same row. The data is...
-
Format using Macro [Solved/Closed]
Hi I have some data in sheet1. Eg: Column A Column B Column C Column D 1 2 3 4 ...
-
Filter rows in one sheet [Solved/Closed]
Hello, I have large amounts of data in one work sheet(say it as Sheet1) and another worksheet(sheet2) has few records(100) which are also...
-
converting rows data into columns on conditon [Solved/Closed]
Hello, I have data which looks like below ColA-----------ColB-------ColC--------ColD------------ColE---------ColF-------ColG----ColH-------...
-
delete cells/rows but keep row info intact [Solved/Closed]
hello, I am trying to import data from an excel spread sheet to access. I want to clean up my excel report before I import the date. In my...
-
Dates in Excel [Solved/Closed]
Hello, I have a list of people's birthdays in a list in Excel. I want to retain only the day and month of the birthday and get rid of the year. ...
-
Excel Comparing 2 columns removing duplicates [Solved/Closed]
Hi, I would like to cmpare 2 columns in an Excel spreadsheet & remove duplicates from Column B if any matching fields are found e.g. A ...
-
Excel 2007 VLOOKUP and MATCH problem [Solved/Closed]
Hello Long time lurker, first time poster. I'm having an issue with a Vlookup and match function. I have a set of data that is organised and...
-
How to do if statements in Excel [Solved/Closed]
Hello, I am having a problem trying to get an if formula right. If fig1 is +- 10% of fig2 I want it to say Fail If fig1 is within 10% of...
-
Summary Sheet [Solved/Closed]
Hello Sir, I Have 30 Data Sheets Of Individual Date & 1 Summary Sheet. The Example Of Those 30 Sheets Are: A1------------B1--------------...
-
Found Cell Color And Worksheet Viewing [Solved/Closed]
Hello, The code below had cause the found value cell color to remain there even after I closed the Input Box.I would like to have the color to...
-
Macro to define a interval [Solved/Closed]
Hello, i have a excel sheet of details of employee of the organisation. in that sheet I have a column D of age. I have to define age...
-
Adding new data sets to multiple worksheets [Solved/Closed]
Hello, I am creating a spreadsheet database for data to determine the best vendor to use. I have multiple vendors on different worksheets and...
-
Macro To Copy Rows From One Worksheet To Anot [Solved/Closed]
Hi , I'd like to know if there's a macro that can be run to check one worksheet. In this worksheet there is a column where the value should be...
-
One Button To Execute Two Macros [Solved/Closed]
Hello, I got one macro in Sheet1 and another macro in sheet2 under the same workbook.I want to assign a button in sheet1 so it can execute both...
-
Excel formula A+B=C with the following except [Solved/Closed]
Hello, I really could use some help please. I am working on an 2010 excel spreadsheet. Would anyone know if there is a formula to do the...
-
Use Excel VBA to create an e-mail w reminder [Solved/Closed]
Hello, I create a file in Excel that does some calculations based on a small database and some user input. I then added a button to open an e...
-
Macro to highlight a row if cells match value [Solved/Closed]
Hello, I sorry but I am very new to macros and trying to create one in Office 2003. I need to bold a row if for example column E is greater...
-
Count if macro on multiple criteria [Solved/Closed]
Hello, Could someone please help me out with a count-if macro on multiple criteria. I have attached a sample file in the below...
-
help with excel [Solved/Closed]
Hello, i have two speadsheets. the first sheet contains a total column EX: in C4 =SUM(E4+G4+I4+K4+M4) Value of C4 = (339816) on...
-
macro not saving file in excel format [Solved/Closed]
Hello, I have a coding like this: filename = Range("B3").Value Workbooks.Add Set newwb = ActiveWorkbook ChDir "D:\P3\Jan...
-
If then excel entry [Solved/Closed]
Hello, In excel, I have a row where hours worked is entered. Directly underneath that row is another row where allotted break time needs to...
-
Conditional formatting in excel 2007 [Solved/Closed]
Hello, I am trying to apply conditional formatting to a calculated cell (For ex A). Criteria: If Cell A value = Cell B or " - "...
-
Select and copy only nonblank cells [Solved/Closed]
Hello, many thanks in advance for any responses I get here, I have toiled in vain on this for hours now. At first it was acceptable to...
-
Date Diff in excel 2010 [Solved/Closed]
Hello, So I want to figure out how to write a formula for a difference in days on a "visit log". I want excel to look in multiple cells....
-
How to name excel sheets on values in columns [Solved/Closed]
Hello, I have a list of people names in a column in one sheet with additional cells in each row for adding data. I want to create separate...
