Excel Forum
-
Help required to apply IF formula Closed
Hello, I need a favor to add multiple if formulas for below conditions Column A Column B Column C Result Transactions ...
-
Need Help Creating a Formula for EXCEL Closed
I'm not too familiar with excel, i'm trying to start a small home business and i'm creating invoices using excel. I need help with a formula that woul...
-
Colour excel cell based on Regional Post Code Closed
I want the cell colour to change based on the Regional Post Code I have used in segmenting the UK. It's my own project.
-
Formula Help Closed
Hi Friends- I am trying to generate a formula to help simplify a project I am working on. Here is what I am trying to come up with: I have a col...
-
Need help with script or formula Solved/Closed
Column A shows "Date" while column B shows "Passenger #" I want to Copy and paste the Passenger # to Column C "Total Passenger" The problem is I o...
-
Loop A1 value based on columns with value Closed
Hi guys, hoping you can help me achieve what I want to display in MS excel 2013. What I have is this What I want to achieve is this Pleas...
-
Matching cells but exclude blanks Solved/Closed
Hello, I am trying an "IF" formula to see if A1 matches B1 and if so I want to return C1 but if the two cell are blank its working I want to exclud...
-
Need macro coding for find, copy, and paste Closed
Hi Friends, I need a macro coding for the below example. In sheet 1 I have extracted webpage results like profile page it includes (Quality s...
-
VBA Code for adding sheet from range specified in another sheet Closed
Hi Everyone, I am not well versed with VBA. I m looking a code if any one can help. I have a fixed template in sheet"4" which contains the name o...
-
Macro for specific worksheets Closed
Hi, I would like to hide and unhide specific rows by one toggle button in multiple worksheets. Could someone help me with specifiyng the macro? I ...
-
Macro to compare cells in a table and populate max value Closed
Hi all! Hope you can help me out, :-D I have a Table in Excel (nicely named Table1) and it's full of data which cannot be sorted or columns in ...
-
How to remove links at once from all excel files in a folder Closed
Hi friends, I have a folder having number of excel files say like 100 files and each having copy links from other files. Can I able to remove link...
-
Rounding up time Solved/Closed
Hi, Im having a problem on rounding up time, I've use =mround(A1,"1:00") it works fine on dates and time like this "5/2/2017 7:01 AM" but whe...
-
Match and Paste Closed
Hello, I have two spreadsheets that have two columns that are similar and a third column that is only correct on the 2nd worksheet. Example ...
-
Automatically transfer data Closed
Hello, I am facing problem to make an excel sheet in which i want entry in a cell of sheet 1st automatically should be transferred into 2nd sheet ...
-
Adding formulas Closed
Hi guys need help with some formulas I am currently trying to combine. the Rules is 1. If there is a "Form submitted" in the day I have to copy wh...
-
Automatically copying columns from one work book to another. Closed
Please I need assistance with a problem I've struggled with for quite awhile. If I could write code I'm sure it would be quiete easy. My issue is: I...
-
Graphing student data Closed
As a tech teacher, I run typing reports on my students each day/week. Each report is saved as a worksheet in a quarter workbook. The list of student ...
-
VBA compile Error: Do without Loop Solved/Closed
Hello, So I modfied this code from an CCM post. I have Do I have an End IF Why am I getting the Error? This query is copying data from s...
-
Inserting pictures from a file name that is made from 3 cells Closed
I am looking for a macro to insert all of the pictures from a folder who's address is derived from multiple cells. Picture location is as follows: ...
-
Excel formula help Closed
Hi guys need help with some formulas I am currently trying to combine. the Rules is 1. If there is a "Form submitted" in the day I have to cop...
-
Sorting the highest value with dates Closed
Need help with formula or script Where I need to look for the Van's highest Passenger# with the latest month available for example van 800's l...
-
Conditionally copy col values from one sheet to master sheet Closed
I have 3 workssheets, Master , Billing and EA.I'm trying 2 diff things: 1. update the master sheet when either of the Offer or EA sheets are updated/...
-
Compare of two column Closed
I have 2 columns column a have unique record in repetition and in column b I have non unique values ...now what I want ...I want to place the remark...
-
Dates in Excel are all mixed up and won't convert Closed
Hi, I downloaded some data from my bank for some transactions. Using MS Excel 2008 V 12.2 on a Imac 2015 I usually convert the dates to YYYY-MM-...
-
Help creating a VBA macro Closed
Hi - I just started a new job and I'm trying to create a VBA macro to automatically run for the P&L template I put together (smartview) using somethin...
-
Problem with script in Excel Solved/Closed
Hello, I have a problem with my script. What I want is IF the value in column J is equals to "0" then I want the column H to be blank. Ex. J1 ...
-
Conditional formatting rule Closed
I was wondering if anyone could help me to set up a conditional formatting rule for a cell that may contain any text that has not already been specifi...
-
MACRO to split data into multiple sheet Closed
I have a data sheet with below columns, would like a macro to split data into each tab according to cardholder_name if this is possible Cardholder_...
-
Auto copy excel cells to my systems Closed
Hello, This Lim, can i have some help to solve "manual things" problems? This is my excel worksheet (contains orders numbers) Everyday I...
-
Cell colour containing specific info Solved/Closed
Hi, I am currently using Microsoft Office Excel 2016. I am busy doing a spread sheet for work and need to know how to change a cell colour if a differ...
-
Validate copied data in excel Solved/Closed
Hi, I have a below scenario one row is copied and pasted, this pasted row needs data validation such that total of each cell shouldn't exceed the r...
-
Formula to find matching IP values in two sheets Closed
I really need help figuring out this issue that I am not too sure that actually has a solution. I have two separate spreadsheets (lets call them "s...
-
Automatic Macro required to copy and paste Closed
Dear Sir, I have one excel sheet where all data is save from A1 to F46 Cell. I want to copy this data from A1:A46 and paste it into new excel Shee...
-
Multiple worksheet data input Solved/Closed
hi TrowaD, I am an on the job trainee at a company, i was ask to encode data from our furnace but its too much time consuming for me to encode all...
-
Conditional format based on text in same row Solved/Closed
Hi all, New to this forum. I'm running Excel 2016 on Win7 -- my spreadsheet has results of inspections in columns E, G, and J. The possible valu...
-
Excel Monthly and Daily sheets Closed
Hello, Hi, I have an excel worksheet we use for daily retail business paperwork. It has 3 sheets with Daily Toatals, monthly Totals and Yearly Tot...
-
How to manage hours and rounding in Excel Solved/Closed
Hello, I need to know how to add a function to a cell in which I have figured a days hours worked with a lunch. The current formula is =(C7-B7)+(E...
-
How to Compare two workbooks and see if data has moved or not? Closed
Hello, I would like to preface this by saying thank you in advance. I'm interning and one of my superiors has asked me to compare workbooks These ...
-
Autopopulate sheets from summary page Closed
Hi, I know this question has been asked in varying forms on here and I tried to modify the macros presented to work for my particular spreadsheet b...
-
Make a shared file that can store data for the whole year Closed
how can I make a shared file that can store data for the whole year and you can select the file for a specific month, day, and year? Using Macros. or ...
-
Find out values difference between 2 excel sheet Closed
Hello, Dear Friends, I have facing a big problem in my generate billing per month because i have 2 excel sheet 1st one create manually (Manua...
-
How to set up multiple taxes inclusive formula in Excel Closed
I have a reverse calculation problem- Lets say the price of an item is $10.00 with two taxes @ 10% and 20%. Now to calculate the inclusive tax amoun...
-
excel error Closed
Hello, hi, This is dinesh from axis bank employee i get the result when type for date formet like 5-june in 20206 somebody help me. Syst...
-
Workbook to track subcontractor invoices and payments Closed
Hi i need some help with a workbook im working on and i cant figure out how or if what i want to do can be done. the workbook is to track subcontra...
-
creating 1 list from 2 others Closed
I have 2 lists of content (previous and current) where some entries are duplicated. I need to pull together a list of entries in the previous content ...
-
Formula Solved/Closed
I am trying to find a formula that will add up all blank fields in a range of cells. For example, if cell 1,2,3 have data and 4,5 are blank I want the...
-
Compare data between sheets and highlight identical (Mac) Closed
Hi, Macros aren't my specialty and I need to Highlight on sheet 1 all the identical products that sits on sheet 2. i.e. : Sheet 1 Product A Pro...
-
Compare two Excel sheets. Closed
Dear Sir, i have worked in excel 2007 facing a big problem, actually i have 2 excel sheet which on generated billing software n other one maintain m...
-
Transferring data into a new worksheet when it meets a criteria Closed
I have a worksheet where we track whether a job is late or not. If it is late, one of the cells is "TRUE." I want all the "TRUE" rows to transfer into...
