The discussions
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)?...
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...
