The discussions
Saving papers
SolvedHello Everyone, I hope someone could help... I have list of Check Numbers on Column A and Their Amount on Column B and it runs on almost a ...
Excel 2003 days before a certain date
SolvedHello, I am making a spreadsheet which has, for example, a given date of 1/1/2012. When I enter that number into cells A1, I want it to return ...
Excel 2010 formating / sumation issues
Hi I've got an Excel 2010 issue and I can't seem to find the answer any where. I'm generating a spread sheet from a C# application which displays...
Add range if number is 1 to 10, 11-21,22-30 ...and so
SolvedHi , I am new to this forum. Looking for small help.. if 1 to 10 is in column A i want to add the numbers which are column B. A B 1 34...
Insert line number for two columns document
Solved/ClosedHello, I have a problem to do a process of line numbering in MS Office 2007 Word Document. I have a document, it has 2 columns and I have to inser...
Copy data to master sheet, when >0
Hello, Is there anyone who can help me with this? I cannot for the life of me figure this out and need this spreadsheet working asap for my boss. ...
How to supplement this macro?
Hi Guys, I was advised the below macro which works wonderfully, searches for the desired cells from one column and copies them to where I want. I w...
Create drop down list on certain cells
SolvedGood day, I wanted to create a drop down list from data in Sheet2. I have tried the following codes but the outcome seems to be incorrect. Instead...
Word 2003 safe mode
Hello,When I start Word 2003 I get a message that word has to check for a fix and shutdown. After it shuts down I satart again and it asks if I wan...
Acrobat reader
SolvedHello, pls send me acrobat software. Configuration: Windows XP / Internet Explorer 6.0
Date format in excel.
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...
Copy dynamic data, fill in
Hello, Is there anyone who can help me with this? I cannot figure it out and need this spreadsheet working asap for my boss and salesreps. I've ...
How to filter dates
Hi! When I use advanced filter for dates, I can easily set the filter for example to show the dates after or before a certain year. But how can I ...
Macro for finding dates
SolvedHi 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...
Conditional drop down list
Hello, I'm creating a spreadsheet that will allow workers to fill in their time and activity. This will be imported into MYOB. I need to have a...
Please provide the key for microsoft office p
SolvedHello, Please provide the key for Microsoft Office Publisher 2010 Configuration: Windows 7 / Chrome 20.0.1123.4
Excel & power point macros
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
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
SolvedHello, 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...
SolvedHello 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...
How to make pivot table exactly in original
Hello, How to make pivot table like same as original sheet Like same column and same row Regards Windows 7 / Chrome 15.0.854.0
Macro to compare worksheets, highlight change
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...
Vlookup
SolvedHello guys, I wonder if you could advise: when I set my regular vlookup. And have found the requested result. How do I get excel to keep searching...
Auto extend of range in excel macro
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 ...
Ms office project 2007
Hello, Could I have the 25 character key for MS Office 2007? I downloaded the software but can not operate it with out the key. Configuration: ...
How to find mismatches
Hello, My questions is this. I have two columns of names in an excel sheet.One column with a longer list of people and another relatively less.Sma...
Vba code
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 ...
Vlookup auto-update from another file
Hello, I have this formula here: =IFERROR(VLOOKUP(T15,INDIRECT(CONCATENATE("'C:\Documents and Settings\[",$C$7,".xls]",$C$6,"'!$E$3:$S$200")),...
Separating items from columns
SolvedHello 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...
Sum # in column only if cell contain text
SolvedHello, e.g. I am trying to sum up the row of number when a cell in the same row contains text "Ball" [Column A] Red Ball Blue Ball C...
Comparing channel list
Hello, I have a full channel list for my area with channel names and channel #s, and than I have a channel list of what I receive in my package wi...
Count unique entries with conditions
Hello, I have a problem that I have pondering for a while now. I would need to count the number of unique entries in my data with some pre-determi...
Largest adjacent sum of integers
Hello, how to return the largest adjacent sum of an array of integers? example : int a[]={1,2,4,5}; return 9 because 1+2=3 and 4...
Sumif excel function - multiple conditions
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
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
SolvedHello, 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...
Cant space my words
Hello, I have an HP laptop which was working fine until today For some reason I cannot space my words When I use the spacebar to space the words th...
Sd card password
Hello, I have forgotten my SD card password. Pl help me to recover thro my Nokia x3 mobile. Thanks & regards. Configuration: Windows 7 /...
Spell number
SolvedHello, I would like to convert a number into words using rupees and cents in excel 2007. Please help. Configuration: Windows XP / Internet E...
Macro question
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 ?
SolvedHello, 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
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
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...
Match partial texts with multiple returns
Hello, I have 2 sets of information: 1 simple list of Company Names ( Data-A ) 1 array of data including another list of company names ( Data...
Coniditional formatting
Hello, I am trying to write a code that will scan input dates and compare them with dates in the cell next to them. If the dates input are farth...
Large col. based data to be changed to rows
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
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?
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
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...
