The discussions
Excel query
Hi I looking for a formula that will calculate an average order spend by day without having to do this manually(1, 2, 3 ). So for example it tak...
Copy and paste multiple
Hi I'm looking for away to be able to copy a single cell from multiple sheets (tabs) for example cell a1 and list it's contents on a separate summ...
Auto populate record from one sheet to another
Hello, I'm working on a commissions spreadsheet for my company and would appreciate some assistance with a question I have. There is a separate ta...
Data link
Hello, I'm needing help please, I'm trying to figure out how to either: Link an Access database to an Excel Spreadsheet where it has a templ...
Conditionally format a cell so it turns a certain colour
I was wondering how to conditionally format a cell so it turns a certain colour when it goes past a certain date. Thanks
If, and question
Hello, I'm trying to work a formula that will change a given value in one based on dates going into several different cells. Example. If I pour a co...
Column to vlookup
SolvedI am trying to write a formula that will give me the value in a cell, it needs to come from two sources. I must be able to locate the column based on ...
If function with time duration
Hello, I dont understanding why this can't work : =IF((g2=timevalue("0:30"));"25) G2 has a time duration time unit in it which equals 0:30. ...
Disable a cell in excel using vb code
SolvedHello, I am looking for a VB code to disable a cell based on the value of another cell in excel. Example:- Need to disable Cell B1/C1/D1 based o...
Conditioning formula to convert "x" into another cells value
good morning, I have a spreadsheet I am trying to create for a chili cookoff, I am trying to find a way to type an "x"(or any text) in a box showin...
User friendly code for admission no
SolvedHello, I would like to request to Code for Admission No Range is started from B11 to B510 If user enter a123456789 or a-123456789 it always conv...
Days of the week conditions
Hello, I am trying to create a template for my work. I have a table sorted by dates but need to reference the day of the week that date falls on....
If one cell g4 has value 12345 then cell f4 will have....
SolvedI need help with a basic excel formula. Please :) If cell G4 equals 12345 then cell F4 equals USXX but also if cell G4 equals 54321 then cell F4 w...
Auto copy row from one sheet to another via info in first cell
SolvedHello everyone, hope you all had a great New Year. I am in the process of exporting a BOM out of Inventor and then opening it with Excel. Once I ha...
Creating a summary sheet
Hello, I have a worksheet that is recording customer interactions, and I would like to create a seperate sheet to summarize all the customers that ...
Button to copy sum to next row on another sheet
Hi, I think i have almost go this (pretty new with vba). On first sheet 'comparison' i have a few variables which can be changed then the sum of...
Barcode help!!
Hello, I am making a barcode system and I want to be able to display the information given in the barcode in the cells next to it. For example I a...
How do i exclude a value when using counta?
Hello, I am currently using the following formula to count cells that are not empty =COUNTA (D4:D17) However in this range there are certain...
Automatic transfer of data
Dear CCM, I have a sheet with combined values for different units and I manually sort into the different units manually by copying and pasting into ...
Excel
Hello, if the column a and column b are equal, i want to put "-"(minus sign) before the data of column b for further technical purpose. eg. it lo...
Vba: creating new sheets based on copy, nameing them the cells
Ok, i am gonna try to be so clear i can. on Sheet 1 (Start Sida) i have a list from cells A9 to A500 with names. atm only A9-A52 have names in them. ...
How can i multiply a numeric value and alphabetic value in exce?
Hello,plz answer as soon as possible
Difficult query
ClosedHello, I would like to request for a difficult query that may be not solvable logically. If user enter az123456789 or az-123456789 it always co...
Automatically transfer data from one worksheet to various others
Hi, I am trying to figure out how to automatically transfer data from one excel worksheet to another worksheet but only when a specific cell(s) ar...
Automatically transfering data after generating new worksheets
Hello, It has been a while since I have worked with code and would appreciate any help. I have one code already working which is gathering all ...
Search and copy..
I have two Work Books open and I have filters on both WBs.. Let's say I have filters for Name, Birth Date, Address, and Phone# for both WBs. Is it pos...
Macro to rename tabs based on cell reference on another sheet
Hello, I am attempting to rename 5 sheets in a workbook based on values from a sheet titled Raw Data Information. The first sheet should be named bas...
Countdown in excel
Hi, I'm a bit of a formula novice in excel. I have been googling, but not sure if I'm typing in the right questions, or if what I want to do is eve...
How to combine 2 formulas in one box?
Hello, I would gladly appreciate any advice on how to finish or redo my formula. I have most of my formula but I can not figure out how to do the la...
Automatically copy the row into the appropriate sheet
Hi everyone. I've set up an excel 2010 workbook to log maintenance repairs through the hotel. sheet 1 is an ongoing log of 5 columns. A= location ...
Excel filter/macro
SolvedHello, Thank you in advance for any time/help you can offer! I'm working on a contact list in Excel and I need to be able to filter my contacts i...
Run-time error with copy-and-insert rows macro
Hi, I am using the following macro to copy and insert rows in an Excel spreadsheet, based on a user inputted value. I place the cursor in the desire...
Colours for dates that are on 2 & 3 month cycles
Hello, In my current role, I have a number of people that I have to assess. I would like to be able to do the below so i can easily identify who i...
Columns & rows help
SolvedHello all, In short, here is what I need help doing: I would like to take 15 items in one column and transfer them into a row in another spread...
Formula for if cell contains word, assign value for multiple
Hello, I am looking for a formula to help me assign a value for multiple words and values. If column A has the contains Apple, assign X. IF i...
Excel conditional formatting
Hi All, I need your help with conditional formatting please? I've a project timeline on a week and month calendar form. I've applied conditiona...
Need to search an excel spreadsheet column
but hoping I'm wrong? Need to search an excel spreadsheet column (say column D) for all rows with the text "3 Pounds" If the text is found in a cel...
Formula if you have credit in one column, debit in next column
SolvedHello, what is the formula if you have credit in one column, debit in next column and balance in 3rd column. Many thanks R Horner Configurat...
Macros invoicing drop down list
Hello, Hope everyone it doing well. I am looking for some help with Excel 2010. I have a template that I use to invoice my customers. My customer ...
How excel displays ascending order of data in other spreadsheet
hello, I try to prepare data of students details with random serial no.s in one excel spreadsheet. How I link it to display ascending order i.e.sma...
Data subsets and duplicates
Hello, I have been trying to find the answer in a few forums but haven't found quite what I'm looking for. I have a column (A) of around 2000 n...
Need a cell to change colour if another cell has an 'x
hello, i need a cell to change colour if another cell has an 'x' in it. so if cell r14 has an x in it cell r13 turns green can anyone help? tha...
Excel conditional formatting w/date range and containing text
Hello, I need to make a conditional format based on the date in a cell being between 30-60 days past today's date and only if another cell contain...
Help with sumif function please..
Could someone please help me?? I need to sum the values of a range of cells that contain certain text (product codes) into another cell. For example...
If condition
if a2=mathura then result plm a2=agra and b2
How to re/name a cell if another cell contains x
SolvedHello, Apologies if this is a simple question but having some trouble figuring it out. I have say 1000 rows of data and I need to label them all...
Data arrangement
Hello, I have 2 sheets in an Excel workbook. I am trying to code certain cells in a pre-made template on Sheet 1 to automatically sync with my dat...
Fill in automatically
Hello, I have two colum in excel sheet colum A1 contain big list of job titles each one of it have a code for example: Job Title name ...
Macro help
Hello All, In short, this is the issue I am facing: I have created a macro to copy and paste data from one spreadsheet to another. Specifically,...
Copy data from 2 sheets in 1 workbook to new workbook
Hello, I am new to macros in Excel and could use any help. I want to copy the basic name and customer info from 1 sheet(1) and create a new workb...
