Office Software Forum - solved topics
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
- Solved
-
Date formatting Solved/Closed
Hello, I am currently downloading a report from an external source (csv file format) into excel and one of the fields (column P) should be represen...
-
Excel Solved/Closed
Hello, I have an excel file with Start dates, end dates, total day, and networkdays columns. I would like to average these number for the average to...
-
For each cell... VB HELP Solved/Closed
Hello, Column A contains either "Ja" (yes), "Nee" (no) or nothing. I would like to know on which date the cell value is changed to "Ja". Therefor...
-
F 5 problem Solved/Closed
Hello, Up untill yesterday, when I used F 5, the cell that I was going to always ended up in the upper left corner of the screen. Now it goes to so...
-
MS Words into (comma-separated) text file Solved/Closed
Hello, What I try to do is that convert multiple MS forms into tab-delimited text files. If there is a quick and dirty way to do so, please let me ...
-
Need help with a formula please!!!!! Solved/Closed
Hello, I and creating a spreed sheet for my job to make weekly counts easier. I have been trying for hours now on a formula to calculate either a...
-
Problem with "Lastline" in VBA Excel 200 Solved/Closed
Hello, Let me start off by saying that I'm a VBA noob, and have never worked in it before. Basically, I inherited a spreadsheet which has a macro t...
-
Changing h:mm AM/PM to hhmmss Solved/Closed
Hello, I need help changing imported times from i.e. 2:38 PM to 143800 (hhmmss). Please Help!! Thanks, icooper
-
moving the contents one cell up in a column Solved/Closed
Hello, In my excel sheet the column C has contents in alternate cells starting from C1 till end. It looks like C 1 ...
-
formula to copy data Solved/Closed
Hello, I have a range table that is 18 columns. I want to be able to look up the number in the first column and return all the info in the other 17 ...
-
If statments w/ <= dates Solved/Closed
Hello, Hello Want a brain buster? Its been busting mine all day…… I'm trying to create a statement for column J "frequancy of visit" to ret...
-
Macro to delete created object Solved/Closed
Hello, With the following VB code I have created a wordart object: Sub ShowMessage() ActiveSheet.Shapes.AddTextEffect(msoTextEffect1, "Even...
-
looping for a specific time Solved/Closed
Hello, I'm using Excel 2007 I have the following code: Sub Macro1() With Selection.Interior .Color = 255 End With Appli...
-
What about mail account deleted? Solved/Closed
Hello, i had sent a email to a friend and after sending the message came that the mail has been sent but he says that he has deleted his account . so...
-
copy/paste values on the specific column Solved/Closed
Hello, I want to, copy/paste values on the specific column based on cell A2. i.e. if cell A2= 1 then copy/paste values for the January column (range...
-
Delete certain cells of active row Solved/Closed
Hello, I would like a code for the following: Check which row is active/selected and then delete the data which is in the 5th and 7th column of ...
-
insert rows based on count of row in another Solved/Closed
Hello, I have a excel where I create few dummy accounts and the next sheet (sheet2) has details of these accounts. I need the sheet 2 to have certai...
-
last value in a row with diff. 25% on rel val Solved/Closed
This is tough to even state, but I'll try with an example Example: find the first value that changed 50% in relation to the last time when there wa...
-
colour Solved/Closed
Hello, Hi and thanks for previous help. Last one for a while (I hope) I am using the below formulae you gave me and it is fine. However these res...
-
Excel Macro - Dynamic Column Selection Solved/Closed
Hello, I am just beginning to learn Excel macros. I was working on a sheet wherein I have to select a column dynamically, based on just the column ...
-
Text box linked to cell value Solved/Closed
Hello, I have a text box placed in a chart that links to another sheet/cell for its content. The value is a percentage. I can format the source text ...
-
Dates Solved/Closed
Hello, Crazy question.... I have a row full of different dates. I would like to create a formula to display in a separate cell, the earliest date fr...
-
Separate required records from a file, MAK Solved/Closed
Hello, I am using following macro to separate required records from a file contain several worksheets and each worksheet contain thousands of rec...
-
Excel conditional formatting row color Solved/Closed
Hello, I am trying to get Excel to automatically change the color of a row depending on the entry in column H. I've got some VBA code written up, but...
-
MATCH formula with external lookup_array data Solved/Closed
Hello, I am trying to write a formula using the MATCH function =MATCH("x",r1:r10,0) to find the first instance of x in a column. Howev...
-
Copy Data One Sheet to Another Solved/Closed
Hello, dear friend i have two work sheet.first sheet has a data.using subtotal function I'm daily taking summary of that data.that summarized data da...
-
Macro to Compare two sheet with both sheets h Solved/Closed
Hello, I have a 2 excel sheet which has all the column having same. This has D$C Comment, OMS comments, Planned Resoluiton date & Sub account in bo...
-
Lookup,count and pie chart Excel2007 Solved/Closed
Hello, Can anyone give advice? I got a form on sheet1 thats got a savebutton to save the input data of the form to the database on sheet2.On sheet2 ...
-
scores Solved/Closed
Hello, Hi I will sonn get a sheet of student exam outputs listing there choice of answer from a to p for each question. I have a space st the top of...
-
how to match value with table Solved/Closed
Hello, I have a problem to match the value from sheet 2 with another sheet name table. I want to compare if the value near with the value in the tab...
-
Countif based on two criteria Solved/Closed
Hello, I'm tinkering with a spreadsheet I use for my business and would like to create a count of the number of products dispatched on a date. I ha...
-
Changing color of a cell in a table... Solved/Closed
Hello, I'm afraid that this post rather fits into the "free help" section of things here, I am a person with a basic knowledge of coding and i...
-
How to fill selected cells with given data? Solved/Closed
Hello, I often need to fill cells with a date of production. What kind of a macro would be usefull in this situation so that I could just select the...
-
Selectively Transfer Data toPre defined Range Solved/Closed
Hello, I am new to Excel VB. I'd like to compare a set of data from worksheet1 by meeting a set of multiple conditions/criterias and then transfer ...
-
Find a string in Excel and remove all cells Solved/Closed
Hello, I need to find a string (for example: abc) in a large worksheet then remove all cells containing this string. I have tried different functions...
-
Cut-paste row to sheet2 if columnvalue is met Solved/Closed
Hello, I have got 2 sheets. Sheet1 contains a list of assignments, in which column B contains the status of those assignments. Sheet2 contains comp...
-
Converting a number in words into a number Solved/Closed
Hello, i want to convert wrods into a number.Let me say more clearly... if i take " one thousand five hundred six " it should be converted into ...
-
column comparison Solved/Closed
Hello, i have two columns to confirm the name , I want 2 identitfy; do the first column name is same person in the weccond column for example...
-
Excel help Solved/Closed
Hello, I am having trouble with an excel calculation, i'd be grateful for any help: I have menu items listed along the top, with a space for th...
-
getting perfomance of each vendor using excel Solved/Closed
Hello, What I want is to get an evaluation of every supplier. Let say I have 20 list of supplier and list of product I'd ordered, including quantity...
-
Find a text in a sentence inside a cell Solved/Closed
Hello, I have a column which has addresses of different Companies, eg. SHRUTIVEER,23/2/1/1 BHAGBAN CHATTERJEE LANE,HOWRAH 711101 2nd Floor, Eas...
-
adminstrater password problems Solved/Closed
Hello, my 10 year old daughter changed her password on laptop on the admin user she cant remember her password .
-
copy a "Comment Text" in to "Cell T Solved/Closed
Hello, my Self Deepak Kumar, I can't find the fomula how do Copy a "Comment Text" in to "Cell Text" in another sheet. Regards Deepak Kuma...
-
Date Format TODAY Solved/Closed
Hello, I have an invoice with a date format "TODAY". If I create an invoice today, it assigns today's date. If I open the invoice tomorrow, it as...
-
Excel Forumla help (IF formula) Solved/Closed
Hello, I need some help, I just can't figure the IF formula out. On my Excel 2007 spreadsheet, I am trying to figure out if I put the letter grad...
-
formatting with more than 3 colors Solved/Closed
Hello, I need your help guys, i wanted to apply the formatting with more than 3 colors in my worksheet. The worksheet im working on has a lot o...
-
Conditional Formulat with #ous condiitions Solved/Closed
Hello, I have to write a formula to account for 6 conditions from 6 different columns. Originally, I thought it could be done by a simple nested I...
-
Law School Acceptance Chances Solved/Closed
Hello, I want to compare possible GPA and LSAT scores to Minimum Acceptance GPA and LSAT scores. I've tried using IF and AND functions, but I can't s...
-
counting Solved/Closed
Hello, I am trying to count the number of cell's from I4:I304 that have "no access" in it, but in those cells not only do some of them have "no acces...
-
excel macro loop to insert pics into more cel Solved/Closed
Hello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...