The discussions
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)?...
Macro to find and replace
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
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
SolvedHello, 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
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
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 ...
Auto-copy of select rows to another worksheet
SolvedHello, This is my first time asking a question, so I will do my absolute best to follow and respect the forum guidelines and it's contributors. I...
Formula for database
ClosedHello, Hi, I have a database of CPT codes with procedures. Column A is CPT code, column b is the matching procedure. In column c i want a formula ...
Find values based on colum and sum in a table
ClosedHello, Configuration: Windows XP / Firefox 10.0.2 I have an Excel spreadsheet where I pull in data from another source into columns A1-BS. I t...
I forgot my password (samsung e1120)
SolvedHello, i for my password I wish you could help me Configuration: Windows XP / Firefox 10.0.2
I have no sounds on my browser and windowsmp
Hello! I lost the sounds ONLY on my browser. Alongside this soundlessness in my browser, whenever I open a file associated with Windows Media Player I...
Correcting vba code in excel
SolvedHello dears, I have the following VBA code : Private Sub Worksheet_Change(ByVal Target As Range) Dim cRow As Integer If Intersect(Target, Ra...
Copy cells in excel if cell above is null
Hello, Can anyone help? I need to run a script that will determine if a1 is blank, paste the information from a2 into the a1. If a1 is not nul...
Acrobat print,save,send buttons dont work
ClosedHello, when a browser window opens a pdf file the print,save and send buttons are disabled except when using IE browser. What are the settings in I...
Moving rows within excel
Hello, Please, please can anyone help me, how can I move dates from ColumnA (Surname) ie various dates and date formats into the appropriate Date ...
Please help me my password is hacked
Hello, please help me my password is hacked
Moving dates from one row to the end of above
ClosedHello, How can I move dates from ColumnA (Surname) ie various dates and date formats into the appropriate Date 2 and Date 3 columns. I want to mo...
Highlight unique or duplicate on 2 sheets
SolvedHello, I have a Excel file of 2 worksheets and have a list of Usernames on column B of both worksheets. Few of the usernames appear on both sheets...
Word document with fields to be fulfilled
ClosedHello, We try to create a template with fields to be fulfilled. In one of them we would like to insert a formula (subtraction and division) using ...
Mircosoft office help
SolvedHello, i would like to ask , if i change my gmail pw will my microsoft outlook still be able to recieve mails and sent them or they are not able to re...
Excel dynamically fill cell with data
SolvedHello, I have worksheet ( AllUsers ) with two column A ( user id ) and B ( date ). Column A is a long list of user names and B is a list of dates ...
Copy text frm a cell n append it thru macro
SolvedHello, I am trying to create a macro where I want to copy a cell content from one worksheet and append it to a cell in another worksheet of the...
Excel 2010 series question
Hello, I have a question. I have an excel spreadsheet with 25 columns of information. There are anywhere from 3500 to 4000 rows of information. ...
Conditional formatting - value of 2 coloumns
Hello, I have 2 coloumns mith qty bal and min value. i would lile a condition were IF the qty bal is less than the min value, the min value cell i...
Excel problem
Hi I have a slight problem with excel. I have inputted all my data with links on the same worksheet. Now I am trying to separate the different cate...
Search column for text "x" then copy to
Hello, I would like to have a macro to search a column B for text "X". Wherever text "X" is found in that column, I want to copy text "X" and the c...
Column comparation in different datasheet
SolvedHello, Hello, I have one excel column A in datasheet 1 which has a list of names. In Column A of datasheet 2 I have a much longer list of n...
Outlook send/receive error
ClosedHello, I have a situation where two staffs; Judith Acan and Lasu Sabastian can't send nor receive emails between themselves, they can both send/re...
Vba to protect sheet in excel
Hello, I need any help if some one can help me. I make an overtime sheet in excel that allow the employee to fill in the date and time only and i...
[excel] macro on grouping
Hello, I need help on developing a macro on grouping a set of negative amount & quantity against a set of positive amount & quantity. Using positi...
I have forgot my hide folder password
Hello, sir I have install hide folder software but due to some problem I have got my password,, can you guid me please Configuration: Windows X...
Automatic transfer data by row
Hello, I need to automatically transfer data, from a set of three spreadsheets - one row at a time - if a specific column contains a specif...
Conditional formating
Hello, I am trying to conditional fomat a cell based on the results of two cells. If the fist cell has the word standard, and the other cell is >3...
Using vba code: add borders if conditions met
Hello, I am at the very beginning stages of trying to learn VBA in Excel 2007. I am trying to merge some cells in the next row, and I would...
Vba copy/paste cells then drop 1 row for next
SolvedHello, I am making a questionaire. When the questionaire is complete I want to copy the answers to another worksheet then reset the answers to zero...
Calculations date & time in excel
ClosedHello, I used office 2003. In excell 2003 i formatted cells to dd hh:mm from dd/mm/yy hh:mm, in order to do calculations and it was ok. Now i...
Textbox on excel uerform problem
ClosedI have a userform with several textboxes on it. The info that is typed into the textbox is copied into a cell in a spreadsheet where it is used to per...
Page numbers in ms word proposal template
Hello, I'm using Word 2007, and downloaded a MS Word Proposal Template from a Microsoft website. I've entered my data, but now I cannot insert...
Microsoft excel 2010
Hello, I would like to figure out how to get a web address that I use to get data from the internet to always use the date that I put in cell A1. Any...
Excel formula help please
Hello, I have only worked with formulas when working with numbers but I need to know what formula I can use. I need a formula to take a column that ...
Inventory to purchase order
Hello, I have never ran a macro in Excel but did exactly this in Quatro Pro. . .I'd like to use a "inventory" tab with item #/Product Description/...
Excel 2007 filter bringing back last row
Hello, When I apply the filter option for a particual item, the last row of the data is being displayed even though it does not match the criteria. ...
Multiple sheet data in one sheet in excel
Hello, Want to copy data from multiple sheet from multiple columns in one workbook can you please help me with that macro as well Pran...
Excel macro - copy data from one line, append
Hello, I have a spread sheet created from a PDF to XLS program. I have lines in which the address appears on two lines, with the extra text fallin...
Bold font in outlook
ClosedHello, While using my PC, suddenly the desktop turned to bold as did all folders and mail in Outlook. I have tried resetting the the DPI size to 9...
