The discussions
Cells filling by array
Hello, i have a problem in Excel 2007 in VBA. I have this code (part): Dim Oblast As Range Set Oblast = Worksheets(2).Range("H1:H" & Pora...
With excel had a report writer
Hello, I have a spreadsheet with student names, each student is assigned to one of 4 teachers. Student name in A, teacher name in B other data in the...
Using formula to pull data out of worksheet
Hello, I'd like to pull 4 numbers out of a list of URLS in a spreadsheet. The 4 numbers will always be in the same place at the end of the URL. I need...
Save worksheets as seperate files
Hello, I want to save the sheets in a work book as seperate files. Also these files should have one of the vba module from the parent workbook U...
Returning text from one of several columns
Hello, I currently have IF Formulas in 3 columns across the page. The formulas return a blank ("") in 2 of the 3 cells in each row. I want to have ...
Excel: getting numbers from cells
Hi everyone, I'm looking for some Excel function help. I have some cells that have both numbers and text in them. I'd like to take the first few nu...
Refresh colour in conditional formating excel
Hello, I have used the below vba code to format a drop down cell based on whether its pass or fail or block in excel(2000) 'START OF CODE Private...
Add macros
Hello, I already have few macros in Excel,how can i add a new macro in Excel.By adding new macro will it effect the old macro's which is already th...
Excel macro to create a chart
Hello, I have recorded the Excel macro 'ChartTestMacro2' below, that creatats a chart from the Sheet "MacroTestSheet". I have been unsucessful in ...
Free browsing
Hello, pls who will help me send me a free browsing soft ware to my phone or how to configure my nokia 2600c for free browsing
Excel formula
Hello, i have one excel sheet, the first sheet has master data with various inputs like No,remarks 1,hello 2, hai 3, bye 4, good 5, bad...
Execl - copy forumlas to multiple worksheets
Hello, I am having trouble copying formulas to multiple worksheets. On the sheet name tab, I click "select all sheets" then I type in my formula...
Lookup matching names in multiple columns
Hello, I found this site on a google search. Thanks in advance for any help that could possibly be provided. I'm an IT PM. I currently have spre...
Excel percentage averages
Hello, I have two columns of info, 1st column is of purchases and 2nd is of received values. Each Row is of a different site and I calculate the perc...
Macro search and display
Hello, How do i search a spreadsheet to find a date equal to todays date, then copy values in column B and column C and paste in another Worksheet....
Excell average function problem
Hello, i have a row with 7 cell. 4 cells contain numbers, and 3 letter x. how to calculate average for the cell that do not contain letter x. thanks...
Copy partial rows based on value
Hello, I'm hoping someine can help me... I'm new to visual basic and I'm looking for a code to take the data from an excel spreadsheet, sheet 1 a...
Adding data from other worksheets into one
Hello, I am having aproblem loading a bunch of data from other worksheets into one worksheet (sheet1) in Excel. I have been trying to use the code: ...
Ms excel: copying condionally formated cells
Hello, I have a conditional format where if a cell in a row has a specific value, it will set the format to highlight the whole row. I would like ...
Excel calculate hra cca da only
Hello, i have a worksheet with the following column a b c d e f g s....
Excel 2003 spreadsheet matching
Hello, I am trying, without much luck, to Match two values on seperate worksheets on excel 2003 so that values on one sheet will be matched and tra...
Matching names in different excel sheets
Hello, I have two excel sheets with names which I would like to match (some have more names than others). Can you give me a formula to do this?
Run excel workbook and macro automatically
Hello, i got a workbook with alot of macros in it. i need to open the workbook automatically every nite at 12 and run a particular macro and then c...
Use sendkeys in save as macro
Hello, i've written a macro to copy the "temp" sheet of a workbook to a new workbook and then save tht workbook to an existing file. i get the "do ...
Vba code string with more then 912 characters
Hello, I have created a VBA code with a string of character exceeding the number of 912, thus getting the error 1004. The code looks like this: ...
Excel sum if based on day (with duplicates)
Hello, My question is in regard to Microsoft Excel 2003. I track my finances and one of the issues I've run into is I have a table, in Column A the...
Uninstalling kis 7.0.0.125 breaks browsers
Hello! I have a huge problem I just can't seem to solve! I used to have a trial Kaspersky Internet Security 7.0.0.125 Recently, the trial period ...
Excel cell value count
I have questions Can Cell determined by delimeter ? I want to count the cell values how many 111 occurs ? pls refer the below example ColumA ...
Convert rows to columns in excel
ClosedHello, I just need to create a simple macro or VB Script to convert Rows of data into Columns where the break is a blank line between rows.
Macro for date difference
Hello, I am using A1-Today() to see the difference between the value and today date however i am geeting the value as #NAME? what is t...
Free browsing
Hello, Hello, I'll be very grateful to anyone that'll explicitely inform me on how to connect my nokia e51 to my laptop to browse free. My contacts ...
Browsing
Hello, please how do i connect my phone with my destop to be browsing
Compare data between 2 sheets with unique fie
Hello, I am working in Excel 2008 for Mac. I am working in 2 sheets and in sheet one I have a persons ID number along with first name, last nam...
Compare two blank cells
Hello, I'm trying to produce the spreadsheet that would compare any type of information that look identical. For example you put two databases in ...
Excel formule
Hello, I'am trying to make a template schedule in excel that can show me at what time I have gaps in the schedule and at what times I have over 3 pe...
Macro help
Hello, I am trying to build a super household budget for myself and my roommates. Specifically, I would like the spreadsheet to be able to go online ...
Excel spaces
Hello, I have lot data in excel in some of the cells user has done alt enter instead of enter i have used the following macro which is not workin...
Excel vba help needed
Hi folks, Recently started working on vba's and am a new user in this forum. I need help with 3 issues I have in a vba and if possible ASAP. 1. Del...
Unable to browse
Hello, i dnt no how to log in with my sony ericsson k610im help me on how to login so i ll be able to browse
Macro to filter copy and paste to another wor
Hello, I am a novice in macros. I am trying to create a macro that finds a number in one workbook then goes to another workbook, filters the dat...
How to change the date format in excel 2007
Hello, how I can chnage the format of 15.02.2003 to 2/15/2003 in excel 2007. Give the exact route.
One range, multiple sheets
Hey guys I'd like to know how i can add 3 different sheets into one range. For example, i have the =sumif(range, How can i fit info from shee...
How do i browse free on my laptop
Hello, pls how can i browse free on my laptop help plsits urgent
Pickup value in excel cell
Hello, someone advise me the excel questions :- would like to pickup highest value from column A to C and and put result in column D e.g. A, ...
I have problem in excel_sheet when using i eq
Hello, when i have convereted number of bottles in bottle/case , i haven't get proper result, so pls give me your guidance thanks with regard...
Excel macro to highlight related cells
Hello, I have a worksheet for managing all documentation at our place. I was trying to come up with a macro or a solution wherein I can group the ...
I want to brows from my wifi connection
Hello, sir i am using windows vista operating system. I am surfing mainly from wifi connection and i am not getting sites like orkut, etc... because...
My browser wont use adobe flash player
Hello, i have two browsers : internet explorer 8 and firefox . few days ago , there was no connection at all , but later it fixed itself . but i real...
Linking value from one excel file to another
Hello, I have a small business (small convenience store) and wants to use excel to keep track of my sales and inventory on a daily basis. I made a si...
Change data from sheet1 to sheet2 by formula
Hello, how to change data from sheet1 to sheet2 by formula Eg : Sheet1 A B C 1 5 4 =A1+B1 2 1 5 =A2+B2 ...
