Excel Forum
-
Date format in excel. Closed
Hello again, Is there a way to make excel read fields left padded with a 0. For example I have a program that only reads date format like th...
-
Macro for finding dates Solved/Closed
Hi guys, Is there a macro that would give me the the cells in a column in which there are dates between 2012 and 2013. It can be easily filtered b...
-
EXCEL & Power point MACROS Closed
Hello, I am wanting to create a macro, if possible, that will pull only certain data from one worksheet that i get daily and paste that data on an...
-
having trouble with macros Closed
Hello, I need you help please, I want to write the macros something like this: if x = 1(number of month) and y = 1 then z = 31(number of the ...
-
Macro To Copy Data Solved/Closed
Hello, I have two excel sheet with three column on each sheet Sheet 1 Sr.NO Code Name 1 1256 2 1256 3 1258 4 1258 5 1259 6 1259 7...
-
How to build a macro that does this... Solved/Closed
Hello guys, I would like to build a sheet that contains several names and infomation pertaining to each name. The first tab would be the search in...
-
Macro to compare worksheets, highlight change Closed
Hello, I'm trying to create a macro that compares two excel worksheets and highlights the rows that are different. Basically, there is a sheet w...
-
auto extend of range in excel macro Closed
Hello, friends I am working on data I have a formula in range w1:aa1 and I want to copy paste that formula in range (column 0:Column S) till the ...
-
Vba code Closed
Hello, I need to know how to change normal path to a server path. Eg c:/home/my.xls To serverpath/home/my.xls Any idea how I can do this ...
-
Separating items from columns Solved/Closed
Hello guys, Could you please help with this... Is it possible to do the following in excel: I have similar cells to this in one column: Ford v-36...
-
Sumif Excel Function - multiple conditions Closed
Hello, I have a list of job titles in column A with their corresponding headcount amount in column B. Is there a sumif formula that will sum the t...
-
VBA to Copy data on date Closed
Hello, Team please help me with the below situation. I have 15 workbooks, every day i capture data in sheet1, it has 8 columns, with date in 7t...
-
A Macro to move data from rows to columns Solved/Closed
Hello, I have data in a single column and would like to copy it into a rows for every x rows, for example; The column of data varies in the amoun...
-
Macro question Closed
Hello, I'm new to the forums and was wondering if someone could help me with creating a macro in MS word. I've had a little experience with macro...
-
How to match 2 row of data in excel ? Solved/Closed
Hello, brothers & sisters I have 2 columns of companies name say (column a=38900),(column b=1000) so how can i use a formula to do a match by thei...
-
Excel - How to repeat multiple functions Closed
Hello, I'm trying to set up a spread sheet in excel. Following is an example. A1 is say 500 B1 is say 50 and is a number from a IRS table t...
-
Excel Data Merge Closed
Hello, I have two excel sheets that are similar. Sheet one has a master list of contractors that are active and sheet two has another list of contr...
-
large col. based data to be changed to rows Closed
Hello, I have a large excel 2010 based data file sent by my retail partner. The first 5 columns have the list of my SKUs being sold by them, ...
-
[Excel] Macro to add prefix to column Closed
Hi, I recorded the following macro to add a thorn symbol before and after each record in a table. I can't figure out how to edit the macro so that...
-
How to handle linked cells? Closed
Hello, I am trying to get this formula to work: =IF(T8=0,"100% with PO",T8&" days, NET") T8 is linked to another table and contains the followi...
-
Match data from Master Worksheet Closed
Hello, i have two worksheets A & B with different fields but one field is common in both worksheets. I want to get some field from sheet B. Fiel...
-
Excel row to colum Closed
Hello, i would like a little bit help. i want from this: data1 data2 data3 a 120 20120903 b 270 20120903 c ...
-
excell find in a cell some text Closed
Hello, I am trying to find in a cell some text. I would want for example in D1 to see if it had: Low Low, if so put a 1 in the E1; High High, put ...
-
Embed Macro Closed
Hello, I hope this isn't too much of a nasty one for Friday afternoon! Any assistance much appreciated. Is it possible to run a macro inside of ...
-
Excel, comparing two sets of two rows Solved/Closed
Hello, I know the title may be a little confusing, and I apologize for that, but I really did not know how to phrase it. What I have is two Excel...
-
Excel formula which calculates start date Closed
Hello, I would like to create a calendar tool that will generate a start date from a set end date that excludes weekends based on processing and t...
-
Text in Macro Closed
Hello, I'm new to writing macros and wonder if anyone can help me with a couple of areas I'm stumbling on? Firstly, let me say that I am wr...
-
Conditional Formatting Excel 2007 Closed
Hello, I am trying to create a rule that when "yes" is selected in the drop down menu in cell F3 cells from A35:D39 are filled yellow, and if "no"...
-
setting up Excel to pick numbers for my list Closed
Hello, I would like to use Excel program to pick 6 numbers for a list i have. can ths be done? Thanks Configuration: Windows Vista Internet Explo...
-
Open Excel document from desktop Closed
Hello, When I right click the mouse on the desktop, I am unable to open the excel document from the shortcut menu. The excel document does not sh...
-
Macro to create files based on the contents Closed
Hello, I want to create a macro which creates files based on contents in column AJ. I want the macro to copy the data from original sheet to the re...
-
Excel Date Format Closed
Hello, I receive a report that has the date displayed as just numbers. Example: 20120131 How can I change the data to read: 01/31/2012 ...
-
Macros in Excel so it copies onto next row Closed
Hello, I'm trying to copy values from one sheet to the other in excel via use of a macro. The data is in rows, and is there anyway that I can progr...
-
Excel help Closed
Hello, I have a sales performance sheet where I always update the sale. There is a column for the overall average sales where I need to upd...
-
Excel: Replacing a Range with another Range Closed
Hello, I am trying to create a drop down menu with 12 options in it that will replace a range of data with another range of data based on what you...
-
Macro: Insert blank row variable n times Closed
Hello, I am building a University Timetable. Each subject we offer occupies one row on an excel spreadsheet, we have about 200 subjects in total. ...
-
both rows and columns lookup Closed
Hello, Can anyone please help me on how to set up a formula for both rows and column lookup? here's an example Fruit Price1 Price2 Apples 0.69 0...
-
Excel 2007 Dropdown list from multiple column Closed
Hello, I hope all is well. I am back again with some questions and would appreciate any ideas/tips you may have. I am trying to create a dro...
-
Excel - Calculating # of people per job title Closed
Hello, I have a list of employees and all of the pay types that have been paid to them over the year, and their job title. i.e. Joe s ...
-
Need help creating a macro Closed
Hello, So here's what I have.... 7+ files with multiple contracts created in excel. Each contract contains many different fields of informatio...
-
excel conversion Closed
Hello, Need assistance setting up a formula to change this format yyyymmdd to mm/dd/yyyy. Is there someone who can provide step by step instruction...
-
Excel Formula to auto move & populate field Closed
Hello, I am builidng a spreadsheet that shows progress week by week on two sheets. Weekly Status and Project summary sheets. I am building it so...
-
Excel Help ASAP - New PC at Work Closed
Hello, Hi there, I jsut got a new PC at work and although I have my date coloumns formatted to dd-mmm-yy, when I try to key 7-31, instead the ...
-
macro to compare two excel sheets Solved/Closed
Hello, I need help to write macro to compare two sheets, sheet1 and sheet2 on same excel book and display the result on the third sheet. The ...
-
Help in Excel Closed
Hello, How to update the cell automatically? Eg: If the cell N32 assume the figure is 250 on 23/07/2012, then the cell N33, should be =...
-
Excel Help Solved/Closed
Hello, I have a schedule for the employees, and it contains seven columns as 7 days in a week. If any range of the columns contains text " ...
-
Same values in different cells in row Closed
Hello, Sub: Auto fill of Same value in different cells in a row using Macro button Hi frnds, Can anybody tel me how to auto fill of same value i...
-
Help required to create autofill macro in row Closed
Hello, Sub:Auto fill of Same value in different cells in a row using Macro button Hi frnds, Can anybody tel me how to auto fill of same value in...
-
excel - compare 2 files Closed
Hello, here's my scenario: I want to compare 2 columns from 2 different excel (2003) files which contain similar data, e.g. file1 column1 1....
-
Excel: Comparing two columns and output data Solved/Closed
Hello, I'm using Excel 2007 and am trying to figure out a way to analyze and sort some data. I have two sets of data in 6 and 5 columns in the sa...
