The discussions
Columns & rows help
SolvedHello all, In short, here is what I need help doing: I would like to take 15 items in one column and transfer them into a row in another spread...
Formula if you have credit in one column, debit in next column
SolvedHello, what is the formula if you have credit in one column, debit in next column and balance in 3rd column. Many thanks R Horner Configurat...
How to re/name a cell if another cell contains x
SolvedHello, Apologies if this is a simple question but having some trouble figuring it out. I have say 1000 rows of data and I need to label them all...
Strike through when entering date
SolvedHello, In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the last d...
Place new code to working code
SolvedHello, I would like to request that some line of code (marks as bold) I have to place in the Working Code which is given below that I cannot figure...
How to apply conditional formatting in excel
Solved/ClosedHello, I need to apply conditional formatting to range H1:H10000 based on corresponding values in another column, G1:G10000. If the value in t...
Excel question, if cell contains certain word
SolvedHello, I have a excel spreadsheet that has a bunch of companys with full addresses, phone numbers, etc. They are all in column A. I want the inf...
Hello, where am i going wrong with this formula?
Solved=P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3),IF(M10>11.8,"CNB",P10) The final result in cell AV10 must be the value in cell P10 plus ROUND(SUM... [H...
I want to build intelligent excel
SolvedTask is: For example I have list of different fruits in cells in separate rows Apple Pear Plum I want the data to be copied to third cell,...
Extracting multiple date from master sheet to new sheets
SolvedHi I run a sports tipping site and I want to extract data from my master sheet to make other sheets. I.e in sports cloumn I have multiple sports and w...
Specific price depending on the words in 2 cells? please help
SolvedHello, I am using excel 2008 for Mac, i need help with the following: example: A1 has a drop down box of 3 choices, apples, pears and peaches ...
Excel 2013 has stopped working
SolvedHello, Every time I'd open Excel 2013 under Windows 8, it would crash instantly, leaving me a message: "Excel 2013 has stopped working". I looked ...
Find data and copy dynamic range
SolvedHello all, I would like to find text in one column and copy the range values which is adjacent to the text searched. I've attached the sample...
Resize the range
SolvedGreetings, I would like to resize the range without keeping the starting position. I've attached the image In the above example, while usin...
Using the if function for dates
SolvedHello, I am trying to figure out in Microsoft excel 2010 the appropriate IF formula to use. I am trying to calculate the number of working days th...
Outlook can receive mail but can't send mail
SolvedHello, I have a friend who is suddenly unable to send emails. But he Can receive, however. Error Message is "unknown error" Ox800CCC13 windows 10 ...
Help writing a if formula
SolvedHello, I need to write an IF formula for excel. Cell A2 will either say ''receive'' or ''deliver''. This formula works IF(A2=''receive'',1,2);...
Help with a formula
SolvedPlease help !! Looking to calculate totals based on the following... Entering the formula in the following field K4 I have rows (B4 thru B18) e...
Formula to add 1 with if statement
SolvedHi, Here's the breakdown of what I'm trying to do: The formula is going in cell 'Y28' and I'm attempting to do two different things: 1) I want...
Forgot cyber cafe pro's admin username and password
Solvedplease can somebody help me. after installing cyber cafe pro 5 for just 4 machines, I completely forgot the admin username and so I decided to unins...
How to remove mark up area in microsoft word 2007
Solved/ClosedHello, How to remove mark up area in word file Configuration: Windows 7 / Firefox 29.0
Not pasting values in excel file
SolvedHello, I would like to know that I have a Excel Macro Enabled File. it has macros, sheet vba code, modules and user forms code and no merging...
Coping formulas to next row using a macro
SolvedHello, I am trying to make a macro to copy a formula to the next row in a spreadsheet. Then paste the absolute values back into the original row. I...
Add a restriction to a column
SolvedHello, Can you please help me out, I'm stuck. I have to restrict the numbers 03 in a column that must contain 11 characters ( the number should st...
Conditional formatting through macro
SolvedHello, I would like to request that how Conditional Formatting would apply through Macro and the Conditions are Range is E11 to E510 if Colum...
Sum values from one column if another column equals x
SolvedHello, Is there a formula that can calculate the sum of cells from one column if the value in another specific cell equals x (or not blank)? I tried...
Transfer worksheet
SolvedHello, How can I transfer an excel worksheet into another excel file. And when transferred I won't have to modify anything. Right now i'm cutting a...
Excel formula
SolvedHello, I'm trying to do a formula like: If value of celA3=sunday, then write dimanche Any help would be appreciated. thanks
Scroll mouse in listbox
SolvedHello, I would like to know that How do I enable mouse scroll in listbox inside a userform. Thanks Configuration: Windows 7 / Chrome 46.0.24...
Copy a 'template' sheet onto multiple other sheets
SolvedHello, i have been trying to create a sheet that creates new sheets from a list and i have been using the following macro to generate the sheets from ...
Add sheets to combobox
SolvedHello, Hi I would like to know that how to add sheets (which are exist in active workbook) in ComboBox used in Userform. Thanks Configurati...
Conditional formatting on multiple criteria
Solvedhi, i am trying to create an excel vba code for creating a conditional formatting where i want to insert colour on the basis of multiple rules. i am ...
Comparing columns in excel 2010
SolvedHello all: I have an excel spreadsheet with 95 columns. I want to compare column 1 to column 95 and highlight in column 1 any line item that is mi...
Set rows height also exception in range
SolvedHello, I would like to request that rows from 10 to 40 their height will be Set to 12.75 but exception rows 11, 16, 21, 26, 31, 36 height will be...
Adobe reader error 0:104
SolvedOne of my users is having a strange issue. When she tries to open a PDF file from within Internet Explorer 8 using Adobe Acrobat Reader X (latest ver...
Comparing rows on two worksheets and pull data into a new sheet
SolvedMy requirement is following: I need to compare Column A, B and C of worksheet 1 to column A, B and C of Worksheet 2 If Above condition is met then I...
Remove (shape) straight line
SolvedHello I would like to request how to remove straight line shape through vba It was made through the following vba code Sub Str_line() ActiveSh...
Home button
SolvedHello, I would like to request for the Macro which always take to "Sheet1" and also deactivated at "Sheet1" Thanks & Regards Configuration: ...
Next and previous button and de-activate at last sheet
SolvedHello, I would like to request to create a button on Sheet that will click which goes to next sheet and this button also de-activate when it g...
A macro to create new spreadsheet and copy data
Solved/ClosedHello, I m a University student and currently learning VBA programming. I have a VBA coursework where i have a file with 63 sheets. is any macro w...
Showing the $ value difference
SolvedHello, I am using Excel 2016.. and need some help. I am doing a budgeting sheet and cant figure out how to do the following; Column A - Budget $ ...
Tell excel where to look
SolvedHello, I am trying to make a cell return a word when you tell it which cell to look in for that word. If i type J2 in a box i want a cell to then l...
Excel: if date =, then enter a value
SolvedI am using this formula and it works well: =IF(A8=DATE(2015,3,27),"1","--") How do I now create a string to check a number of dates (company holid...
Adding two non-adjacent cells (number and text)
SolvedHello, I seem to be having a problem with a nested IF(statement) I am on a separate worksheet that I use to calculate my formulas for my summary page....
Drawback of copy and clear code
SolvedHello, I have requested that please solve this issued if it could be solved. I have found major drawback (May be I am wrong) in the code of Copy ...
How to extract target value from other cell
SolvedHello, I would like to request that Suppose this line of code is working for Column B MsgBox "You entered is Invalid" this will show the m...
Excel is automatically changing dates to a numeric code
SolvedHello, I'm using Excel and when I put a date in a column it changes to a numeric code. For example: 4/5/15 now reads 42099. I've tried highlightin...
Protecting your formulas in multiple worksheets
SolvedHello everyone, thank you in advance for any help I receive with is question. I have multiple worksheets in a workbook that have formulas in them b...
Fix the code
SolvedHello, Its being requested please fix the code given below the problem in this code is that any one of the given condition execute and once ...
Date format changes when editing it
SolvedHi, I'm using Excel 2007. I've changed the date format to dd/mm/yyyy with no problems. However, as soon as I begin to edit a date, it changes to...
