Excel Forum
-
Adding delimiters between value of two columns in excel sheet [Closed]
I have an problem, i made an excel macro for adding delimiters between value of two columns in excel sheet. Suppose i added delimiters between columns...
-
Generate workbook files from excel list [Closed]
Hi, I have an excel questionnaire. It like to email it out to persons on an excel list with email addresses, first names etc. The problem is I w...
-
CF using date to change Font/Backgroundcolor to another cell [Closed]
Hello, Good day, can you help me how can I change the font/background color of another cell base from the list in another cell. Example in A...
-
Excel formula [Closed]
who to pass in exam give the grade and who to fail in exam not give the grade show the empty cell excel formula
-
Auto Fill macro when data varies [Closed]
I need to auto fill as a step in my macro but because the data will vary day to day it's breaking! Can someone help me? I need to auto fill column b ...
-
Logic or macro series created by entering single value in cell [Closed]
hii need solution for excel i have series which is to be called / created by entering single value in cell for e.g i hv to call series for 55 it...
-
Require macro or logic in Excel [Closed]
Hi i am looking for solution refer attached excel snapshot need to call or create predefined series in column by entering single value in cell ...
-
Need to compare data on the work book by giving deferent colour [Closed]
Hi There are columns in a workbook with numbers in various cells. I want to compare values in each column with the previous column. Cell b1 should...
-
Script is really slow and sometimes crashes [Solved/Closed]
Hi, My script is really slow and sometimes crashes when there's too many rows. Can someone help me figure out how to make it faster? Dim b A...
-
Need VBA Macros to copy specific data based on condition [Closed]
Suppose I file A which contains yearly data which we update on daily basis. lets say File A contains the data for year 2017 with following columns. ...
-
Compare five Excel workbooks and copying matched data to new one [Closed]
I'm trying to compare five workbooks in excel and have matching column data copy the entire rows into a new workbook (ReportWorkBook). Ex: Compare ...
-
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 ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram
- How to Recover a Disabled Facebook Account
- How to Install a VPN
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB
- Facebook Code Not Received
- How to Create a Gmail Account
- How to Recover Your Yahoo Account
- How to Fix a Blurry Snapchat Video
- How to Get Free Diamonds in Free Fire