Excel Forum
-
Entering current time in specific cells Solved/Closed
Hi, I am using a workbook where I record the time that I give each of my students an exam. I am using a tablet and I would like to be able to touch (o...
-
excel dynamic matching Closed
hiya, i have three sheets: sheet 1 - detail is input manually someone's name and personal details sheet 2 - a sheet that takes some detail f...
-
Count the number of days from start date to end date Closed
Hello, I want to count the number of days from start date to end date. ie. 1/2/15 - 1/4/15 is 3 days.
-
Need help with formula Closed
I am needing some help with a formula...if possible. I have numbers from 1-85 listed in column F. These numbers can appear multiple times. I have a v...
-
Finding multiple doc cases that do NOT have a specific document Closed
Thank you for letting me post here. My question: I have several thousand case files, a different one for each of several thousand clients. There...
-
calculating the positions of my students Closed
hi i need help in calculating the positions of my students after having calculated their total marks
-
show the duplicate values for each party name Closed
I want to show the duplicate values for each party name. Kindly help
-
How to transfer info from one column to another Closed
I have approximately 650 names in Column A. Column B is blank. Column C contains 3400 names. Column D contains information about Column C. All of the ...
-
On Cell change event vba Closed
Hello Folks, I m trying to get hold of on cell change event vba code, if the cell value is changed to blank or zero. otherwise i have code which tr...
-
Comparing Two Columns With other two columns in excel 2003 Solved/Closed
Dear Sir, I want to compare two columns with other two columns in excel 2003. Columns are as below A B C D a 10 a 10 b 20 b 30 c 30 d 40 ...
-
Excel - shortcut key for print view Solved/Closed
Hello, I am srinu what is d short cut key in ex-cel 2003 for print viewConfiguration: Windows XP / Safari 532.5
-
Replacing an empty cell's contents Closed
I have some empty cells in "J" column which I want to replace with data from another cell which is in "X" column. The formula has to be in "AA" column...
-
Populate Data from 1 Sheet to Multiple Sheet in Master Workbook Closed
Hi, Source workbook is where the data is maintained and from where the macro will be run. Master workbook has 40 sheets and I want the macro to ...
-
Please assist with an If formula referencing 2 cells Closed
Good evening, I was hoping if someone could please assist with in creating an if statement to utilise in a training register. I have a dropdown men...
-
create worksheets with names from a list Solved/Closed
Hello, I would be most grateful if you would kindly help me out. I have a long list of projects and need to create an individual worksheet for ea...
-
Finding terms in one word sheet & display on another word sheet Closed
I have two work sheets: Projects sheet that lists clients and the services we provided: A B C D ...
-
calculate percentage in excel Closed
Hello, My question is how to calculate 495000 kg main item scrap only 8 kg how to calculate in % figure
-
R, moving every other value in a column to a second column Closed
Hello, I have been tasked with manipulating the data ina a vector of 900 values in a form of a column. Every two values signifies a lenght and weig...
-
Integers in multiple rows to single row Closed
Hello all, My data set is like as follows: (All integers) ROW 1: 1 2 3 4 5 6 7 8 9 10 11 12 13...to 26 (26 cells) ROW 2: 27 28 29 30...52 (26...
-
Copy a set of cells and paste it 430 times Closed
Hello, In excel i need to copy set of cells and paste down 430 times. Any suggestions. Regards, Arunmaran
-
Keep track of hours Closed
Hello, I have a list of people and how many hours they have missed from work. Is there a way to sync this every day with the new data which might ha...
-
Get Mirrored Column "Structure" in 2 Sheets Closed
So this turned out to be a complete mind-breaker for me. Thanks to the help I previously received on this forum I can already manage (and enjoy!) q...
-
Help Please IF & VLOOKUP Returns Closed
Hi, I'm trying to use the following formula which works however I can have more than one number which is the same e.g( B2 can be in the TOPWE tabl...
-
Transfer, populate and calculate data between excel sheets. Closed
Hello, I want to be able to input data daily onto the first sheet of my excel file for six different things. I then want to have a separate sh...
-
incrementing the column at regular intervals Closed
Hello, I need to increase the cell range at regular intervals using macros. My code is: Do While Cells(2, m).Value "" Range("cells(2,...
-
Hide Zero Rows or Zero Columns in a Worksheet Closed
Hello, I would like to know if there is VB code out there that solves for Hiding rows and Columns that show either zeros across the rows or the ...
-
Excel - Merge several worksheets into a single one(thanks) Closed
Hello, I use Excel to store information about several users and their cars information and have a different worksheet for each month. How to merge...
-
How to filter out data to separate sheet? Closed
Hello Guys, Can someone pls help me out with this problem I am having. I have 5 drivers on payroll for a car service company. I have all the a...
-
file attachment Solved/Closed
Hello, is it possible to attach an excel file in this forum, for a better understanding of a particular posed question? Configuration: Windows ...
-
check info on two different cells... Solved/Closed
Hello, Ladies, Gentlemen, I am working with the formula below, and it WORKS GREAT =IF(Z17="PAID","",IF(F17"CTF","",IF(TODAY()>B17+15,"PAY NOW","HOLD...
-
Disable right click on sheet tabs in excel (MAC) using VBA code Closed
Hello, I am looking for a VBA code to disable right click on worksheet tabs in MAC excel. Application.commandbars("Ply").enabled=false is not ...
-
How to restrict user from deleting a sheet? Closed
Hello, I want to restrict the user from deleting a sheet using vba code. I dont want to protect the sheet. Is there any option to protect the s...
-
Macro auto run on file creation. Closed
Hello, I have an excel file created automatically every day, I want to be able to run a macro against the file when it's opened. I can automat...
-
Write data if a text is found in that colomn Closed
I want to write some value if A text String in Cell A is present in another colom and if found then I want to write the value of that row in front of ...
-
compare data from one excel sheet to other Closed
Hello, i should compare data from one excel sheet to other, please help me to solve the issue. Configuration: Windows 7 / Chrome 45.0.2454.101
-
Random sorting without adds-in Closed
Hello, Is there any way to random sort without using random sorter add-ins? I just want to random or shuffling the row just like the pic. ...
-
conditional formatted cell with specific colours should copy in Closed
Hello, i got live data from web. i had given some condition to each row if the values are higher or lower when comparing with specific cell. i had...
-
my enter keys and arrows stop working in Excel. what can I do Closed
Hello, My enter keys and arrows keys stop working in Excel, what can I do to fix this problem/ Thanks for any help. Configuration: Windows / Ch...
-
auto transfer data as i marked Solved/Closed
Hello, I have a spreedsheet where there are names, enrolment No., various subjects(1st Year, 2nd year & 3rd year) of at least 10000 students related...
-
Populating Sheet Based off date criteria in another Closed
Hello, I have a database that I would like to auto populate all of the 2015 events into a 2015 sheet. I need the data in both sheets as the main i...
-
Range Formulas Closed
Dear All In Ms excel column "A" is names of 30 staffs, column"B" is dates, column"C" is amount I paid to them, Now total number of payment is abou...
-
Pulling data from different workbooks and collating on another Closed
Hello, I would like to be able to do the following; have a number of work books which are allocated to team members (x4) which they complete with ...
-
Counting action under condition of theyr value, and month when.. Solved/Closed
Hello Guys, I came here for help again :) I need to solve one issue. I've created database, which contain column with Dates(column E),and column w...
-
Editing a date+time field converts date to text Closed
Hello, I have formatted a (Excel 2010 spreadsheet) column as "ddd\ dd-mmm-yy\ \ hh-mm\ \h\r\s" which shows the existing data as "Sun 04-Oct-15 ...
-
Comparing Spreadsheets Closed
I have been given a task in Excel and i am not good at it. I have two different spreadsheets with first and last names in them. I need to compare sp...
-
@if formula Solved/Closed
Hello, how do i formulate the following:- if cell B12 contains the word Meals, then I want to use the formula F12/2 else take 100% in F12 Conf...
-
Change text value in one cell based on text value in another cel Closed
Hello, I was wondering how can I change text value in one cell based on text value in another cell by using the conditional formatting? For exa...
-
i want to plus data from two excel sheeets to the third sheet Closed
Hello, hi Configuration: Windows XP / Firefox 38.0
-
Cell formating Closed
Hello, I have excel sheet that contains 1000 rows of customer and i need to change color in one cell based on anther cel in same row ,this i solv...
-
conditional Formating a column Solved/Closed
Hello, I wish to conditionally format a column depending on another columns date value in excel 2010 Column A has a target date and Column B ha...
