Office Software Forum - solved topics
- Excel (9,800)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,186)
- Solved
-
Excel - A macro to rename existing worksheets based on a list Solved/Closed
I have a P.O. spreadsheet with a summary page. Every year we need to create a new file but I would like to create a template that would just renumber ...
-
Inserting image in a particular cell in VBA Solved/Closed
Hello All, I wanna insert an image into the Activecell but the image is getting inserted into the same default area. Kindly help me regarding this...
-
IF statements with dates and criteria Solved/Closed
Hello, I needs assistance with "If "statements and criteria within the statement . Column A has a set of start dates Column B has a set of En...
-
duplicate values in multiple columns Solved/Closed
Hello, I'm looking for a formula for a case mentioned below: Consider we have values in three columns I need to find a formula which compar...
-
Copy data of one sheet to other sheets Solved/Closed
Hello, I want a VBA code or excel formula that automatic copy of data from one sheet to another sheets(either sheet 2 or sheet 3...etc)..suppose In ...
-
Copying & pasting data in next available row in same worksheet. Solved/Closed
Hello, I would really like assistance to write a vba code for a macro (using a drop down list) that copies data from A4:E4 and pastes it down in t...
-
Value from matrix table Solved/Closed
Trying to get rate in G14 that comes from the matrix E14 is a list of A3:A10 F14 is a list of B2:J2
-
two tables values with diffrent order and number of values Solved/Closed
Hello, I have 2 tables of products (diffrent number of products). 1st table contains: all products (name, SKU): NAME | SKU asd.........21398763 ...
-
calculate my Service Expense as % Solved/Closed
Hello, I would appreciate if someone can help me with this problem solving question. I would like to know how to calculate my Service Expense as % ...
-
Error "Range of object Global failed" Solved/Closed
Hello Everyone, Kindly check my code for mistakes. I am getting an error in this part of my code as "range of Object _Global failed". Dim feat...
-
Excel- if this, than return that? Solved/Closed
Background: I work for a Recruiting Group & we have a list of candidates in Excel with all mailing info, including the County they live in. I need to...
-
Trying to concatenate a letter with a date Solved/Closed
Hello, I'm trying to keep a date in a recognisable format and precede it with a character. e.g. I want "D" and 27 July 2015 to appear as D 27 J...
-
Insert Picture in Excel macro, after crop it, save it to a file Solved/Closed
Hello friends, I need to open a macro, after place the name in A1 cell, push a button to insert a picture, base on A1 name, then, after crop it and re...
-
Find words within cell & put text and color in adjacent cell Solved/Closed
Hi there, i'm trying to search for certain word(s) (i.e. "reply??" or "remind") in a cell with a sentence in it, and place a specific text on a diffe...
-
What is the password for Volume Limit on iPod Solved/Closed
On my ipod chatmoatic, I was trying to figure out what the problem was with my volume. So I came to this spot that says "Settings" then, "Volume Limi...
-
Macros: Copy Invoice Details From One Sheet to Another Solved/Closed
Would be very grateful for help with this one I have set up a macro that will print and generate the next reference for my invoices raised in excel, ...
-
how to open my corrupted rtf document Solved/Closed
Hello, Can anyone please investigate me how to open my corrupted rtf document? When I try to open it I am getting: Loading error Any suggestions h...
-
Calculation of positions in excel Solved/Closed
Hello Hello, sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...
-
Excel Macro's copy data from one sheet to another Solved/Closed
Hey Everyone ok, so, I have a document with multiple sheets one of the sheets is a reporting sheet what i am trying to accomplish with not much l...
-
Get a value from Col A based on the max value found in Col B Solved/Closed
Hello, Get a value from Column A based on the max value found in Column B display in Column C. I need to get value Jill in Column C. Name A...
-
Comparing dates in multiple columns and using one that matches Solved/Closed
Hello, I have a table with multiple columns of date values and need to check whether a date in a certain column is less than that date and depende...
-
Macro to insert a number into cell A11 for 180+ excel files? Solved/Closed
I used the macro below to merge a bunch of files but it cut off the last row of data. It looks for the first A cell with nothing in it to end it and t...
-
How to insert symbols of the French language Solved/Closed
How to insert symbols of the French language and keep them in a folder to use easily.Thks a lot. Please advise.
-
Create & name worksheets from a list and copy data Solved/Closed
Hi Guys Really new to this and thanks to previous posts on here I have managed to create code to complete the first part of my jigsaw, just struggl...
-
Can't open my 2007 document Solved/Closed
Hello, i can't open my docx word document.i'm running office 2007 and i'm clickin all my word documents and getting the same response "the file is no...
-
not able to cut or copy attachment file Solved/Closed
Hello, I am not able to cut or copy any attachment file in outlook 2003.In a new message,i attached a file(pdf,xl,doc etc) i want to copy tha...
-
Formula Question: "IF" function with date Solved/Closed
I am attempting to create a formula that will enter "Yes" into cell P1 if: the date in Cell E1 is before 07/31/16 AND the date in cell B1 is after 07/...
-
Highlight cells with Text that match data validation menu Solved/Closed
I see several similar questions on the forum but not quite the same and the answers don't seem to extend to my situation. I have an Excel sheet tha...
-
macro to create new workbook and copy data Solved/Closed
Hello I am looking for macro to copy rows based on partial cell content of a column. I have an excel spreadsheet called "arc.xlsx" from which I wou...
-
MS Publisher dot appears where a space should be Solved/Closed
When typing in MS Publisher a dot appears where a space should be. How do I get rid of the dots?
-
Compare values in two columns and return the value from third Solved/Closed
Hello, I've a table containing four columns. If the values in the first two columns match to particular value (eg. A1="xxxx" and B1="yyy"), I need...
-
Place specfic text in cell based on text in an adjacent cell Solved/Closed
Hello Folks, Per the preface, I have a cell that has validation rules of "Concur, Non-concur". If the user selects "Non-concur" for that cell, I ...
-
Adding points from one sheet to another Solved/Closed
Hello, I'm trying to record points that students accumulate in a club. In a GoogleForm, I check off the students (Estudiantes) that earned x po...
-
trying to create an order sheet Solved/Closed
Hello, I am trying to create an order sheet in Excel. I have an inventory list with various information. One of the cells is where I input how may o...
-
Exporting data Solved/Closed
Hi am so excited to join this forum!!! Pls I need help. I have 14 sheets on a workbook (for 14 of the company's locations in Canada). The data c...
-
Conditional format to highlight cell based on date Solved/Closed
hi guys! I need some help. I'm creating a spreadsheet to show when car MOT expires. I have a column (F) which has MOT expiry dates in. I h...
-
VBA search column for matching string Solved/Closed
I am trying to write a script in VBA for excel. For an entire column of data in sheet 2, for each individual cell in a column, I need to search a c...
-
negative cells Solved/Closed
Hello, Please would someone help me with what I think is a simple problem. I have a range of cells which decrease in value and some become positive n...
-
calculate no of days left from today to a future specified date Solved/Closed
Hello, How to calculate no of days left from today to a future specified date Configuration: Windows 7 / Chrome 52.0.2743.116
-
Compare columns and create list of duplicates Solved/Closed
Hello I am a complete newbie when it comes to VBA code but I tried to set up a macro with examples I found online. Let me explain my needs. I have a ...
-
need help to macro my invoice number Solved/Closed
Hello, I wish to increment my invoice number everytime I open my invoice....format is 1-2015-001 and increment by one 1-2015-002 should be the next...
-
search value error Solved/Closed
HI, The value for false refuses to come up as a blank cell in my formula to find and copy a cell if it contains certain initials, or leave it blank i...
-
Nested If Statement not working Solved/Closed
Hello, I am trying to use nested excel IF(And) formula. here's my logic table If O4=Planned,TRUE, FALSE TRUE =IF(AND(I6>=C7,I6=F7,I6=C7,I6=F7,I...
-
Macro - pictures to excel acc to name Solved/Closed
Hi, I have an issue - I checked all forums I could, but with office 2013 and changed excel functions, I got lost. My excel has pictures names in...
-
Suddenly unable to send emails Solved/Closed
I am able to receive emails just fine. Going to the webmail server on the web I can both send and receive emails. I've tried adjusting settings on my ...
-
Conditional formatting based on two cells (date and comment) Solved/Closed
Hi guys and dolls, I am hoping one of you clever people might be able to help me... I am trying to highlight a cell when 1. a date has passed ...
-
If multiple cells contain value then add value Solved/Closed
Trying to think of the best way to sort this problem! . I have a spreadsheet with a list of customers that have purchased a vehicle. Along side in...
-
odd and even cells Solved/Closed
Hello, I am trying to link cell C1 to cell F6. But if cell C1 is an even number I need it to add 1 to that number ( cell C1) and put it into F6. If ...
-
HELPP!! Simple MACRO help! Solved/Closed
Hello, I would like to create a macro that will scan sheet one for cells that contain the word "Complete", Copy the whole row, and paste it into a...
-
outlook backup Solved/Closed
Hello, how to take outlook backup one machine to another machine Plz reply me Thanks Configuration: Windows Vista / Firefox 47.0
