The discussions
Tatadocomo isp username and password
Namaste, I can't acess to the intenet using my nokia 5230 and tatadocomo sim i have my GPRS pack and ins...
Address of searched element
SolvedHello, hi help me pls... my question is --- A----- B---- c 1 as 2 ad 3 sd 4 dg 5 ki 6 we 7 rt 8 ty 9 ru my questio...
Using text in 2 fields in a formula
SolvedHello, Those who read and attempt to think about the following, I definately do appreciate you taking your valuable time to help me out. I want...
Currency convert
Dear Sir, I want to conver numaric to word in below mention formate: Example Amount - 821572.00 Convert Result - RUPEES EIGHT LAKHS TWENTY...
Lost of my data
Hello, Configuration: Windows XP / Safari 535.11 i have lost my office data from my computer pls help me to find that
Excel copy rows based on boolean?
Hello Everyone, I've been using these forums for quite some time but I am completely stuck, so this is my first post. I'm currently attempting to Co...
Date in text/words in ms excel
Hello, Dear sir can you pls help me on 01/01/1992 - in words "One January Nineteen Ninety Two" in ms excel pls provide VBA for this Configur...
Assistance needed in excel 2010
Hello, Would it be possible for someone to help me with a vba problem in Excel 2010? In cell B35 I'm using the =TODAY() function and in C35 there ...
Find and replace a word in a string
Hello, I am looking for code where I can find and replace a word in a given connection string. e.g. cell A1 contains "int_dog int (10)" and i...
Ms office registration after formatting sys
Hello, I hav purchased dell inspiron laptop an year ago.. they gave me MS Office preinstalled on the laptop.. i hav formatted the system... m usin...
Time recording on excel
Hello, How can I have a code so that an employee just types his Employee # in let's say cell K1 and hit enter, so it will trigger the necessary inpu...
Ms access - count records on a subform
Hello, I need help writing the code for counting the number of records on a subform. Subform = FrmSecTable Mainform = MForm Textbox = Txtcoun...
Microsoft excel 2010
Hello, Hey can anyone tell me how to get data out of a cell into a macro. What I'm trying to do is get data of the internet by just clicking on a ...
Please help with date logic problem
Hello, I would truly be most greatful for help to calculate a potential cash outlay for my employees depandants schools books using three date v...
Remove password excel 2007
Hello, hi dear i give help remove password excel 2007 file tanks Configuration: Windows 7 / Internet Explorer 8.0
Need an excel formula
Hello, I'm likely having trouble finding a formula for this because I can't articulate properly what I want but here goes... I have two worksheets ...
Macro to copy data from 1 wrksheet to another
Hello, Here is my situation. I have a workbook that has two sheets. The first sheet returns a set of cell values based on a link to an external da...
Move rows from multiple sheets to new sheets
Hello, I have little experience with Macros and need some help. I have multiple worksheets each labeled with different weeks (i.e. "AUG 29 - SEP 3...
Macro query
Hello, I want to make a macro usable as follows: If I enter a value in a cell, then cursor should go to a certain sheet or the sheet having the...
Using excel to create a password
Hello, I am looking for a way to use Excel to create a password of the same length and type from a serial number. Example: Serial # 45ABZW2BLS to ...
Excel: copy cells under if statement
Hi everyone, I'd like to copy a range of cells (year1, year2, year3,...) from worksheet years to worksheet customers if the cell name has the same...
Vba macro to compare two worksheets
Hello, I'm looking for some quick VBA code that will compare 2 worksheets (say sheet1 and sheet2) and copy the changes of sheet2 into the corres...
Need help how to loop-counter
Hello, I have 2 CSV workbooks called "Bad Lots Plus" & "Good Lots Plus". Each CSV workbook has only 1 sheet named "Bad 123 Plus" & "Good 123 Plus"...
Mass spectrum for successful drawing in excel
Dear friends. Please, does someone can help me concerning this issue resolving? I need a macro for solve a mass spectroscopy problem (mass spectrum)....
Copying macro
Hi guys, I'm new to macros and I need your help. I've got an excel file called "DATA.xlsm" and I need to copy some cells from another excel file, wh...
How to copy a range of cells.
Hello, How to copy a range of cells from One excel file to another excel file. Ex: In file A, I want to copy the Cells from The Column C4 to t...
Help on dcount function in access
Hi Guys, Need help with the following DCount function: =DCount("[Postcode]","[STable]","[Postode] Like'BT") It has to be entered into the con...
Change date format in excel from ms word
Hello, please let me know how can i change date format in dd/mm/yyyy my date in ms word format now i want to change data in excel. regards Ayaz M...
Create a txt file and name it thru macro
Hello, I am trying to copy content of a worksheet to a text file. What i want to know is how can i name the text file based on a given string in a p...
Unable to copy data from spreadsheet into ano
Hello, I am unable to copy data from one spreadsheet to another. I can do it without filtering the data, but i need to filter in order to get the ...
Auto sheet date change
Hello, I got 31 spreadsheets one for each day of the month named 1Jun10-30Jun10.Is there a way of changing these dates automatically to say 1Jul10-3...
How to search for the content of a cell
Hello, I get sent a stock list by my drop shipper every day, the excel file contains around 6,700 unique product codes, and their stock quantities...
Excel show formulas with numbers
Hello, I have a problem with making Excel write the formula with actual numbers. This is the text I want to get: A=1 B=3 C=A+B=1+3=4 In the t...
Copy from master to different sheets
Hello, I am slowly making my way through macros, but can't seem to find the answer to the following:- I have a master sheet - which is a budget...
Change the date of weekends in excel 2007
Hello, just want to ask how to change the date of weekends in excel 2007. please help. thanks! Configuration: Windows XP / Internet Explorer...
Excel macro help needed to name ranges
SolvedHello, I have a 10 column x 500 row spreadsheet A1:J500 I would like to name ranges as follows: Range A1:J1 should be named with the content of...
Conditional display of existing data
SolvedHello, Configuration: Windows XP / Firefox 11.0 I am trying to find a way to perform the following without Macro but met with much difficul...
Need to copy rows based on values entered
Hello, I need help with a formula or macro. My situation is this: I have one sheet of data (Sheet1) with unique values (item numbers) in Column A...
Excel related
SolvedHello, could you please tell me how I get excel to automatically use a color in a cell that I write something into? The blank ones can remain colo...
Excel formulas
Hello, I have a spreadsheet called 'TRADE' as follows: Column: A B C Sept 200 1000 ...
Macro to create worksheets
SolvedHello, I'm Mike, I'm new to Macro excel I need a Macro that read from a table the name of projects and create for each project a sheet named th...
Forgot memory card password
Hello, my mobile memory card is lock,ask me pass ward.i do't know pass ward,how i will open my memory card, please give me solution.thanks Co...
In excel 2010 modify the pasted value to link
ClosedHello, Configuration: Windows 7 / Firefox 11.0 Office 2010 Excel I often need to record UPS tracking numbers into designated fields in Exce...
Cannot browse, but ping and hotmail working.
Hello, I have the same problem on my browsers, ie has encountered a problem and need to close. Sorry for the inconvenience. error signa...
Copy the data using function
Hello, I want to copy the data from a1 to b5 at a10 to b15. How can i copy that using function bcoz I have to paste that data many time in a Shee...
Create coded list in excel
Hello my most humble computer users, I have a hard one here...And I think it will be harder to explane... I have an excel file that has a several ...
Help! compare 2 cells then copy to next cell
Hello, I need help copying the names from the master cell (A), if the other cell's (B) given names exist from the master cell, then copy to next c...
Outlook automatically changes outgoing smtp
ClosedHello, My outgoing smtp setting is changing automatically everytime i shut down my computer and reboot. I have it set at 587 but it changes to a ...
Comparing data across dozens of worksheets
Hello, So we track sales on a weekly basis and I want to compare the text in column C to all previous weeks and if they match to turn them red to ...
How to make 2 vba codes to work correctly
SolvedHello, How can I correct the following 2 codes (which written in the same sheet) in order to work correctly, other wise it gives me Error (debug)?...
