Office Software Forum
- Excel (9,727)
- Open Office (111)
- Outlook (635)
- PDF (334)
- PowerPoint (174)
- Word (2,181)
-
Excel Copy Rows Based On Boolean? [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
Hello, hi dear i give help remove password excel 2007 file tanks Configuration: Windows 7 / Internet Explorer 8.0
-
Need an Excel Formula [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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. [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Solved/Closed]
Hello, 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 [Solved/Closed]
Hello, 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 [Closed]
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 [Solved/Closed]
Hello, 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 [Closed]
Hello, I have a spreadsheet called 'TRADE' as follows: Column: A B C Sept 200 1000 ...
-
Macro to create worksheets [Solved/Closed]
Hello, 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 [Closed]
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 [Closed]
Hello, 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. [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
Hello, 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 [Closed]
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 [Solved/Closed]
Hello, 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)?...
-
Macro to Find and Replace [Closed]
Hello, I am trying to create a macro that can Find and Replace a variable value. For example, I want to create a cell that can have any code enter...
-
Formatting colours [Closed]
Hello, Hi everyone - I am looking to show in Excel when a person has worked for me more than 182 days(26 weeks) Ie; Start date ...
-
password forgot plz reset my password [Solved/Closed]
Hello, i have nokia 5130.my brother change password of my memory card.now he don't know password.now my memory card is locked.what i have to do...
-
delete all the rows in a spreadsheet except [Closed]
Hello, I have a simple question. How to delete all the rows in a spreadsheet except the first 6 rows by macro. Please reply me with an exact code...
-
reinstall ms office on mac [Closed]
Hello, Had to reinstall lion operating system on mac and now will need to reinstall ms office; is the license tied to the computer or the number of ...
