Office Software Forum
- Excel (9,702)
- Open Office (111)
- Outlook (632)
- PDF (333)
- PowerPoint (172)
- Word (2,176)
-
Multi percentage Calculation [Closed]
Hi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here I attac...
-
If dates range [Closed]
Hello, I need help for a function. Lets say that we have the today date 4/12/2014. I need a formula to use in conditional formatting. If the da...
-
How to count different charecters [Solved/Closed]
Hello, Please help me to count different charecters like xpa, spa, spb xpb.. if any of this exist in the cell it should count. if xpa is in A1 spa...
-
Date if statments [Closed]
Hello, I have a if statement that I need help writing. I have a today date cell and I have closed date. I am trying to make the new cell check i...
-
pdf files into source safe seems to corrupt them [Closed]
I have about 40 pdf files, that are accessed and viewed by the application. I am having a problem. Basically adobe reader displays a blank document. ...
-
Check if input number is minimum and display a pop up dialogue [Closed]
Hi, I am novice VBA developer. I am trying to write a macro which does following. 1.When a user enter a particular value into cell 2.Check if ...
-
change date format [Closed]
Hello, Change date format dd.mm.yyyy to dd/mm/yyyy for excel 2007
-
for progress billing [Closed]
Hello, how can i automatically know the percentage area of a accomplished tiles by simply counting the tiles Configuration: Windows / Chrome 3...
-
compare two excel sheets and get unique value from both into new [Closed]
Hi, I have two excel sheets. Sheet 1 with 4 columns and sheet 2 with 2 columns. I need to compare column 1 of sheet1 with column 1 of sheet 2 if it m...
-
Help. Recover deleted in the MDB (Access2003). is it possible? [Closed]
Today I foolishly put things in order, "cleaned up" entry in the table in the database Access97 (mdb file). These data are for my work is very importa...
-
How can I transfer data from one spread sheet to another? [Solved/Closed]
Hi, I'm working in excel and on one spreadsheet and I'm having to retype everything on to another spread sheet, I want to be able to have my data ...
-
Finding data in different Excel sheets with month-sort by VBA? [Closed]
Hello, I have 2 workbooks named DB1 and DB2.The first one involves 12 sheets sorted by months names for example:"Apr-14" ,each sheet contains a tabl...
-
automatically moving rows from sheet 1 to sheet 2 [Closed]
My document has several sheets, but what I'd like to do is create a VBA to automatically move a row to sheet 1 from sheet 2 when I have selected 'Acti...
-
Repair Corrupt Excel File [Closed]
I have an excel 2003 workbook that will not open. The file is huge. I have tried the repair utility within Excel but it still will not open. Has an...
-
Data validation [Closed]
I want a sheet of income tax calculation, so i like a input a cell pan no. so allow in cell LENTH 10 DIGIT AND first five text and mid four number and...
-
2 macros in one sheet targeting same cells [Solved/Closed]
This is probably a really 'newbie' question but in all honesty, I'm new to macros and need some assistance. I have a macro written to automatically...
-
Lock Flag ignored:How is this possible? [Closed]
Hello, Cells C4 and D4 are empty cells, and both are locked in Format Cells->Protection-> Locked. I go to Tools-> Protection-> Protect Workshee...
-
corrupt 'msmMMOB.mdb' file [Closed]
In the process of cleaning up my harddrive, some files have been shuffled between OMFI MediaFile folders. Upon startup, Avid rescans the folders, how...
-
Help me on this formula to shorten [Closed]
Hello, please help me out to shorten this formula.. =IF(B53="SP1",2,IF(B53="SP2",2,IF(B53="SP3",2,IF(B53="SP4",2,IF(B53="SP5",2,0)))))+IF(B54="...
-
How can we find data in different Excel sheets by VBA? [Solved/Closed]
Hi.I have 2 workbooks named DB1 and DB2.The first one involves 12 sheets sorted by months names for example:"Apr-14" ,each sheet contains a table wit...
-
Create a new sheet using data in one column copying data [Closed]
Does any one know how to create a macro which takes the following data: A B C D 1 Rabbit Carro...
-
Copy rows from activesheet and create and paste in new sheet. [Closed]
Hey guys I have a workbook with +-5000 rows of rooms in different buildings. I want use the column BUILDING_CODE and copy all the rooms that have ...
-
Copy template .xlsx file based upon unique cell values [Closed]
Dear All, Need you help for copying template .xlsx files based upon the unique cell values present in another excel file called file1.xlsx-->values i...
-
Conditional formating to check text in another shell + numeric [Solved/Closed]
I have some text in A column ( say xxx, yyy) and numeric value in Column B . Now i want to highlight the shell in column B with 4 condition . 1....
-
customize multiple workbooks [Closed]
I am currently working on attempting to consolidate excel workbooks in that I am looking for a way to input in one workbook and have it transfer to 2 ...
-
How do i copy database information to excel? [Closed]
How do i copy information from a database to an excel sheet?
-
help me to count 2 cells [Solved/Closed]
helo, please help me to count 2 celles A1 Is either 0 or 2, A2 is either 0 or 2 IF A1+A2=0 A3 should be 6, IF A1+A2=2 A3 Should be 3 if A1+A2...
-
lock cells in Excel [Solved/Closed]
After setting up VB to lock cells in Excel I now need to lock additional cells. I currently have the following script (kindly given by rizvisa1) which...
-
csv to xml in macro [Closed]
how to convert one csv file to xml using macro No description PLMN-PLMN/BSC-393337/BCF-1012...
-
help me to count different charecters on 2 cells [Closed]
Hello, Please help me to count different charecters like xpa, spa, spb xpb.. if any of this exist in the cell it should count. if xpa is in A1 spa ...
-
Help - how to conditionally copy columns to multiple worksheets [Closed]
Hi, Newbie member searching for a solution to what is probably a straight forward problem. I am new to Vba so have little understanding but am famili...
-
Needs some help with a formula [Solved/Closed]
Hello, Configuration: Windows XP / Firefox 33.0 Okay, here is a problem I've been dealing with for over an hour now. This should be easy, but ...
-
An outlook express store file is damaged. [Closed]
Hello everyone. Can you help me! Whenever i open express outlook error is showing up and i cant receive or send mails. It's written that outlook expr...
-
Copy row from sheet 1 to sheet 2 if value is x [Closed]
Hello, I've searched around and can't really find anything that answers my question or I can understand. I'm quite able with excel but not great w...
-
Excel Help with Macro [Closed]
I have an excel workbook with 4 Sheets. Sheet 1 (summary) is a ledger. Sheet 2 = Bob Sheet 3 = Bill Sheet 4 = Bart Column D in the ledger ...
-
Macro program for sum [Closed]
Hello, I need to find out a formula for sum for the following conditions if (and(cell b1="text", cell b5="text",cell b10="text",cell b16="text")s...
-
Date Formating [Closed]
I have a huge file with date format in column "e" 3/8/45 and I want to change it to 8-Mar-1945. Also birth date is in col. e15 and the death date is...
-
Numbers & Symbol ü (New Challenge) [Solved/Closed]
i need a formula to automatically check mark i.e(ü) mark a cell(eg:A1) if another cell (eg:H1)contains number:1 Condition is H1 may contain any numbe...
-
Copy Data On Condition From One Sheet To Another [Closed]
Hello, I have 15-16 sheets.. AND I ENTER data in sheet1 & sheet2 .. i want a code that can copy data from sheet1 / sheet2 to sheet3 or any other s...
-
Message Boxes [Closed]
Hello everyone, Does anyone know if it is possible to format a basic message box (just font and colour)? Or is it a case of "what you see is what y...
-
printing the same worksheet changing a cell with data populated [Closed]
How do you print the same worksheet repeatedly, changing a cell with data populated from a table?
-
Copy data from one sheet to other sheet. [Closed]
Hi guys! I have a problem coping data from one row within a specific range, example A2, B2, C2, D2, E2 and so on up to P2, and copy that data to diffr...
-
Excel Auto Create Sheet and Populate [Closed]
Hey Everyone, I'm looking to create the following; I have a list of employees who will be working on an event. The event is broken up into stages,...
-
Copy data from mutiple workbooks and paste below each other [Closed]
Hello, I need to copy data from multiple workbooks and paste in another workbook below each other. This is the first part. I need to copy data...
-
Total up boldly formatted cells [Closed]
Good evening much appreciated volunteers I am using an Excel 2007 spreadsheet to keep track of costs associated with a holiday. I have bolded al...
-
How to date tabs in sequential order using Macro [Closed]
Hello, Not too long ago I came across a helpful Marco that dated each Excel worksheet tab in sequential order with the Month and Date (i.e. Nov 1 ...
-
help on making student report card [Closed]
Hello, hello i was thinking about making student report card system in excel, no of student is around 40 in one class ...........please tell me ...
-
Comparing worksheets in excel [Closed]
Hello, I have 2 sets of data in Sheet1 and Sheet2 in excel. Both sheets have the same 7 columns and I want to compare the data in Sheet1 and Sheet...
-
Sending emails is not working on out look can receive though !! [Closed]
Hi really hope you can help as 3 days of not being able to use my email and I'm going to have such a back log. I use sky email but through out look...
-
Copy a row to another sheet if a value is x [Closed]
Hello, I'm searched around and can't really find anything that answers my question or I can understand. I'm quite able with excel but not great w...
Subscribe To Our Newsletter!
DON'T MISS
- How to Fix a Blurry Snapchat Video
- Facebook Code Not Received
- How to Install a VPN
- How to Create a Gmail Account
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB
- How to Get More Followers on Instagram
- How to Recover a Disabled Facebook Account
- How to Get Free Diamonds in Free Fire
- How to Recover Your Yahoo Account
- How to Upload High Quality Photos to Instagram