The discussions
Lookup functions
I have a spreadsheet with various tabs including data which has been dumped in from various sources. Data includes: worked hours by department, and pr...
Conditional formatting of one based on the other cell.
Hello, I was wondering if there is a way I can say to excel without coding: 1)IF cell A1 is equal or greater [equal or less] than cell B1, then...
Conditional copy of cells with corresponding values
SolvedI have a list of variables in column A. I also have their values in column B. I then have column C, which has variables from the list in column A but ...
Conditional formatting of one cell based on the other cell.
Hello, I was wondering if there is a way I can say to excel without coding: I have three cells A1, B1 and C1. If A1 value (which constatly chan...
Count formula (need help)
SolvedHello, everyone I want to thank you in advance because I know that excel can be frustrating. I hope this is an easy one I have the following data list...
Using if function with dates
SolvedHello, I want to thank everyone for their time in advance. My problem is that I have a two cells/rows (78 & 87) in a column on this worksheet ...
Windows 7 excel 2013 jump lists
I'm using Windows 7. My Excel 2013 Jump List only lists the latest CSV files. How can I also get my excel files to show in the jump lists? (This...
Compare three columns in three sheets
Hello, I have two excel sheets. Sheet 1 has A,B,C,D columns and sheet 2 has A,B,C columns.Now I want to compare A,B,C columns in both the sheets. ...
Insert a row below a given cell of a table
Hello, I have a table on Excel 2013. I would like a macro to do the following: 1) insert a row bellow a given cell 2) copy the format of the origi...
Finding the last used column
Hello, Can anyone help. I want to find the last column used so that I can compare it with the first column Configuration: Windows XP / Firefox ...
Macros editing
SolvedHi Guys, I have created a macro that splits a master worksheet into separate tabs based on specific criteria then saves each tab as a separate wor...
How to create a macro to find the value in specified cell
Hello, i need to create a macro to find a cell based on the value of other cell. for e.g. i want find the cell by copying cell "DH1" (in which t...
Formullas
Helo i need some formulas .e,g.TA,DA,HR,INTEREST% in like insurance. And Grade,%,fail,pass. Please help me undefinedHelo i need some formulas ....
Vba to protect cell in excel
Hello, Hello, I need a help if some one can help me. i a fresh in excel vba code writing. please provide a code to protect a cell with passwor...
Search and extract up to 10 lots of 46 sequential cells
Hi, I need to search and extract up to 10 lots of 46 sequential cells from column A containing 1400 cells. These 9 or 10 lots of 46 cells need to be c...
Refer only one column from named range
SolvedHello everyone and thanks in advance! I have a report in excel 2010. In that i created a named range as "nmerng" which refers two columns s...
I need to copy 3 cells into one cell
Hello, I am having a problem in excel I can't figure out. I have an example of what I am working with below. There are 3 columns A (SKU), B (Numer...
Conditional formatting in a vlookup
Hello, Not sure if what I am wanting is possible but thought I would ask... I have a database in which I will always update and add to. And ea...
Trying to copy from sheet all values to another sheet
Hello, I am trying to Copy from sheet's all values to another sheet. But its not coping with their cells formate.
Compare two columns with another two columns and return
Hello, I need to compare two columns with another two columns and return date from a third colum. Example I have a zip code with 90004 with 3 dif...
Find a word based on # and copy word to another cell
Hi all, I have a lot of social media messages in row 1 below eachother, and my goal is to find all the hashtages from the messages. For example: ...
Data transferred from macro
Hey guys can you please help a desperate girl out lol I have a report I do every 2 hours at work through excel. I have two reports that go into a m...
Macro to repeat a row n times
Hello, I want a macro to repeat a row n times. Example A B C if n=2 A B C A B C Thanks in advance
Lookup relevant value from table
SolvedHello Team, I have a doubt, Consider the table : Event A B C 1 3020 3420 1324 2 3005 3405 5462 3 2990...
Macro for insert picture
Hello, Please help i have to insert item pictures in column A i have item code in column B. All pictures saved in D drive folder name pictures. fi...
Copying dates in excel
SolvedHello, I created a workbook in Excel and frequently need to copy the same date down a single column. I've always been able to simply grab the + in...
Combine text from multiple cells if other cell has a value of 1
As per the picture I have a spreadsheet that tracks what courses an individual has completed and if that course has a Certification attached to it. If...
Moving data in sheet depending on contents of a cell
Hello, I have a sheet, where at the top, I have a table of all orders in production. In column "I" you can set the status of the order using data ...
Formula for convert number into word
dear sir, i want to formula for numeric value (Ex. 12,350/-) into word (twelve thousand three hundred fifty rupees only) please rep...
Change color of one cell based on another cell
Hi, I am trying to create a speadsheet based on customer sales. In one cell it has "yes" or "no" to inform me on whether or not the customer is commi...
Restrict user from printing empty pages in excel vba
Hello, I have three print areas in a single sheet. If I print that sheet, it prints 3 pages(print areas). Is there any way to print only the p...
If statement
SolvedHi, Could you please tell me what I'm doing wrong in this statement? I can't find the issue :( =IF(AND(C2="Passed",D2="Passed",E2="Passed"), "Pass...
Copy data from 1 workbook to another based on sheet tabs
SolvedGood day to all, I'm looking for a macro that can copy data from source workbook and paste it to master workbook based on specified sheet tabs. ...
Match requests sent to bank with requests processed by bank
Hello, I am trying to match the requests processed by the bank with the requests sent to the bank for processing. The bank could process part of ...
How to return a cell value from a sheet that is not created yet?
Hello, I am creating a job summary sheet to collect data from sheets that will be created based on each day worked on a project. I've created a...
Creating sheet with list having duplicate values.
Hello, I have a list in a column need to create sheets with each value in the list. The list will have duplicate values. but excel cannot have two s...
Hide page breaks in excel 2010
Hello, Is it possible to hide page breaks in excel while shifting from print preview to normal view using vba? I know to remove pages breaks ...
Link data from one cell to another
SolvedHello, ok now what I am trying to do is make a simple formula that will let me take some data out of work book a and have it appear in work book B. ...
Excel:print one enlarged page to multiple pages
SolvedHello, Is it possible to print a enlarged page to multiple pages in excel? Configuration: Windows / Chrome 45.0.2454.101
Master sheet data
I have a master sheet on Excel with inventory of uniforms and who is assigned to each piece of uniform, ex: Gordon has #4 hat, #22 coat and #88 pant. ...
Want to add new colom if a text is found in a cell range
Hello Everybody, As shown in attached fig. I want to write in foundIn colom if a text in authors colom is present in Publications colom. If it is fo...
Inputting a text based on another column text.
Hi, Hope all is well. I was wondering if you can help. I cannot figure out the formula to automatically add text to one cell base on another c...
Macro or help with populating data after inputting
I would like to be able to enter information into the sheet shown daily (therefore every day different and new data will be inputted into this main sh...
Excel /vba - copy data from one work book to another
Hello All, Can you please help me to make VB program for an excel file. Basically I want to copy the data from an excel work book which is located...
Entering current time in specific cells
SolvedHi, 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
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
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
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
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
hi i need help in calculating the positions of my students after having calculated their total marks
