Excel Forum
-
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...
-
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...
-
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...
-
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=...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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....
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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 ...
-
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....
-
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...
-
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...
-
How to transpose and move data [Closed]
Hello, Have a data set which is 2 columns and 596 rows, in which I need to transpose parts of the data set, remove empty columns, and then...
-
conditional data display depending on a dropdown list [Closed]
Hello, I would like to creat a form which would display certain data dependent on what was chosen in a dropdown list. For example, if my...
-
Create new workbook copying data from 2 sheets in same workbook [Closed]
I want to copy the basic name and customer info from 1 sheet and create a new workbook with that customer's name as part of the file (and copy...
-
IF Formula Query [Closed]
Hi there, I have a spreadsheet which using the IF formula should be bringing back either "update Required" or "N/A" depending on if the date in...
-
Data consolidation [Closed]
Dears Need your expertise advice. I have an excel data in below format , need a formula Column 1 has text like ABA, ABA , ABB, ABC, ABC,...
-
How to create a macro to update a file based on a masterfile [Closed]
Hi I would like to create a macro (program) which will update a file by clicking on a button, based on a masterfile. Basically I have a list...
-
Transferring data [Closed]
Hi, I use excel 2007 version. I have some data in an excel sheet - students' names, ids, test items attempted, multiple attempts made by...