The discussions
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 ...
Desktop publisher
Hi, I have just installed Open Office in my Dell Optiplex 755 and I wanted to work on a booklet - it seems not working well with me. Any idea plea...
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...
When i transfer my pst file, not all of my files/folders transfe
Hello, I am copying over my pst file into an exchange database, I have been able to transfer over all files except two. These two files come up wi...
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...
Can't open microsoft office
Hello, i just install the business in box app to see an example of a document. but then there's something wrong with the Microsoft office. i fou...
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...
How to link my mail id
Dear Sir/Maám actually our company is secured our intra so please give istruction how to open my mail id thanks,
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 ...
Daimary
Please accept me.
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...
Can i get the autofilter to work automatically without
I have the following which is filter my data based on a cell: Private Sub Worksheet_selectionchange(ByVal Target As Range) If (Intersect(Target...
How to transpose and move data
Hello, Have a data set which is 2 columns and 596 rows, in which I need to transpose parts of the data set, remove empty columns, and then line up...
Conditional data display depending on a dropdown list
Hello, I would like to creat a form which would display certain data dependent on what was chosen in a dropdown list. For example, if my dropdown...
If formula query
Hi there, I have a spreadsheet which using the IF formula should be bringing back either "update Required" or "N/A" depending on if the date in the...
Data consolidation
Dears Need your expertise advice. I have an excel data in below format , need a formula Column 1 has text like ABA, ABA , ABB, ABC, ABC, ABC . ...
Transfering data for a spreadsheet to another
Its not working. May be size (row height & Column Width) not same. Is there any other way to solve this problem.
