Excel Forum
-
Copying number over from last sheet and adding to it Closed
Hello, I'm trying to figure to if it's possible to do the following: I have an excel doc with monthly spreadsheets and I would like a number to be...
-
tranfering of data Closed
how do i add symbol in cells in sheet 2 if there is data in cells in sheet 1. example: i have data in A2 in sheet one. i want to add a * in A2 in shee...
-
Extract rows of data and paste to new worksheets based on locati Closed
Hello Fellow Excel Users: Please help if you can. I have a difficult problem that I hope someone could please help me with. I have a worksheet of...
-
Office Home and Student Excel Closed
I have read everything. Been asked to submit my first question three times. This doesn't bode well. Third time typing same question. I have used exc...
-
Macro that will delete rows based on greater than current date Closed
Hello, I want a macro that will delete rows that are greater that the current date so if today is 2016-05-05 I want it delete all rows with somethin...
-
copy the number matched to another column Closed
Hello, I want help from world.i want to copy the list of number to other column which are match in original column. Start no 974314567 copy the ...
-
VB & pdf files Closed
Hello, Overall goal to open pdf files, copy information to excel sheets & close pdf files. From reading material on web it might be easier to conv...
-
Excel 2010 - "file is corrupt and cannot be opened" Closed
Hello, We're upgrading to Office 2010 and having some fun issues with old and new .xls files. Current issue is that many .xls files (as opposed...
-
make a new worksheet and copy rows Closed
Hello, I have a worksheet of data and I would like to copy all rows in the worksheet to new worksheets based upon location. To elaborate, I ha...
-
How to build a auto updating Training Tracker. Closed
Hello, I am trying to make a primary spreadsheet for a personnel training tracker, I have over 50 people and 30+ different training items. with f...
-
Graphs comparison in excel Closed
Hello, Is it possible to compare graphs in two excel files using macros? If not, is there any other option to do this? Kindly help.
-
Pulling Data from a note field in excel Closed
Hello, I wrote a formula to look through a note text field for a certain phrase and pull a YES. What I need to do is actually pull whatever number...
-
copy formulas from one sheet to another all at once Solved/Closed
Is it possible to copy formulas from one sheet to another all at once? I have a worksheet that I would like to use as a template and I'm having to cop...
-
Excel Formulas and Functions Closed
I have an excel form where the user types a customer name to find if it exists in another data sheet. If it exists, a function should retrieve it to a...
-
Comparing data in multiple columns to another sheet Closed
Hello, In Excel 2010, I have a sheet of names and addresses that I would like to compare to a new report of names and addresses to find any names th...
-
Vacation tracking help Closed
Hello, How do i make a cell increase by 40 every 180 days from known date... Configuration: Windows 7 / Chrome 50.0.2661.94
-
Macro move next column to next row? Closed
Dear All, introducing my name is John and im new here. Ive data like below A B C D 1 John Willy Dian...
-
Macro that create a new workbook for each unique value in column Closed
Hi, In the example below, I would like a macro that creates a new workbook based on the names in column A and copies only data relevant to that nam...
-
Number format a cell based on the text in another cell Closed
Hello, I want to conditionally format a cell to change the number formatting to a percentage or currency based on the text in another cell. Fo...
-
Want to increment a Alphanumeric value in a range of cells Closed
Hello, I have Alphanumeric value in range of cells example from B2 to b28 number will be like H000000000000100 I want to increment the last four...
-
MS excel question Closed
Hello, I am having a name list in column A and category list in column D and I want to list names of same category in column G in another worksheet....
-
Percentage conversion in excel Closed
Hello, Kindly assist me on How to find a formula for calculating a problem like this one below; Cell A1 (Assignment 1Out of 20) Cell B1 (Assignm...
-
sum of two max out of n number Closed
Hello, mam /sir how to sum of two max out of n number Configuration: Windows 7 / Chrome 49.0.2623.112
-
want to know how to convert date into words(english) in excel Closed
Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April Two Thous...
-
Excel Doubt - IF Formula Solved/Closed
Hi, Im stuck in an if question. I have 3 colums. In the first one I have a number, in the second column a have "yes" and in the third column I w...
-
Conditional Formatting Closed
Hello, Want to apply conditional formatting for specific text but not able to do so. Below is the case:- I have two texts - 1. "N" & 2. "NA"...
-
Automatic Data transfer Closed
I have a master data sheet that one column in the sheet that represents a sub set of the data. When I add information to the master sheet, I want the ...
-
Macro to send notification when a cell expires Closed
Hello, I am working on a database with expiry dates. Is there a way to get a macro to notify me via email when the date in a range of cells wil...
-
add worksheets to excel workbook using count defined name Solved/Closed
Hello, I need to add worksheets based on a count which I defined as ADDTABS located in cell B4 on a worksheet called QRY-CMW. The worksheets ne...
-
Compare several columns to several columns in second sheet Closed
I have a list of names and addresses that I need to compare to a new sheet of names and addresses to see if there are any new addresses added and also...
-
Macro to copy from multiple sheets to another workbook.. Closed
Hello Sir, I have a query i guess this has been soled already, but i just wanted to have a general macro for the same. MY QUERY: I have a w...
-
Sum of Returned Lookup Values in a Text Cell Closed
I'm using the lookup formula below to search user comments in cell B1 to find individual words listed in column C, and return the adjacent number valu...
-
continuously import select data from one sheet to another Closed
I have Excel 2013 I'm trying to use Excel as a study tool where I can enter information into 1 sheet, and have it automatically copied to a more so...
-
Find and Replace with condition Closed
Hello, I would like to ask that in the Range D11 to D510 of all sheets in workbook find "." and replace with ". " If in the above mention range "...
-
using if with a fixed date Closed
Hello, im trying to use a if statement in excel with a fixed date =if(A2="Active",E2=Date(2016,03,31),"Closed") but it returns a 1900/01/00 date p...
-
want to high light to appear on both sheet Closed
Hello, I want to high light data on one sheet which appear on the other sheet. one updated sheet has 950 items and the older sheet other 350. I wa...
-
Conditional formatting from 1 sheet to another. please help! Closed
Dear users, I am supposed to track the progress of units. For example, there are 200 units and they are supposed to give us document A at a certain d...
-
A Tricky Macro Closed
Hello, I am new to macros and simply can not figure out how to write this one. ............... xs s m l xxl full Sku ........Qty 12345-111 0 ...
-
How to convert marks to percentage Closed
Hello How do you find a formula for calculating a problem like this one below; Cell A1 (Assignment 1Out of 20) Cell B1 (Assignment 2 out of 100) C...
-
Excel VBA/Macro Closed
Hello, Need help in creating a Macro to do the following I have a set of formulas on a worksheet called “Adam”. Cell A2 of worksheet “Adam”...
-
Changing font color in one cell when % in another cell changes Solved/Closed
Hello, I have a balance in B1 of what's owed on my credit card. I have the % of use on that card in D1, IE 35%. I want the font color to change ...
-
Text format to date/month/year on excel Solved/Closed
Hello, I have a huge list of data that has multiple dates/year along with different time format. I want to delete the time and obtain only the d...
-
Problm in Macro for deleting row Closed
Hello, Hello, First of all let me thank you all for sharing your knowledge in this forum. You guys are doing a great job. Now moving to my ...
-
I want to retrieve value from multiple sheets of same workbook Solved/Closed
Hello Everybody,.. I have a situation where I request your support, My active workbook has 4 working sheets (sheet1- Master, sheet2, sheet3, sheet4...
-
excel formula using 3 tabs Closed
Hello, Can someone please advise if there is a formula or a macro that I can use for an excel spreadsheet. The first sheet tab consist of the ...
-
VBA FontColor Changing Adjacent Cells Closed
Good morning all, I'm stuck on a particular vba script for a Risk Register if anyone would be able to offer any assistance. Essentially the scri...
-
Stuck with Active sheet selection in Macro Closed
Hello, I am at very infant stage of working with Macro. I tried to run a macro where in the macro file creates a new file with data from original ...
-
Copy range data in a column to new column. Solved/Closed
Need help here please !!! Data available : A range of data in a column. Some of the cells are blank. My requirement : Is there any formula where...
-
Counting between dates Closed
Hello, I want to count the response to applications made to different organisations between set dates. In column C i use a simple 1 or 0 to indic...
-
Find number in cell and return text in adjacent cell. Closed
Hello, I'm trying to search a cell for a number, and if the cell contains a number I need to return a word in the next cell (the cell I am doing t...
