The discussions
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...
Formula issues with various variables
Hello, I appreciate the time the forum are taking to view my message. I'd very much appreciate it if someone could help me, as I'm trying to make ...
Ms office 2007 work on windows 7 ultimate or not
Hello, ms office 2007 enterprise work on windows 7 ultimate or not ? please reply ...... Configuration: Windows / Firefox 29.0
Transfer data automatically from one sheet to other based in
Title->Transfer data automatically from one sheet to other based in specific dates. Hello and sory for my long title. How can transfer data from a c...
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
Updating existing worksheet
Hello, everyone I hope everyone's holiday's are great. I want to thank everyone in advance for their help with this situation I am having in excel. ...
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...
Sort
Hello, On Column A I have DATES Column B a code (D1111, D2222) Column C Vendor num Column D Client num I want to be able to identify when f...
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...
Vba code
I dont know how but I managed to put together a macro that copies transposed info entered in a column of one sheet to a row in another sheet. The prob...
Restriction of @ and .com
Hello, Thank you for your reply, I have another question, if you can help me with that too? I want to add a restriction in a column for suppose C co...
Compare data in two excel sheets
Hello, I have huge data in two different excel sheets (same work book), approx. 10 columns & 5000 rows. I want to compare both the sheets and find...
Excel sheet alphabet count
Hello, How can I count alphabet on excel sheet. kindly send me the details Thanks & regards Pulakesh Medhi
Subtraction total
Good evening, please anyone who can help me, i have in cell J5 all products eg. 20 parts. In cells L5:W5 add how many parts i have used. How i will ...
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...
How to find a blank cell in particular column?
Hello, I want o identify the blank cell in Particular column, and in this my blank cell is my last cell even it would be helpful if anyone suggest...
How to copy multiple lines with a macro
Hello! I have never worked with Macros but I strongly believe they could save my current data crunching work (that I need to finish by tomorrow or ...
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...
Excel formula needed
Hello, Need excel code for min(1-5), N or X Example data: 1. 3. 5. 2 X. --> 1 X. N. X. X. N. -->N X x x x x x x. --> x X 3 2 N. X N...
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...
Vba - copying data to new sheets
Greetings Excel experts, I'm trying to figure out how to tackle a problem. Basically, I have a master sheet with a bunch of data and I would like ...
Weird date display in excel
Hello, This seems like a really simple problem to solve but totally has me stumped. I have entered my date as 30/11/15 (DMY) into the excel cel...
Worksheet_change event
Hello, I have a vb script worksheet_change I am trying to get a conditional If like statement to work in the code where a condition is met from...
Retrieve data from column a based on condition from column b
I have a set of data in a column. Say like below: Col A Sets Apple 1 Apple 1 ...
Autocopy row based on whether the cell in a certain column is
Hello, I have a detailed aging report that I am attempting to create monthly tabs in. Basically what I need is a macro that will auto paste the en...
Going paperless - form replacement - suggestions please.
Hi All, I have no idea how to ask this, so please bear with me on this. My wonderful boss has tasked me with what seems to be such a simple idea...
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...
Will open office work on windows 10?
will Open Office work on Windows 10?
Download a file on pdf from email
Hello, I want to download a file on PDF from my email. Thanks Configuration: iPhone / Chrome 46.0.2490.76
Problem when format date option
Hello, I have a date "17/07/15" and "01/07/2015" i want to change it to "July-15" format for all cases. I go through format option and select the op...
Copy outlook email account settings
Hello, Is there a way to copy email account settings? I want to set up outlook to be able to send mail from the same account for several people ...
Excel and dates
Hello, I have three columns, for example 19-Nov-15 then 26- NOV-15, I want the third column to = the most recent date of the two +7. because I nee...
Copy invoice dates to ledger
Closed@vcoolio Read your reply in an earlier post. copied it to my use, but this did not work. please help. I am copying a list of cell entries from invoi...
How to convert number into words
Hello, pl give the solution
Transfer data from excel sheet to excel sheets.
Hello I have a table contains about 5000 rows and 4 columns. The columns are Date, Codes, Department and Amount. I entered one year's data in that ...
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...
Chance excel to pdf
How can it possible excel sheet to PDF? -- ifti
Date change to dd/mm/yyyy to dd/mm/yy
Hello, I Want to change date format dd/mm/yyyy to dd/mm/yy in MS Excel 2003 Please revert me urgently Configuration: Windows XP / Chrome 46.0...
Calculation of age
Hello All, I have been trying to calculate the exact age of a person from two dates in Office 2007. In the first cell I have the current date and i...
Create a summary table from a master table
Hello, I need a formula to create a summary table from a master table as below : Item Des. year ...
Get other cells value
Hello, I am stuck in a formula and I cannot solve it. Please I need help. I am making a survey on excel, and I need the result for a whole month ...
Compare excel sheet1 to sheet2 and highlight changes in sheet2
I have explained my query in screenshot. Somebody please help me get this resolved.....
Export data from one sheet to another
I need help. I have a form call Purchase Request from where I want transfer data to different fields in next sheet and then need to raise Purchase ...
Copying cells if criteria is met
Hello, I have multiple sheets with sheet 1 as the main sheet for entering data. A cell for entering a order number Cells for entering invoic...
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 ...
Averageif function using dates
Hi there. I'm trying to set up an average function based on dates entered in column a, for the data in column b. I want to use the data in b if the...
Compare to columns in v lookup
Hello, hii i want to compare to columns in v lookup.. Pls advise ... Configuration: Windows 7 / Chrome 44.0.2403.155
