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 ...
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...
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...
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 ...
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...
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: ...
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...
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...
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/...
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...
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-...
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...
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 ...
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...
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_...
Hello, This Lim, can i have some help to solve "manual things" problems? This is my excel worksheet (contains orders numbers) Everyday I...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
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...
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 ...
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...
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...
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...
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...
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 ...
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...
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...
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...
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...
I have a record in cell A, I want to find it in a range of records in cell b, if found then I want to look at column c for this record, if column c i...
Greetings, I have taken over as Treasurer for a small non-profit organization and have inherited a rudimentary spreadsheet system for tracking thei...
Hi Is there a way of doing the following for example? In cell B1 for example, I would like whatever is in A1, but with the same text colour. ...
Hello, I am trying to get text to change in one column based on text selected from list in another; example in D2 I have a drop down list represent...
Hello, pls tell me formula for convert date of birth in word in excel
HI I have two excel files .want to know how to compare the data in those excel files
Hello, I have two excel sheets with IP Codes. I need to find which IP Codes are not available in Sheet#1 and highlight them, i.e. Sheet#1 Column ...
Hello, i need formula help please! i am working with three columns of data. if: cell A1=B9904 cell B2=A2399B then cell C2 needs to =B9904 A2...
Hello, I'm making an Inventory workbook for a small manufacturing company I am assisting over the summer, and I've run into a problem. On the fi...
Hello, I have "text" in cell B1. However, I want the font color to change based on the numerical value in cell B8; so if the number in cell B8 ran...
Hello, I have a highlighted portion and I want to copy and paste it 200 times. Is there a code or formula to do this automatically? Or must I hit ...
Hello, I am trying to make an excel sheet for school to enter their different classes data base. I want to to create a templet table or colou...
Hello, I'm trying to create a macro that I can run that will create a new sheet based on a row. The new sheet will have all of the column headings A-Q...
Hello, I can not seem to figure out this conundrum. I am looking for conditional formatting to occur if cell $AI2 has