Office Software Forum
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Conditional Formatting based on other cells Closed
I'm relatively new to Excel and I was wondering how exactly to do the following: A1=BALL A2=CAT How do I make it so that when B1=A1, then B1 is...
-
Formulas Closed
I'm trying to calculate my wages by entering the hrs worked each day, after 8hrs it is T.5 and DT after 10hrs. If I end up with a total of 3.2 or .2 ...
-
Copy certain cells from multiple sheets Closed
Hi, I have lots of sheets that I need to copy specific cells and copy them to a summary sheet. I currently have this macro: Private Sub Command...
-
Find Partial Text Match between Two Columns of data Closed
Hi Everyone, I am relatively new to Excel. I am in the process of comparing two columns of data to determine whether the data in each column relate...
-
Copy multiple rows from multiple sheets if certain cell is x Closed
Hello, I have a purchase order document in excel that can have from 30 sheets to 500. In cell B14 on each sheet there is a code, if it is equal t...
-
Macro to copy paste columns of excel data to a new workbook Closed
Hello, Consider the attached image. I have data like this for about 15 columns. I want to copy paste each column for 2 to 3 times in a different o...
-
Saving mails to a removable drive Closed
Hello, I would like to know how I am able to save all the emails in my microsoft outlook to a removable drive. I tried exporting but it tells me tha...
-
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, ...
-
Auto Populate and Edit Spread Sheets Closed
If Intersect(Target, Columns("H:H")) Is Nothing Then Exit Sub Range(Range("E" & Target.Row), Range("R" & Target.Row)).Copy _ Sheets(Target.Value).Ra...
-
Copy a row of data from one sheet to another Closed
Hello, Trying to copy a row of data from a roster on a sheet into a new sheet when a cell states Line 1 ie When i type Line 1 etc i want excel to...
-
dates come in 2 different formats Closed
Hello, I have a csv file which imported to excel gives me dates in 2 different formats. I need to have one single format so that we can analys...
-
changed psd file to pdf in error. how to change it back to psd? Closed
Hello, I saved psd file with no extension, and then changed it to pdf by mistake. Now, when I try to change it to psd in a browser, it still keeps i...
-
Multiple sending of messages Closed
Outlook 2010 repeats sending messages with attachments greater than 1 or 2 megabytes until stopped but Outlook tells me that the message has failed.
-
Conditional Format Cells Based on Another Cell and Own Cell Closed
Hi, I'm trying to conditional format cells based on text in another cell and it's own cell. In Column A, the cells would contain either "hit" ...
-
Different Calculation Based on Cell Text Closed
Hello, I am self-employed and currently doing my taxes. I'm trying to set up my spreadsheet to make it as efficient as possible and am wondering if...
-
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...
-
Help needed with VBA code Closed
Hello, I have a unique situation here. I have got a sheet of data and in column F, there are duplicates values containing letter & Numbers like "O...
-
Populate Master Sheet from another sheet Closed
Hello, I want to create a simple entry sheet/report master sheet where records would would be typed into a single row (entry sheet) and the data w...
-
Add incrementing number to multple items in transaction (VBA) Closed
Hello, I am a new member and relearning Excel (2013). In this, I am also trying to get my head around VBA. I have VBA code that processes 'split'...
-
sending problem. Closed
hi, please help for this issue, i am geting all my email in inbox which i have sent. ***@*** Reply all| Today, 8:35 AM ***@*** To send th...
-
Macro to split the workbook in different worksheets Closed
Need a macro for Excel that will copy rows from my spreadsheet into a new one if it meets certain criteria. In the example below, I want to copy a...
-
how to insert any word in a cell after a word Closed
Hello, i wanted to insert a word for e.g "and" in a cell which after a word. Can someone help me with it Configuration: Windows 7 / Chrome 50.0...
-
EXCEL Formula Functions 2 (?) Closed
I am intriuged by the conditonal and the if functions. Does this mean I can record data that has a higher probability factor than an actual approxima...
-
Excel Revision (?) Closed
Hello, There is a prompt that states where a member is to record where two lines are accurate, yet I don't understand how or why one would need to e...
-
Copy Paste Data from one Worksheet to Another using macros Closed
Hello, I'm trying to have a macros run to copy paste from one workbook to another, however, I need the macros to recognize the last empty row to p...
-
How to copy names from one sheet to another with just a click Closed
Hello! I am tasked with creating an employee assignment spreadsheet. I cant seem to figure out how to easily formulate clicking names (around 10) ...
-
Summary Workbook Closed
Hi, I have the following requirement in a workbook and I was wondering if anyone could help me? (I am pretty much an Excel rookie) I have a summar...
-
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...
-
Data Validation refers to Sheet Name Closed
Hello, I would like to request for solving my problem My workbook contains many sheets, some ends with the "-E" (Hyphen Symbol and Alphabet E) S...
-
insert filename.csv into the *.csv file Closed
Hi Trowa I'm having 3000 files in *.csv format. I want to insert filename.csv into the *.csv file of 'A' column. Is it possible? I'm unable to fin...
-
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...
-
Seeking Help with a Formula Closed
Hello, First, thanks for taking the time to read this. I'm not great at this and not sure this will even work. Ok, here goes; In a certain cell I i...
-
Need Help with Formula Closed
Hello, I'm not great at this and not sure this will even work. Ok, here goes; In a certain cell I input manually a productivity number daily. On c...
-
Copying an adjacent cell text from another sheet, if cell exist Closed
Hello, I have 2 excel sheets with lists (+5000 rows) of unique parameter names (text) on each row starting from A2. Sheet 1 has only the param...
-
formula for copying figures onto another sheet when value is >0 Closed
Hello, I would like to create a formula that will only show figures from another sheet that are greater than 0. This is for an invoice template. T...
-
Excel Macro Closed
Hello, I am trying to create a macro that will insert 2 blank rows into an existing spreadsheet after each category. I want the second blank row t...
-
Numeric into word Closed
Hello, i am type the numeric for exp 123 how convert into words for exm one hundred twenty three in excel 2007
-
COMPLICATED EXCEL FORMULA Closed
Hello Friends, Can any one help me to sove my problem. I have two excel sheets . i want to comapre column A and B with other sheet and if both cell...
-
Macro Copy & Paste same Cells Down Closed
Hi all, First off, I'm new to macros so just a warning. I am currently working on a simulation, and trying to create a macro that will record th...
-
Copy from one sheet to another based on value Closed
Hello, I am a newby to excel macros but here goes. I have a sheet where raw data is being entered in rows called DATA (How original) :-) I have...
-
Compare two Excel Sheets which have Duplicate Values (Advanced) Closed
Hello, I'm trying to compare two excel sheets which have duplicate values in the matching column. In both sheets the number of row count is dif...
-
Fetching of data from number of other sheets to a master sheet Closed
Hello, respected consultant, I have created a Excel Sheet for student class attendance. in it i have made a provision for over all attendance of ...
-
Combine two PDFs in shuffle (riffle) Closed
Hello, I would like to know if there is anyway to combine two PDF documents but in a card shuffle mode? For example I have one PDF with three page...
-
Cut-Paste from 1 Workbook to another-based on cell - del columns Closed
I have a master workbook and a template workbook. Master workbook has 6 col - Vendor / Rep / ST / Code / Amount / Name. Template has 5 col - Vendor ...
-
Moving Entire row from one sheet to another Closed
Hey, I have a list of job orders listed in excel. One job takes one row. One of the columns reads heading as "Job status", the value under job status...
-
Urgent Copy Vertical data from One sheet to another horizontally Closed
Hello, I am trying to copy cell data from one sheet to another, the data in source sheet is vertical and i have to copy horizontally in destination...
-
Pictures pasting over each other....Help Closed
Credits to TrowaD in this Forum I was able to use his VBA Code for what I wanted but it just need a touch more to make it complete....The code below p...
-
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...
-
From iPhone to excel Closed
I need a button in excel where I could import I photo I am taking into an assigned cell. I will need to do this multiple times in a spreadsheet. Is t...
-
Check Options in Excel Closed
Hello, I would like to request that Questionnaire is design in which (ranges from A5 to E1000) Column B Contain Excellent Column C Contain Good...
