Excel Forum
-
Macro to copy and paste rows until blank comes Closed
Hello, Can anyone help me to write macro code for the below condition. I have data sheet which updates on a daily basis and no. Of rows with r...
-
Excel Filter/Macro Solved/Closed
Hello, 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 Closed
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...
-
How to automate copying cells from one workbook to another. Closed
I need a VBA, macro or some way to be able to load cells from one workbook to another. The first workbook has the cells I need on one row, I need to c...
-
Colours for dates that are on 2 & 3 month cycles Closed
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 Solved/Closed
Hello 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 Closed
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...
-
Highlight Dates for 3 or 2 month cycles Closed
Hi, I manage a number of staff and have to assess them. I want to be able to do the below so i can easily identify who is close to the time limit. ...
-
Excel Filter Question Closed
Hello, I'm working on a contact list in Excel and I need to be able to filter my contacts in a few different ways. Each contact is in a row and ea...
-
Excel conditional formatting Closed
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...
-
forget password of Excel file Closed
Hi, All friends I have forget password for my excel files to open, can any one help me to open this file. I have attached picture of problem. ...
-
get last used column address using current region property Closed
Greetings, I have attached an image a look like of my input file. In this, I need to get the address of the highlighted portion. I have used 1 as t...
-
25% of a cell if text in another? Closed
Hello, I was wondering if someone could help me with the formula for 25% of a cell if another cell has text in it to give me the sum total of a ra...
-
Excel data transfer between separate spread sheets Closed
Hi guys, I have a table in the spreadsheet that I want to transfer data from to another spreadsheet. The thing is that even though not every field ...
-
Need to search an excel spreadsheet column Closed
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...
-
conditional formatting Closed
Hello, I need a help from you . Am trying to give three color condition in a pivot table and slicers report. We have sheet with Pivot table ...
-
Bringing similar names of different spelling together Closed
Hello, I have 2 similar files. each has several columns of information. each row for one person. 80-90 % of the rows in 2 files are the same person...
-
formula if you have credit in one column, debit in next column Solved/Closed
Hello, 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 Closed
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 ...
-
Excel right and left arrows not working properly Closed
Hello, I spilled Coke on my laptop this afternoon and while frantically trying to remove it I pressed something that has inserted some kind of pr...
-
how excel displays ascending order of data in other spreadsheet Closed
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 Closed
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 Closed
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 Closed
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...
-
Date format not changing! Closed
I exported some data from a CRM system and the date exported like: Dec 9 2015, 3:00 PM I need to change this to: 12/9/2015 I've tried chan...
-
Excel date formula won't change Closed
Hello, I exported some data from a CRM system and the date exported like: Dec 9 2015, 3:00 PM I need to change this to: 12/9/2015 I've tried...
-
conditional Formatting cell in a column vs a cell in other col. Closed
Hello, I am comparing two cells in two different columns. I will do this for the 124 rows. if column G cell let's say G7 is larger than B7 then G...
-
Help with Sumif function please.. Closed
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 Closed
if a2=mathura then result plm a2=agra and b2
-
How to re/name a cell if another cell contains X Solved/Closed
Hello, 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...
-
Screen is locked - its not scroll lock Closed
Hello, My screen wont move up or down, neither from cell to cell. Its not the scroll lock function. Anybody know what function I activated by mi...
-
Data arrangement Closed
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...
-
Define a default path for macro enabled template file (saving) Closed
Greetings, I have created a macro enabled template file named test.xltm. Double click on the file opens a file named test1. on choosing save as res...
-
fill in automatically Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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...
-
Create new workbook copying data from 2 sheets in same workbook Closed
I want to copy the basic name and customer info from 1 sheet and create a new workbook with that customer's name as part of the file (and copy several...
-
IF Formula Query Closed
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 Closed
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 . ...
-
How to create a macro to update a file based on a masterfile Closed
Hi I would like to create a macro (program) which will update a file by clicking on a button, based on a masterfile. Basically I have a list of ...
-
Transferring data Closed
Hi, I use excel 2007 version. I have some data in an excel sheet - students' names, ids, test items attempted, multiple attempts made by each st...
-
Transfering data for a spreadsheet to another Closed
Its not working. May be size (row height & Column Width) not same. Is there any other way to solve this problem.
-
Conditional format only if different from cell in another sheet Closed
Hello. I am using Excel 2011 on a Mac. I have two sheets in my worksheet. Both sheets are a two week schedule. Sheet 1 is titled PP - it is the ...
-
auto-copy cells one to another + formation too Closed
Hi! 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) ...
-
set a conditional formatting to highlight the latest number Closed
I have a column to record invoice numbers in this formatting KI-00123 where the number portion is in running order. How do i set a conditional formatt...
-
Strike through when entering date Solved/Closed
Hello, 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 Solved/Closed
Hello, 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...