The discussions
Seach for all worksheet and copy the name
SolvedHello, I'm trying to see if anyone can help me with this, I do have a master excel file that get info from other excel files, currently I have to d...
Excel list of names
Hello, I need to type a list of names that I would like to automatically show up in a few other areas of an excel spreadsheet? Is there a way to...
Excel-transfer from sheet1 to sheet2
Hello, I am using Sheet one as a list of materials I have ordered for our company. Once a material arrives, I change the "Status" column from "Ope...
Excell macro to calculate date differences
Hello, I have a date string in following format: October 1, 2010 8:00:00 AM GMT+03:00 I need to calculate time difference in days between 2 dates ...
Convert data file to ar system
Hello, Gravyrice - Sep 22, 2011 7:05pm BST Need help please. I am converting a Accounts receivable customers date file to our data format for o...
Ms excel 2007 - quick function question
SolvedHi Guys, So say you have 3 cells. A, B, and C. I'm trying to come up with a function to put in C that erases/blanks A if B is #N/A (IsError?). Can ...
Need links to copy over with new spreadsheet
Hello, I have several spreadsheets that are linked to one main spreadsheet, these spreadsheets are saved and a copy is created every month, how can ...
Auto filter depends in a combox value
Hi, I'm wondering if anyone knows some formula to filter data depend in combo box value. My spreadsheet has a column with the order status whic...
Save outlook express folders to my documents
ClosedHello, Well I really don't have a problem with the system...it's just me. I don't know how to save my outlook express emails (sent and received)...
Reset system authentication password
ClosedHello, i am working on a dell inspirion 1150 laptop a friend of mine bought at a swap meet the person he bought it from did not give him the system ...
How do i use a macro to do this?
Hello, I am trying to set up a macro to use in a program where for example. If a value of 1 or 1st place then the value of 6 would be appointed t...
Password remover
Hello, Hello!. How can I remove a Micro sd memory card password in my phone Nokia 5130c-2 ? My micro sd memory card is 1 Gb Transcent. Please ...
Outlook only sends emails on work network
Hello, My work email (@mydomain.com) only sends emails while I'm in work and not when I'm connected to my home network. They will just sit in my o...
How to run 2 macros when worksheet is updated
Hello, I am a total newbie in this and I would really appreaciate your help. I am trying to make macro for counting of cells of same colour in a she...
Vba macro, next not working
Hello, I would really appreciate some help please. I am attempting to - copy an entire row of data from sheet 1 to a new blank row in sheet 2 - w...
Transfering row data - sheet 1 to 2
Hello, Im new to this macro stuff. Currently I have a file where on the first sheet I have multiple data and that data needs to be transfered to di...
Search a word in the column
Hello, In Excel sheet,i wanted to Search a word in the column if it founds in the excel sheet then it should update word as "exempt" in the adja...
Vba - copy range # of times value is in colum
Hello, I am looking for VBA code to copy/paste a range the same # of times a value (Department Code) appears in Column A. So, if Department 123...
I have forgoten password of my samsung i900
SolvedHello, i have forgoten password of my samsung omnia i900. it is a windows mobile6.1 .please help me. please help me to open it .. god may help ...
Extract data from specific cells in excel??
Hello, I am trying to copy specific cells from excel and dump into a worksheet. The macro would open, read those specific cells and dumb the cel...
Vb, how to pull exact information from header
Hello, I have a few questions: 1. How do I extract information from DAT & CSV files without opening the file and copy to a excel 2007 wo...
Ms access format for a query
Hello, Thanks in advance for helping!! I need to know how to add a format to a IIF query: I know how to do it for a simply IIF: Expr:Format(...
Complicated table question.
SolvedHello, I have just started a new job and i was asked to do the following. Please help me as I dont know how to do it. System ID Clien...
Copy and paste certain columns based on dates
SolvedHello, I am trying to create a macro that will look at a list of dates in column B then copy and paste the data in column C and D to another sheet...
Compare two columns in excel 2010
Hello, Configuration: Windows 7 / Safari 535.1 I need to compare two columns say column A in worksheet1 with column A in worksheet2, colu...
Password recovery
ClosedHello, hi iam mounika i cannot open my mobile since i forgot my phone password so please tell me the solution for it Configuration: Windows 7 ...
Excel sorting
Hello, I'm an Excel novice and I need to sort a list of email addresses on the company name or everything that appears after the @ sign. How do I...
I installed my new office professional plus a
Hello, I installed my new office professional plus and it says it completed setup and to restart did all of that Problem: I don't have any ic...
Searching for a word in table
SolvedHello, In excel, I have 5 columns of words (5 undividual word lists) and a row at the top that gives information on that word list. I want to use a ...
Extracting required words.
can someone tell me, how to find a particular word in a line, i will tell one sample question. in cell it is given as a1-sky is blue in color, in c...
Copy data from one excel sheet based on type
Hello, I have a scenario where there is a main worksheet in the workbook which contains information in the below format Item code Ite...
Change operating systems no password
Hello, i found my kids old sony vasio,its updated with 2000 pro.noneof us remember the password???i want to change operating systems??or just chang...
Mobile tracker password forgot
Solved/ClosedHello, i reset the mobile tracker password and forgot the password, I kindly request you to suggest me a solution to reset the password for the Samsu...
Required some common characters in cell
ClosedDear all, I have following data in excel like this...... /OCEAN FRIGHT CHARGES INV NO 7428117730 / OCEAN FRIGHT CHARGES INV NO. 7428116244 / O...
Outlook 2007 get hung up in the outbox
Hello, I use verizon fios and when sending emails they get hung up in the out box and do not go anywhere. Maybe the next day when I power up the...
Make an excel sheet
Hello, I HAVE TO MAKE A EXCEL SHEET LIKE THE ATTACHED ONE.HERE Cellular Accessories,Cellular Activations AND Performance Metrix Summary ARE THREE ...
Delete old information from excel 2003, vba
Hello, My appreciation in advance for any responses to this. I have a sheet which measures certain things on a daily basis, there is a "Sat", "...
Vba or change settings for "picture format "
Dears, If any one can help me either by changing some settings or through VBA code. The case: I have excel workbook including 100 worksheets fo...
Transfer a range of cell contents wb1 to wb2
Hello, I need to transfer a range of cells example f81 to 081 from one excel sheet to another excel sheet - how is this done. I formerly used Lotu...
Excel: exporting rows that meet criteria
Hello, I'm new to this forum and also to macros so please excuse any technical slip-ups. Thanks in advance for help! I currently have two Excel wo...
Searching text in excel using macro
Hello i want to search words in excel using macros. i have two sheets(sheet1 and sheet2). i have a column,say E, which has 50 text rows. i need ...
Access 2010 - table with same fileds and rows
Hello evryone, need your kind help with the below, i'm using Access 2010 and i created a main form , from which i want to let users to open new ...
Compare 2 excel sheet and combine uniq data
ClosedHello, I have 2 excel sheets , A and B. There are redundant data in both sheets as well as uniq. All I want is to combine both with no redundant ...
Auto filter depend in droplist value
SolvedHello, I'm wondering if anyone knows some formula to filter data depend in dropdown list My spreadsheet has a column with the order status ...
Need help figuring out a formula or macro
Hello, I need some kind of formula or macro that can do the following: If the exact value of a cell in column C is found anywhere in column A, ...
Password code for q1i
Hello, Configuration: Windows Vista / Safari 535.1 How can i put a password on my Cherry mobile Q1i? Please response. Thanks.
Logging into outlook from other places
ClosedHello, I would like to be able to access my outlook account at work through my mac at home without downloading all messages to my home mac. Can I...
Submit button macro
Hello, I need a macro that will be assigned to a "Submit" button that will move data from Column H on my "Data_Entry" sheet to a different column ...
Windows vista hangs after password input
Hello, Help! I have a toshiba laptop that has died on us! not sure if it is a software issue? Runs Vista home edition, after first password ...
In excel formula i need to use dynamic range
ClosedHello, I need to use dynamic range for excel formula for example If condition is unmatched from next step I need to terminate the counting & start ...
