The discussions
Autorun a macro in excel based on sheet name
Hello, I use the personal.xls which has many macros incorporated into it with shortcut names. The application I use that opens Excel names the sh...
Pdf attachment cant open in outlook2007
Hello, i cant open pdf attachment throw my outlook2007 but i can open same pdf attachment throw my iphone plz help me give solution.. Confi...
Formulas not copying from worksheet to sheet
Hi There, my excel has been doing some funny things lately. 1. When I copy a formula from one worksheet to another, the actual formula does not ...
Create inquiry for quotation
SolvedHello, I'm Mike, I'm a mechanical engineer, in my company we send inquiries for quotations. I have two Excel file the first is a table where all t...
Copy & paste data upon click
SolvedHello, Good day. I need some advices on how to copy and paste data upon mouse click. I have a set of data on A2 to A10. When I hit cell B1 wh...
Problem in my excel sheet please help me out
Hello, i hav poblem like... i hav code numbers for example.in coloum "B" if i enter dat code number i should get the name of the person or a deale...
Excel formula
Hello, I have a 2 colunm set of info on Sheet 3 in a spreadsheet (Column A numbers listed 1-600, and column B corresponding figures per number) wh...
Converting & then copying date format
SolvedHello, I wonder if anyone can help? I have a spreadsheet with over 40k records which have the date format & time format like this: 02/01/2003 09...
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...
