The discussions
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.
Auto-copy cells one to another + formation too
ClosedHi! I want to make intelligent excel, like.. i have many sheets and i want it to work the way, that sheet2 takes data from sheet1. so 1) ...
Strike through when entering date
SolvedHello, In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the last d...
Place new code to working code
SolvedHello, I would like to request that some line of code (marks as bold) I have to place in the Working Code which is given below that I cannot figure...
Printing selected columns from multiple sheets
Good day, I recently made a workbook with multiple sheets. I am a newbie regarding Excel. I would like to know if there is a way for me to have ...
How to apply conditional formatting in excel
Solved/ClosedHello, I need to apply conditional formatting to range H1:H10000 based on corresponding values in another column, G1:G10000. If the value in t...
If statement or something else to copy from sheet 1 to sheet 2
Hello, I am looking for a bit of help. I am not sure if this has been asked I tried looking at other post. Any Help to point me in the correct dir...
Please helpin creating a macro that will create a new spreadshee
Hello, I would like to kindly ask for help in creating a macro that will generate a new spreadsheet based on the letter entered in a specific colu...
A macro in excel
Issue : I have a worksheet with two columns. First column contains some individual names, and second column contains Residence PIN number of the in...
