Office Software Forum
- Excel (9,685)
- Open Office (111)
- Outlook (632)
- PDF (333)
- PowerPoint (171)
- Word (2,172)
-
add a restriction to a column [Solved/Closed]
Hello, 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? [Closed]
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 [Closed]
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 [Solved/Closed]
Hello, 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 [Closed]
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 [Solved/Closed]
Hello, 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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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. [Closed]
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 [Solved/Closed]
Hello, 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? [Closed]
will Open Office work on Windows 10?
-
download a file on PDF from email [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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...
-
Custom Message Box in Macro [Closed]
Hello, I would like to ask that how could custom message box having custom button will be created. I have a code given below I need a changes wh...
-
can't view Mail attachment on my z30 blackberry mobile-pdf [Closed]
Hello, I can't view Mail attachment on my z30 blackberry mobile
-
Image into Table [Closed]
Hello, I have inserted a picture in my table and have formatted it with Wrap Text. Problem is when I try to copy and paste this entire table, my p...
-
Diagram generator with logical handling [Closed]
Hello, I'm looking for options to make flowcharts and related graphics. Rather than being interested in many customization options or visual effec...
-
How to convert number into words [Closed]
Hello, pl give the solution
-
vlookup or is blank?? [Closed]
hi i need a formula to copy cells that are not blank or error if possible. in th picture attached i want the time to copy to the names with out th...
-
match col A sheet1with sheet2 found write row sheet3 [Closed]
Hello, Need help. I have 2 sheets both contain same type of data in random and also duplicate rows. I need to 1. copy sheet1 row and sheet2 row i...
-
PDF [Closed]
I NEED PDF CREATER SOFTWARE
-
Transfer data from excel sheet to excel sheets. [Closed]
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 [Solved/Closed]
Hello, I'm trying to do a formula like: If value of celA3=sunday, then write dimanche Any help would be appreciated. thanks
-
converting 179 HTML Files in a folder to docx (word 2010) [Closed]
I have a folder consisting of 179 HTML Files saved in a folder to convert to word (2010) then remove all the residue html formatting (removing page n...
-
Scroll mouse in ListBox [Solved/Closed]
Hello, 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 [Closed]
How can it possible excel sheet to PDF?
-
Date Change to dd/mm/yyyy to dd/mm/yy [Closed]
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 [Closed]
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 [Closed]
Hello, I need a formula to create a summary table from a master table as below : Item Des. year ...
-
Get other cells value [Closed]
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 [Closed]
I have explained my query in screenshot. Somebody please help me get this resolved.....
-
Export data from one sheet to another [Closed]
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 [Closed]
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 [Solved/Closed]
Hello, 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 [Closed]
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 [Closed]
Hello, hii i want to compare to columns in v lookup.. Pls advise ... Configuration: Windows 7 / Chrome 44.0.2403.155
-
Add Sheets to ComboBox [Solved/Closed]
Hello, 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 [Solved/Closed]
hi, 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 ...
-
Conditional formatting cells containing IF rules [Closed]
Hello, Cell D11 contains the rule "=IF(D4>0,D4,"0")". I have set conditional formatting on the entire spreadsheet to show that if value is grea...
-
Copy data from another sheet if the condition is met [Closed]
Hello, Can you help me how can I create macro that will copy the data from one sheet to another sheet in the same file? Wherein if the Posting Acc...
-
Transfer Data IF.... [Closed]
Hi, I am in the process of building a database for injury management (I am a Sport Scientist). I have a master sheet which is basically a monthly ...
-
Multiple formulas for multiple sheets [Closed]
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...
-
How to convert a numeric value into English words in Excel 2007 [Closed]
Hello, Configuration: Windows XP / Chrome 43.0.2357.134 Sir, How to convert a numeric value into English words in Excel 2007 in software
-
Outlook.com [Closed]
Hello, I have a email that I consider as voluntary work. Address is: ***@*** I would like to have a personal email that will not be affiliated ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram
- Computer Boots to Black Screen
- How to Install a VPN
- How to Get Free Diamonds in Free Fire
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- How to Disabled Write Protection on a USB