The discussions
Copy linked fields in excel spreadsheets
Hello, I have two excel spreadsheets, that have invoice number as a common field. In sheet A, the the invoice number might repeat in 5-10 rows, on...
Vba code: copying rows from multiple sheets
Hello, I'm trying to use VBA to copy rows that satisfy a certain 'If-Then' statement from multiple sheets in Excel onto one sheet. All of the sheets...
Excel.i want to count the number of persons in given 3 condition
Hello, i am making result sheet where 60 students obtained different marks out of 500 marks now i want to count the number of students in 3 differe...
Forgot password
Solved/ClosedHello, I am alin i have been using kaksoft folder lock protect the folder...but i could not use the folder so that i forgot the password so how wi...
How to copy/paste a file from external file into a worksheet..
I have a problem of copying excel into new file. I have a browser which takes an excel file and puts it into a text-box. Then I have a second but...
Comparing two columns of names in excel
Hello, I need some help with an Excel formula. I have a column of user names and a column of usernames intermixed with non-user names. I would lik...
07 wb opened w/ 03 and it reopens after close
Hello, Well, I am back after my short-lived exhuberance with my other solution. I now have a problem with some of the users that have Excel 2003. ...
Mirroring data from multiple sheets into one summary sheet
Hello, I have as sheets with data in them, I would like to create a summary sheet in the same workbook such that whenever any of the sheets are upda...
Highlight cells based on drop down list selection
SolvedGood day, I would like to have a row highlighted in color based on the drop down list selection. I have inserted the following in Worksheet but I e...
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...
