The discussions
Popup menu with count
Hello, Can you help me with this? I have list of 150 driver's with licence valid upto info in D3:D153. I am trying following things 1. Check if va...
Writing a macro
I am struggling trying to figure out how to move data to a new line by inserting and not copying over other data, plus removing data based on specific...
Macro to copy column, open existing document, paste & save?
Hello, First of all, I'm essentially a VB novice - I've copied and applied a few very basic scripts, but nothing of this magnitude, so any and all...
Recover corrupted outlook express folders
SolvedI accidentaly deleted some folders in my Inbox Folder. My problem is now, how do I get back the .dbx files without losing any important information? P...
Transfer data from one sheet to another automatically
SolvedHello, I would like to populate data on a spreadsheet based on data obtained from another. Is this possible? If so, how can I do this? Example: S...
Formula with @ in cell
Hello, Could someone please let me know if there is a formula to get a total if row 4, column D is 8 @ 2000 and row 6, column D is 9 @ 2000. The...
Vba code for bank recos
Hi All, Greetings I am looking for a VBA code for bank recons where I want to reconcile cash & bank statements, where i want to move match items...
Please help resolve this
Hello, =IF(B1=Sheet2!A1,C1=Sheet2!B1) i have a cell in sheet 1 need to write the price from sheet 2 when I put a certain text in sheet 1 Conf...
Can not open any documents in word
Hello, I would like to open files and not able to open in MS Word Configuration: Windows / Chrome 41.0.2272.118
Macro for deleting everyother six rows starting with row 7.
Hello, I am trying to use the macro function to delete six rows, skip six row, then delete six and so on. Can you help me? Configuration: Windo...
Microsoft outlook pst file cannot repair
Experts, I have a user, who has left the company, however the manager of the department needs to view this user's outlook pst file. The pst file i...
Conditional formart
Hello, i have like four colums like below Name Age DOB Status AAA 23 XXXX Active BBB 25 xxxx ...
Input repetetive data
Hello, I have to input 100 + truck weights, number plates, ticket nrs and loading times. I was wondering if any one had an easy to use template ...
What cell is my data coming from?
SolvedOh dear - back again ... :^( After you guys help again with VBA. I'm never going to volunteer to try script-writing again! (at least not without...
Complicatied find and copy cells to new sheet macro help
Hi I am new to excel macros and trying to sort out a large sporting club file. Basically what I want to do is copy all player information from team "X...
Conditional formatting with dates
I am trying to fill cells in a column which contain a date that has already passed. I go to 'Conditional Formatting', choose 'Manage Rules' and click...
Conditional formula - what if
I need to create a what if statement for a workbook. Example below... here's what I need, if Column B has the words "Left Blank" I need for it to ...
Set up a count loop
Hello, How do i set up a count loop Configuration: Windows 7 / Chrome 41.0.2272.118
About comments.
Hello, I have a data in A1 cell and certain information of this data is in other sheet. Now i need a pop-up comments when mouse just moves near...
Transferring information from previous spreadsheet
SolvedHi everyone, I'm a junior doctor from Australia, and I'm trying to use excel to make my ward management a more efficient process! Everyday we get ...
Excel- a macro to copy data from one sheet to another
Hello, Could anyone help me with this. I am trying to write a macro with following criteria. 1. Every week a set of data is entered into she...
How do i resolve file corruption errors in powerpoint 2010?
SolvedDear All, One of my colleagues is getting an error frequently(attached) in powerpoint 2010 and as a result he keeps losing many slides that he prep...
Single quote - excel 2007
SolvedHi, Does anyone know what the single quotation mark ' means when entered at the beginning of a cell? I notice that the quotation mark does not ...
Conditional formatting based on expiration dates
SolvedHello, I am trying to figure out how to introduce conditional formatting to a range of cells with date values. I want each cell in the range to b...
How to convert ost file to pst file?
ClosedHello, We only have the OST file and no longer the PST file for outlook 2007 application. Can you please send me some easy to use and reliable sugg...
Two criteria to check if a date in excel
SolvedDespite my best efforts going round in circles on a simple problem. Help gratefully accepted.... If say, Cell A1 can have two values - "In" or "Out" ...
Formula to add big number of day to date in excel sheet
SolvedDear Please advise me how I can creat formula in excel sheet to help me to calculate due payment day for LC. As example I want to add 120 or 180 day...
Using the last few characters on a different sheet
SolvedHi All, Me again - I HATE VBA! it is so simple that I get frutrated when I cant get a simple thing right. Im trying to write a VBA script that n...
How can data automatically go into a calendar created on excel?
Hello, I created a calendar on excel to collect past, present and future data but I wish to run it automatically. I know how to link data from on...
Excel question
Hello, I am looking for a formula for excel: I have three tabs, how to make one cell automatically return to "1" within the first tab; and the cel...
Conditional formating
I have a spread sheet with 2 columns; In column 1(one) I am tracking Employees. in column 2 (two), I track the employees position. When a position i...
Vlookup won't work
SolvedI am trying to set up a formula in Excel 2013 that says to look at what is in X11, find the title and explanation in a group of cells on another works...
Adding one day to a date
Hello, I have a spreadsheet that i use for planning truck maintenace, I am trying to work out how to have 2 buttons that i can assign 2 macrows too,...
Error message when sending an email to a specific address
Hello, When I send an email to a couple of addresses, from Outlook, I receive the following message: "Delivery to the following recipients was abo...
With the help of name we can get the data one sheet to another
Hello, with the help of name we can get the data one sheet to another sheet in excel in pdf Configuration: Windows XP / Firefox 12.0
Please help, counta and countif same formula
Hello, Please help me, I am trying to accomplish is this: I would like to count the text in Range (B1:b5) excluding duplicates, however only i...
Autogenerate worksheets from a list of names... adding names?
Hi, I'm trying to auto-generate worksheet from a list of names. Reading other questions in the forum I found the solution for this questions. But I ...
Not showing save as dialogue box.
I am an office assistant. Every time I have to spell the numbers in words. I got a solution from net that a function can be added to the function libr...
Set cell value
SolvedHello, how to create formula for: if AI=1, B1=2 than show C1= 25....... if A1=1 B1=3 than show C1=28........ if A1=5 B1=5 than show C!=32.... ...
Vba copy sheet to new excel file + automated manual data entry
SolvedConfiguration: Windows 7 / Firefox 35.0 Dears, I hope this is not a to extensive VBA script request and this is the place to ask. I need to cre...
Ms office 2010 save as message shows
Hello, When working on a network shared file in MS Office 2010 , file opens quickly but when saving file shows Saving as massage comes & takes 40-50...
Excel formula
Solvedhello, hope you can help! working on an excel spreadsheet and require a formula: If cell a > 0 then cell b should equal the value in cell c thanks ...
I need a macro that can extract data
Hello, I need help with creating a macro that can automatically copy data from different worksheets and put it into a master worksheet for a repor...
Recover deleted emails in outlook express...
Solved/ClosedHi! Prompt please... Is there any way to recover deleted e-mail messages in Outlook Express? An important message was accidentally deleted from the...
Code visual basic
SolvedHello, I've been unable to copy data from one sheet to another, based on selecting multiple criteria. I've been able to use the string below t...
Compare range of cells and get the result of a third cell
Hello, i have a file with 3 columns, i need to compare each cell of the first 2 columns and of it match print the data that in the third column th...
Copying a conditional format to other cells...
Hello, I have set a formula to calculate how many days between two dates i.e. Date in A5 - date in A4 +1 = number of days in A6. Pretty simple ok....
Excell 2013 - conditional formatting using a formula- apply rule
SolvedHello, I am trying to do the following : A1:A100 ==> dates B2:B100 ==> dates 1) apply conditional formatting to columns C1:BB1 if the containe...
Excel formula display in cell
SolvedHello, Apologize if the question is too stupid. In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to display the formula in cell A6 for this...
About open office
Hello! How I,m donwloading full version Open office
