Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
excel formula Closed
I need to generate a number list of 1-20000. is there any method?
-
Automatically copy data from one sheet to another Closed
I have read numerous articles about this and none have really solved my issue. I decided to post my own specific question. I have an excel workboo...
-
Removing false statement Closed
Hello, I would like to remove a FALSE statement, want it to show nothing. My formula is as follow =IF(A23=1,G23,IF(A23=2,G23,IF(A23=3,G23,IF(A23...
-
Excel formula Solved/Closed
Hello, I am having trouble getting the right formula for: Column O is equal to column N if Column C contains the text "Mastercard." Nothing I'...
-
Formula should be easy Closed
Hello, I am having trouble getting the right formula for: Column O is equal to column N if Column C contains the text Mastercard. Nothing I've t...
-
send email when a cell changed in excel Closed
Hello, hi guys, straight off, im stupid, extremely stupid so if you can help me please keep it simple as im barely technical at all :) anyways, im...
-
calculate to distance between two addresses on google maps excel Closed
Hello Friends, please help me if you can. what im trying to do is, i need to calculate the distance between two addresses on google maps and want t...
-
Recover corrupted PDF files Solved/Closed
Hello, I'm trying to recover a folder with some critical data that was damaged or corrupted, likely by a virus. It’s a 10GB folder that contains P...
-
code for date in words Closed
Hello, i want code for coverting date in to words in c Configuration: Windows 7 / Chrome 51.0.2704.103
-
Creating multiple lists from one master data table Closed
Hello, I am trying to create a master data tab where expenses will get coded. I need each subsequent tab to be for a specific account and that ta...
-
How do I extract specific data from a cell in excel? Closed
Hello, what function would I use to extract just the city name from the cells below?...thanks! 6211 E Holmes Rd ,, ,Memphis, TN 381418310, U.S.A. ...
-
changed pdf to word, now all documents are gibberish Closed
Hello, I changed one of my documents with "Open with" from PDF to word. I has now changed all my word documents to gibberish. How do I get it to ...
-
Conditional Formatting Based on Data in Another Call Closed
I'm a new member and I hope my question is clear. I need to change the background field color of cells in a column based on a value in a different fi...
-
Change color of text or cell if the value entered is same Closed
Hi! Can someone please share me how to change font or cell color if a value entered in a cell is already selected before. Ex. I wanted the font or...
-
ms word 2007 files converted in to ms word 2003 Closed
Plz help me. M research scholar I have created my file in ms word 2007 but after few hours I have opened then I have seen my all files have converted ...
-
comparing the two names respective of Upper & Lowercases letters Solved/Closed
Hello, here am trying to know something about the compare of 2 names in excel below is my format Http:CCM_net_C2E http:cCM_Net_c2E i have ...
-
macro for inserting multiple rows between data Closed
Hello, I need a macro that will insert 45 new blank rows between each existing row that I have now. can someone help me with this? Also, I have li...
-
Count if it is monday? Closed
Hey all; I could not manage to work this out after 1 day research and try my chance here. I have dates on column A and numbers (both positive,negat...
-
Copy data from one sheet to another based on condition using VBA Closed
The data looks like this A B C D 1 3.45 ...
-
Macro to Merge Data Based on Condition Closed
Hello Dear, I have multiple sheets with different columns, the headers are mentioned in row 3 and there are few headers which are common across al...
-
Transferring data by row onto new tab Unpaid and Paid Sales Closed
Hi I am new to this forum. I have an excel spreadsheet which looks like this: Date Description Invoice Destination Amount Status ...
-
format copy upon condition Closed
Hello, I have a workbook with two worksheets, one with a legend using 2 columns. Column a for name b for colors. On The first worksheet i am ...
-
add the value of one cell only if another cell has a certain # Closed
Hi everyone. I'm trying to make a spreadsheet to categorize business expenses into IRS categories. For example Column C has the cost for each ex...
-
Using if statement to add 1 to total Closed
Hello, I am trying to get a formula to add + 1 to a total cell based on the word typed. Example : If I type the word Duty in cells B3:B18 then ad...
-
Totaling amount from 1st tab depending on another column states Closed
Hello, I have 2 worksheet, 1st worksheet shows 2 columns A1 ($0.00) and A2 (names). 2nd worksheet I want it to calculate if the name column A2 sta...
-
How to populate data to another tab Closed
Hey there, If anyone could please spare a moment to help me with this, it would be much appreciated, more than you will know ! What I want to d...
-
comparing 2 columns from 2 different spreadsheets Solved/Closed
Hello, Here is what i am trying to do. Spreadsheet 1 column B has customer numbers Spreadsheet 2 column A also has customer numbers Spreadsheet 2...
-
excel question Closed
Hello, i want to calculate distinction,first,second and third divisions Configuration: Windows 7 / Firefox 13.0
-
Copy 10 sheets (along with data) into new 10 sheet in Same excel Closed
Hello, I have an Excel which contains 10 Sheets with data.., Once a Go button is Clicked it new 10 sheets should be opened in same Workbook along ...
-
set a conditional year end date outcomes Closed
Hello, I am trying to set a conditional year end date outcomes. 1. If cell "A1" shows 10/31/2016, then I want cell "B1" to show year end 12/31/201...
-
How to use random animation effects in PPT Closed
Hi,I just want to know how to use different effects of the Animation in Power Point Presentation in slides.I just want to Know how can we make effecti...
-
Macro code Closed
Hi there. So I have a question. I want to create a macro that makes uses the list of name in cells B6:B60, E6:E60, B66:B119, and F6:F74 to make a tab ...
-
compare two columns input value from another Solved/Closed
Hello, Here is what I am trying to do, can some one please help me. In my Excel Workbook I have 2 spreadsheets. The first spreadsheet we will ca...
-
Macros - How to populate data to another tab Closed
Hey there, What I want to do is this: I have data on sheet 1, which is separated into columns, Headings are: Property Code, Customer, Document, ...
-
If Then for date outcomes Closed
Hello, I am trying to set a conditional year end date outcomes. 1. If cell "A1" shows 10/31/2016, then I want cell "B1" to show year end 12/31...
-
Macro for automatic paste in sequence Closed
Hello, I have a calculation sheet for experiment results with time. Everytime I am manually copy paste results from result raw to another raw i...
-
Automate copying data from one sheet to another Closed
Hello, Could you help me with the below issue please? I have 2 different sheets in 2 different locations (say one is the Master sheet). I need ...
-
Highlight cell if another cell contains any text Solved/Closed
Hello, I have been searching and found several discussions similar to this. However none have them were exactly the same and I haven't found my an...
-
Senior accountant A/R Closed
Hello, i cannot transfer data more than 54 column to another sheet(can not write more than 54 cell same row in the code) Configuration: Windows...
-
Microsoft outlook Microsoft exchange is unavailable Closed
Hello, I could not open Microsoft outlook at all, the error message a following: The connection to Microsoft exchange is unavailable. Outlook mu...
-
So close! Script creates worksheet and populates BUT Closed
Over the last 10 hours I have researched and pondered and really enjoyed the process of building up this program, but my shift is almost over and I wo...
-
Macro that Creates New Worksheets based on Data from a List Closed
I've been researching and attempting to create a macro for the past few hours. I have a workbook with 2 worksheets. 1st worksheet contains a table tha...
-
Help! My MS Word Icon has changed Closed
Hi. I hope you can help me. About a week ago my Word doc icons suddenly changed on documents that I created or edited. Once edited or created, they ...
-
Copy and paste macro button based on a condition Closed
Hello, I am very new using VBA. I have daily time I am entering for employees in a worksheet. It is summarized in a table at the bottom of the wor...
-
Excel help please Closed
Ok here's what I want to accomplish. I want to be able to type the name of a medication: and the formulations automatically appear in the rows foll...
-
auto row copy to another worksheet Closed
I'm new to excel and need to set up a simple double entry bookkeeping system in excel. I need to know what formula to put into a cell to accomplish t...
-
Assign numerical value to cell based on text in another cell Closed
Hello, I'm trying to solve an issue... Column A cells have a drop down which has 4 text options to choose from: Tier 1 Tier 2 Tier 3 Tier 4 ...
-
Copy and paste macro button based on a condition Closed
I have daily time I am entering for employees in a worksheet. It is summarized in a table at the bottom of the worksheet. When today's data is entered...
-
Tracking changes on a work book Closed
Hello, just to inform, i don't know how to create a macro or visual basic program. I have an excel sheet that contains 500 line items. each ite...
-
Runtime Error 6 - Overflow error with a variant type variable Closed
Dear All, Kindly help me with the below coding where i get Runtime Error 6 - Overflow error when executed. Private Sub Workbook_Open() Dim ws A...
