Excel Forum
-
How to compare data between two excel files [Closed]
Hello, I want to know the easiest way to compare data between two different Excel files.Both the files are same in structure but data can be diffe...
-
VBA: Creating new Sheets based on copy, Nameing them the Cells [Closed]
Ok, i am gonna try to be so clear i can. on Sheet 1 (Start Sida) i have a list from cells A9 to A500 with names. atm only A9-A52 have names in them. ...
-
Average a range of data with leaving out one value each time [Closed]
Hello, I'm trying to write a macro to calculate the onset time of LRP. I need to average 30 columns with leaving out one column each time. For exa...
-
How to copy values in sheet 1 to sheet2 based on column name [Closed]
Hi, please help with the query here. I have set of data in sheet 1 and sheet 2. Sheet 2 is the source data. Sheet 1 contains the data after it's confi...
-
Need the number of rows with exact criteria from 2 columns [Closed]
Hello, I'm trying to create a formula that tells me how many rows fit the specific criteria. I have my data on my first tab. The first crucial infor...
-
how can I multiply a numeric value and alphabetic value in exce? [Closed]
Hello,plz answer as soon as possible
-
Difficult Query [Closed]
Hello, I would like to request for a difficult query that may be not solvable logically. If user enter az123456789 or az-123456789 it always co...
-
autofill a column according to values in another column [Closed]
Hello, I need to autofill a column according to certain data in another column It goes like this Column B contains various data including a ...
-
Automatically transfer data from one worksheet to various others [Closed]
Hi, I am trying to figure out how to automatically transfer data from one excel worksheet to another worksheet but only when a specific cell(s) ar...
-
Automatically transfering data after generating new worksheets [Closed]
Hello, It has been a while since I have worked with code and would appreciate any help. I have one code already working which is gathering all ...
-
How to automatically create workbook [Closed]
Hi, I have a table (contain a list of problem in production line) in a workbook. I want that, whenever I add a line in the table to register a probl...
-
Search and copy.. [Closed]
I have two Work Books open and I have filters on both WBs.. Let's say I have filters for Name, Birth Date, Address, and Phone# for both WBs. Is it pos...
-
Macro to rename tabs based on cell reference on another sheet [Closed]
Hello, I am attempting to rename 5 sheets in a workbook based on values from a sheet titled Raw Data Information. The first sheet should be named bas...
-
countdown in excel [Closed]
Hi, I'm a bit of a formula novice in excel. I have been googling, but not sure if I'm typing in the right questions, or if what I want to do is eve...
-
Macro to rename sheets based on cell value in another sheet [Solved/Closed]
I am attempting to rename 5 sheets in a workbook based on values from a sheet titled Raw Data Information. The first sheet should be named based on '...
-
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...
-
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...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- Facebook Code Not Received
- How to Create a Gmail Account
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video
- How to Recover a Disabled Facebook Account
- How to Install a VPN
- How to Get Free Diamonds in Free Fire
- How to Recover Your Yahoo Account
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram