Excel Forum - solved topics
- Solved
-
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 the...
-
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 "true"...
-
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 the ...
-
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 following....
-
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-mail...
-
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 than a...
-
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 link http://ww1....
-
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 the ...
-
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-11\B2B" ...
-
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 be ...
-
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 " - " then ...
-
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 simply c...
-
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. (basicall...
-
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 excel s...
-
How to insert rows dynamically with in group Solved/Closed
Hi, currently I am creating a macro, in to that I have data for row and columns. now I want to count the product in column A, with formula =counta (...
-
Macro to class interval Solved/Closed
Hello, I have a workbook of employee data and at dth column i have ages of employee. in eth column i have to define age interval like. 18-25...
-
Excel less than but greater than Solved/Closed
Hello, How would I get into L2 if J2=>10 then "lates", if J2=
-
Excel if function Solved/Closed
Hello, Could someone please help me with the following problem. I want to know how to do a if function in vba to search for a value (output), a...
-
ms excel Solved/Closed
Hello, I want to use ms excel but i am not getting any option of ms excel in my computer how can i use ms excel when i don't have it.......? ...
-
Button to color sertain numbers (Excel) Solved/Closed
Hello, Im looking for a way to make a button color all numers equal to the the number on the button.. as an eksample, lets say i have a row of...
-
import excel data into mysql database Solved/Closed
Hello, This is Nischala .Can any one suggest me wheather we can import excel sheet data into mysql database using .net application(vb.net or asp....
-
IF-Then statement to copy rows Solved/Closed
Hello, I am wondering if there is a way to copy a specific row from one worksheet to another in the same workbook based on an IF-Then statement. ...
-
Excel Macro Assistance Solved/Closed
Hello, I have a macro running a process of performing a couple of formulas in a workbook that uses VLookup. Every week I have to re-edit the r...
-
Converting date in VBA Excel Solved/Closed
Hello, I have a spreadsheet that has: Column A: Year Column B: Month Column C: Day Is there a way to convert these 3 columns into the actu...
-
MS Excel 2007 IF Function problems.? Solved/Closed
Hello, I need immediate assistance. basically i am trying to use the IF function to display less than 18 "no", more than 18 "yes". but if 23.5/...
-
Excel Macro Copy data to next sheet using < Solved/Closed
Hello, I'm looking some time now around this forum and ditn't find what i'm looking for. So i'm just gonna ask it here and hopefully someof your s...
-
Macro to fill down in a range Solved/Closed
Hello, Thanks to all who provide help on this site. I'm new to writing macros so hopefully you might be able to steer me in the right direction wi...
-
excel copy and paste Solved/Closed
Hello, I have been given a list of 200 codes but they are in the wrong order. for example it goes 12378945610. so i want to swap the 456 and the 789...
-
Excel - Check rows for data, copy to new Solved/Closed
Heya folks! I've been reading the answers to similar questions and I plan to try and patch something together, but I thought I'd put a (more) specifi...
-
Lookup or find in excel help Solved/Closed
Hello, I have 2 data sheets sheet one contains my Master list of items by number Row 1 Column 1: 453658 Row 2 Column 1: 839565 Etc my secon...
-
MS Excel, Stripping Out Char(10) Data Solved/Closed
Hello, I working in Excel with VBA and have 5 or 6 rows of data located within 1 cell. The user has decided to use Alt-Enter whilst entering the da...
-
can ping but can't use browser in normal mode Solved/Closed
Hello, I also have the problem where I was unable to connect to the internet via any browser, but I can ping my router. I noticed that turning off...
-
Excel work sheet how to i open Solved/Closed
Hello, When i am trying to open an exel sheet saved from windows 7 platforms, i am unable to open in windows xp plantform. the file that i was co...
-
Copy rows n times and then fill a series Solved/Closed
Hello, This is variation of a question that has been answered previously. Does anybody know how I can repeat rows in a spreadsheet by n number of...
-
Pie chart in excel Solved/Closed
hi there im trying to make a pie chart in excel but i don't really know where to start...can someone help me thanx!
-
How to interchange the columns in notepad Solved/Closed
Hello, I have data in three columns. I want to inter change the values of first two columns without changing the third one in notepad or in word p...
-
Excel Sum Greater than but Less Than Solved/Closed
Hello, I am trying to get a cell to show the answer if - The date in B5 minus the date in B10 is less than 60 but more than 30 then F10 should sh...
-
Comditional Formatting Relative Recording VBA Solved/Closed
Hello, I want to compare a cell to its adjacent cell on the left. If the value of the selected cell is higher I'd like to colour it green, if it's...
-
tecno free browsing Solved/Closed
Hello, pls help to find free browsing configuration setting for my tecno T570 dis is my phone no 07036713275 I will compeciate u with something ...
-
no address bar on my browser Solved/Closed
Hello, i dont know how to get my toolbar back up on my screen can you help me its a windows xp
-
copy data one excel sheet to other sheet Solved/Closed
Hello, any one help meee please im running that macro and getting data from one sheet to other one issue i have when i run that macro the window ...
-
Simple Macro Error Help Solved/Closed
Hello, I am using Excel 2007 on Windows XP I am trying to write my first macro that will simply place the following formula into a cell. The ...
-
Deleteing Rows in excel Solved/Closed
Hello, I work with a lot of files every day and the number of data in column A is different from the rest of the column. The number of data ar...
-
Excel comparison of partial or wild card data Solved/Closed
Hello, I have two columns in Excel that I want to compare. The data in work sheet 1, column A has values that are tabbed. This data has the adjac...
-
Sheet-1 + Sheet-2 Solved/Closed
Hello, i have a problem plz solve it and tell me solution i want to count some cells which are Sheet-1 and in Sheet-2. Example: (Sheet-1) A1+A...
-
Counting in Excel Solved/Closed
Hello, In the U column shows "Good" and "Bad" answer that resulted from a formual that I used. How can I count the the toal number of Good a...
-
Excel help with what if Solved/Closed
Hello, I have all the states in column A and I need to result to display in column B. I need Column B to show "Yes" if column A has: MT, ID, ...
-
Conditional Formatting (more than 3) in Excel Solved/Closed
Hello, i am trying to apply more than three options to excel that changes the background colour of the cell. my range is R7:R1000 i need a VBA ...
-
Excel Question Solved/Closed
Hello, I have one worksheet with with all of my emails (both good and bad) D2:D3843 and another worksheet A2:A1061 with all good emails and I need...
-
Class Result In Excel Solved/Closed
Hello, I have worksheet of class result.In column A there are names of students. In column B i have marks. I want a formula which tell me the name...
