Office Software Forum
- Excel (9,843)
- Open Office (114)
- Outlook (647)
- PDF (334)
- PowerPoint (184)
- Word (2,189)
-
EXCEL 2007 Closed
Hello, I have two excel 2007 files. Both files have same columns but different dates. What I need to do is to compare the data in both files...
-
Looking for a specific word Closed
Hello, I really need some help trying to look for a specific word amongst the comments that were data dumped into an excel report For example: ...
-
Excell Question Closed
Hello, what excel formula should i use for the date to be automatically input on a cell when typing a dollar amount on another cell.
-
If then statement Closed
Hello, I am trying to print the contents of range a1:h1 if I1"". So far I've got, IF(I1"",A1:H1) but I only get the results of A1, not B1:...
-
sanctions list checking Closed
Hello, I am trying to work out a preocess for sanctions list checking against new clients to the business. I have used concactenate to merge t...
-
Create a custom search button and list all Closed
Hello, I need a project to be done for my workplace. Please see below specifics on how it should work below. somebody clicks the button - it'll...
-
Vba excel problem Closed
Hello, Does anyone know the vba to do the following: On command button select - cell A3 = (1st of next month) - cell A4 = (14th of the month...
-
How to use text value in cell as criteria Solved/Closed
hello, In cell D1, I'm using a SUMIF formula like so =sum if (A:A; criteria; B:B). In Column A and B is a list of charges different companie...
-
coloring the last 3 dates in a range of date Solved/Closed
Hello, In my last post, i mentioned about coloring the last 3 dates in a range of date in blue, and the rest in yellow. I used this code as to do t...
-
VB code to copy names into a work schedule Closed
Hello, I have a list of employees in a column on one sheet and want to copy each name, one at a time, into their work schedule which uses a vlooku...
-
excel help Closed
Hello, How do i duplicate rows in excel based on a condition. e.g. name count aa 3 bb 1 i wish to ...
-
Compare 2 data sets in excel Closed
Hello everybody, this is the scenario: I have 2 spectrometers that aquire data. I need to compare the aquired data and in order to do so I wand to...
-
Insert a constant value after every row in XL Closed
Hello, I would like have a macro which inserts a constant value after every existing rows in xl. E.g I have rows in column A,macro should re...
-
spend profile Closed
Hello, I am trying to spread a value over a date range (spend profile). Esentially Col A = Start Date of an Activity Col B = End Date of an...
-
How to sort one column by another Closed
Hello, I am trying to sort one column by another and place the result in a separate column example below. I want the force to be sorted in the corre...
-
Excel Macro: copy paste certain columns to... Closed
Hello everyone, I am very new to Excel VBA and could use some help with a macro design!! :) I already looked a bit around but could not find the...
-
problem in excel userform Closed
Hello, My english is not good so sorry in advance i have some problem in excel userform please give me solution. check this link https://a...
-
Change Row Color With Conditional Formatting Closed
Hello, Nees some help. I'm trying to change a row color using conditional formatting based on a value in a given cell. Meaning, if in column D if th...
-
comparing two different excel sheets Closed
Hi I need ahelp in comparing two sheets of excel. First sheet columns containing two additional columns when compare to Second sheet(other column n...
-
missing older emails in Outlook 2007 Closed
Hello, Configuration: Windows Vista / Firefox 3.6.8 I have tried for so long to fix this problem, but all I'm getting is dead ends and peop...
-
Conditional Formatting in relation to date Closed
Hello, I'm setting up a Warrenty management system and want to colour code parts that are still covered by the warrenty and parts that the warrent...
-
memory card password Solved/Closed
Hello, i forgot my memory card password, i format it twice now i am battling for getting password. Configuration: Windows 7 / Safari 533.4
-
What is the password Closed
Hello, It's really a nice piece, together 3 sim at one. Pls tell me the default Factory password for setting the password. What should I e...
-
display the last cell used in another cell Solved/Closed
Hello, In a range of cells A1: A20 i want to show the data in the last cell used in cell A25. So it would look something loke tis 1 2 2 5 ...
-
password with no disk and internet connection Closed
Hello, My name is Paulette and I hired the dumbest nanny in the damn world. She logged on to my computer which had no password and changed it without ...
-
Incoming and outgoing mail server for Closed
Hello, MAIL.COM Configuration: Windows XP / Firefox 3.6.7 FOR: mail.com
-
yahoo msnger paasword Closed
Hello, i wnt to my yahoo msnger password my email id is chandsony@ymail.com so plz send me this password to my chandsony9295@gmail...
-
Find row after look up matching strings from Solved/Closed
Hello Experts, I am looking for a way to find strings from in and put a flag (XXX) next cells. Your help is greatly appreciated. Monkey ha...
-
COMPRESS PDF FILE Closed
Hello, i have documents which i scanned through my printer. They are in PDF format. I have only Adobe reader 9 reader. I need to compress my files ...
-
Compare two Columns and return a value Closed
Hello, I have these columns now the problem is how can I make a formula or macro to search from column its counterpart value on column b and retur...
-
vba help Closed
Hello, i am working in workbook A.I want to extract data from a particular sheet in workbook B say the name of the sheet is 'xyz'.please help me w...
-
change weekend days Closed
Hello, how to change the weekend in excel 2007 from sat and sun to friday? Configuration: Windows XP / Internet Explorer 8.0
-
Password change Closed
Hello, Sir any body change my gmail password and also i forget my secrate answer how i found my password Configuration: Windows XP / Internet...
-
Deleting and keeping rows in same Macro Closed
Hi, I'm working on a Macro to keep rows if it meets two conditions, see below. Then I want the macro to look at all the rows again and delete the o...
-
Headings to be displayed in every page Closed
Hello, I have my data in excel for which i want the headings to be displayed in every page ex: Invoice date Invoice Amount Cust Name Sin...
-
Unlock Cmos Password Dell Inspiron 1440 Solved/Closed
Hello, Plz, I need help how to unlock cmos password service tag: JL5XKJ1-595B thank you>
-
Count visible&non visible rows on filter Closed
Hello, I want to count all the visible and non visible rows even when data is filtered. Currently using SUMPRODUCT(($E$2:$E$15="Incident")*SUBTOTAL...
-
freebrowsing Closed
Hello,hw can i download freedom software and its configuration
-
i dont know the password..help me plss.. Closed
after i restore factory setting on my phone (5130 xpress music),the memory card need a password to open it.. i dont know the password..somebody plss ...
-
How to speed up my code Solved/Closed
Hello, Let me start by posting my workbook: https://authentification.site/files/23489429/Copy_of_PostPlanning.xls When you go to sheet "Alle o...
-
hepl Closed
Hello, can u please help me to convert the numbers to words in OPEN OFFICE. . . it will be highlly appreciated. . . regards RAJESH
-
Excel help Solved/Closed
Hello, I have an excel worksheet with cells filled with strings of text like this... CAS [354-24-5], 99% I'd like to search a vertical c...
-
HP 1300 Paper Jam Closed
I'm stumpped on this paper jam. As first page leaves fuser it jams and second page is stuck as it enters fuser. I've replaced pick up roller and sepa...
-
To check variance for each other codes Closed
Hello Sir, In "Data" tab contains data that has to be analysed. Normally each "Code" should have opposite code ("in booked in " field) in each l...
-
More than 3 conditional formats in Excel Solved/Closed
Hello, I am working with an Excel spreadsheet, and need the cell background in one column to change to red if its value is within a range of numbers...
-
i want to read word , exel and pdf in 5800 Closed
Hello, i want to read word , exel and pdf in 5800 mobile , which program to use
-
Integrating Excel and MS Outlook Closed
I am working on a project in which we have a "Graphics Design Work Order Request" which contains like specific tasks for specific members of the desi...
-
Moving data from columns into rows Closed
Hello, I have data that is in two rows in excel such as this: 3/1/09 Joe Sick John Black hotdog 47 y/o ID # 123-09-638...
-
Fill cells based on the value of other cell Closed
Hi, Please can you help providing macro for the below query.. If I enter a value in a cell say for example I have entered '2' in B4, i want 2 c...
-
If Cell is one of multiple values this cell = Closed
Hello, I have an issue with a spreadsheet where I am trying to convert lists of postcodes into a set building e.g. if your postcode is 123 ABC the...