Office Software Forum
- Excel (9,851)
- Open Office (117)
- Outlook (652)
- PDF (334)
- PowerPoint (185)
- Word (2,189)
-
Embedding images in looped sub for different worksheets Closed
Hi there, I've been using a macro at work that inserts images into one column, based on the values of cells in another column. This has served me ...
-
I need to copy a cell from sheet 1 to sheet 2 if a refrence happ Closed
Hello, I want to know how to make a formula for below example if G2 at sheet 1 equal yes copy F2 at sheet 1 to A2 at sheet 2 and if G2 at sheet ...
-
Macros Query - Run a formula that changes by current work week Closed
Hello, I am fairly new to Macros and I'm basically trying to run a formula that will change each week by work week. The formula I want to use i...
-
improving a macro Closed
Hello, If someone out there can help me with a macro, I would greatly appreciate it and you will be in my debt until the cows come home. The ma...
-
How to Combine 2 Formulas in one box? Closed
Hello, I would gladly appreciate any advice on how to finish or redo my formula. I have most of my formula but I can not figure out how to do the la...
-
Creating a timeline with Excel Closed
Hello, another newbie here. I'm trying to create a single Excel data worksheet that is used to calculate timelines and due dates on additional work...
-
Corrupted files/ won't open with Windows 10 Closed
Hello, I am unable to open some excel files since going over to Windows 10. I have tried some of the suggestions found on the internet but no solut...
-
automatically copy the row into the appropriate sheet Closed
Hi everyone. I've set up an excel 2010 workbook to log maintenance repairs through the hotel. sheet 1 is an ongoing log of 5 columns. A= location ...
-
Do I combine 2 Formulas? Closed
Hello, I have most of my formula but I can not figure out how to do the last part. here is what I need (60-A1)*0.00055 so I have that set up under ...
-
how to set no of copies to 5 in print preview Closed
Hello, I would like to request that how to set no of copies to 5 in print preview through macro with showing print dialog of MS-Office 2013 Tha...
-
Macro to copy and paste rows until blank comes Closed
Hello, Can anyone help me to write macro code for the below condition. I have data sheet which updates on a daily basis and no. Of rows with r...
-
Excel Filter/Macro Solved/Closed
Hello, Thank you in advance for any time/help you can offer! I'm working on a contact list in Excel and I need to be able to filter my contacts i...
-
Run-time error with copy-and-insert rows macro Closed
Hi, I am using the following macro to copy and insert rows in an Excel spreadsheet, based on a user inputted value. I place the cursor in the desire...
-
How to automate copying cells from one workbook to another. Closed
I need a VBA, macro or some way to be able to load cells from one workbook to another. The first workbook has the cells I need on one row, I need to c...
-
can't open Microsoft office Closed
Hello, i just install the business in box app to see an example of a document. but then there's something wrong with the Microsoft office. i fou...
-
Colours for dates that are on 2 & 3 month cycles Closed
Hello, In my current role, I have a number of people that I have to assess. I would like to be able to do the below so i can easily identify who i...
-
Columns & Rows Help Solved/Closed
Hello all, In short, here is what I need help doing: I would like to take 15 items in one column and transfer them into a row in another spread...
-
Formula for if cell contains word, assign value for multiple Closed
Hello, I am looking for a formula to help me assign a value for multiple words and values. If column A has the contains Apple, assign X. IF i...
-
Highlight Dates for 3 or 2 month cycles Closed
Hi, I manage a number of staff and have to assess them. I want to be able to do the below so i can easily identify who is close to the time limit. ...
-
Excel Filter Question Closed
Hello, I'm working on a contact list in Excel and I need to be able to filter my contacts in a few different ways. Each contact is in a row and ea...
-
Excel conditional formatting Closed
Hi All, I need your help with conditional formatting please? I've a project timeline on a week and month calendar form. I've applied conditiona...
-
forget password of Excel file Closed
Hi, All friends I have forget password for my excel files to open, can any one help me to open this file. I have attached picture of problem. ...
-
get last used column address using current region property Closed
Greetings, I have attached an image a look like of my input file. In this, I need to get the address of the highlighted portion. I have used 1 as t...
-
25% of a cell if text in another? Closed
Hello, I was wondering if someone could help me with the formula for 25% of a cell if another cell has text in it to give me the sum total of a ra...
-
Excel data transfer between separate spread sheets Closed
Hi guys, I have a table in the spreadsheet that I want to transfer data from to another spreadsheet. The thing is that even though not every field ...
-
Need to search an excel spreadsheet column Closed
but hoping I'm wrong? Need to search an excel spreadsheet column (say column D) for all rows with the text "3 Pounds" If the text is found in a cel...
-
conditional formatting Closed
Hello, I need a help from you . Am trying to give three color condition in a pivot table and slicers report. We have sheet with Pivot table ...
-
Bringing similar names of different spelling together Closed
Hello, I have 2 similar files. each has several columns of information. each row for one person. 80-90 % of the rows in 2 files are the same person...
-
formula if you have credit in one column, debit in next column Solved/Closed
Hello, what is the formula if you have credit in one column, debit in next column and balance in 3rd column. Many thanks R Horner Configurat...
-
Macros Invoicing drop down list Closed
Hello, Hope everyone it doing well. I am looking for some help with Excel 2010. I have a template that I use to invoice my customers. My customer ...
-
Excel right and left arrows not working properly Closed
Hello, I spilled Coke on my laptop this afternoon and while frantically trying to remove it I pressed something that has inserted some kind of pr...
-
how excel displays ascending order of data in other spreadsheet Closed
hello, I try to prepare data of students details with random serial no.s in one excel spreadsheet. How I link it to display ascending order i.e.sma...
-
Data subsets and duplicates Closed
Hello, I have been trying to find the answer in a few forums but haven't found quite what I'm looking for. I have a column (A) of around 2000 n...
-
need a cell to change colour if another cell has an 'x Closed
hello, i need a cell to change colour if another cell has an 'x' in it. so if cell r14 has an x in it cell r13 turns green can anyone help? tha...
-
Excel conditional formatting w/date range and containing text Closed
Hello, I need to make a conditional format based on the date in a cell being between 30-60 days past today's date and only if another cell contain...
-
how to link my mail iD Closed
Dear Sir/Maám actually our company is secured our intra so please give istruction how to open my mail id thanks,
-
Date format not changing! Closed
I exported some data from a CRM system and the date exported like: Dec 9 2015, 3:00 PM I need to change this to: 12/9/2015 I've tried chan...
-
Excel date formula won't change Closed
Hello, I exported some data from a CRM system and the date exported like: Dec 9 2015, 3:00 PM I need to change this to: 12/9/2015 I've tried...
-
conditional Formatting cell in a column vs a cell in other col. Closed
Hello, I am comparing two cells in two different columns. I will do this for the 124 rows. if column G cell let's say G7 is larger than B7 then G...
-
Help with Sumif function please.. Closed
Could someone please help me?? I need to sum the values of a range of cells that contain certain text (product codes) into another cell. For example...
-
if condition Closed
if a2=mathura then result plm a2=agra and b2
-
How to re/name a cell if another cell contains X Solved/Closed
Hello, Apologies if this is a simple question but having some trouble figuring it out. I have say 1000 rows of data and I need to label them all...
-
Screen is locked - its not scroll lock Closed
Hello, My screen wont move up or down, neither from cell to cell. Its not the scroll lock function. Anybody know what function I activated by mi...
-
Data arrangement Closed
Hello, I have 2 sheets in an Excel workbook. I am trying to code certain cells in a pre-made template on Sheet 1 to automatically sync with my dat...
-
Define a default path for macro enabled template file (saving) Closed
Greetings, I have created a macro enabled template file named test.xltm. Double click on the file opens a file named test1. on choosing save as res...
-
fill in automatically Closed
Hello, I have two colum in excel sheet colum A1 contain big list of job titles each one of it have a code for example: Job Title name ...
-
Daimary Closed
Please accept me.
-
Macro Help Closed
Hello All, In short, this is the issue I am facing: I have created a macro to copy and paste data from one spreadsheet to another. Specifically,...
-
copy data from 2 sheets in 1 workbook to new workbook Closed
Hello, I am new to macros in Excel and could use any help. I want to copy the basic name and customer info from 1 sheet(1) and create a new workb...
-
Can I get the Autofilter to work automatically without Closed
I have the following which is filter my data based on a cell: Private Sub Worksheet_selectionchange(ByVal Target As Range) If (Intersect(Target...