The discussions
Calculating from a previous cell if blank
Hello, I'm working on a travel excel spreadsheet that calculates different dates based on time it takes to get to a location and how long you want t...
Macro to import data excel to excel
Hello, Let me preface with the fact that I am using Excel 2003, pretty fluent with Excel in general, but new to the macros and visual basic - alth...
Excel 2003
Hello, In one worbook (Best Price) I have the following data where Coloumn A, Row 1 is a heading (Range Code) and the data starts from A2. Ro...
I forgot my password
Hello, i forgot my password.so i need your help.please give me password... Configuration: Windows 7 / Internet Explorer 8.0
Sharing an excel sheet
Hello, I am looking for a way to share an excel sheet with multiple people. each person given a password to see their specific info only. This is ...
Time tracker
Hello, i am looking for a way to track the break timings of my workers using excel. all of my employees have a system and i want an excel sheet wher...
Spread sheet / macro/ formulas help!
Hello, I would like to create a spreadsheet that has 4 - 5 specific fields where individuals can type in account numbers, names, a drop down where...
Drowing data from one sheet to another
Hello, Need your kind help with this cause i have no idea how to excute this. What i need is to drow data from one table in sheet 2 to the main ...
Why doesn't this simple vb code work?
SolvedHello, What I want to do is the following: When a cell in column AH is selected move to the next sheet and select the cell in column C same row. ...
Hide columns
SolvedHello, I recorded a macro to hide some columns (says, column M to O). However, when I tried to run the macro again, the macro hide all the columns f...
Importing data from 1 excel sheet to another
Hello, I have a program that exports the daily maximum temperature recorded into an excel spread sheet. Column A Row 1 Date Column B Row 1 Tempera...
Forgot my phone password
SolvedHello, i forgot ma phone password......n nw i cant put a new pass word wat sud i do plz help me..... Configuration: Windows 7 / Safari 535.1
How to find a number from the list
SolvedCan u please help me in writing a macro in excel as below: 1) When we click on the command button, it should prompt for entering the number in the ...
Word in a cell, for a number in adjacent
Hello, I am Vinay and I am working on an excel sheet to create a format for purchase order. I am stuck at a point, please help. I want a formu...
Vb code for drop-list menu width
SolvedHello, If any one can help me. In one excel sheet I made list of names and defined that list as "Names", then in another excel sheet in column ...
Hide unhide column with clickbox and password
SolvedHello, All Please can you help, is there a way that you can hide/unhide colmns with a click box, I have the code to group ungroup when the sheet a...
Search, copy and past
Hello, Im quite new to macro in excel. Now i hav 1 project where i need to search for a certain part of the word in a sentence in a cell in a colu...
Combine if statement with validation list
Hello, I have set up a spreadsheet with a data validation list in cell A1 Option_1 Option_2 If Option_1 is chosen I want cell B1 to retur...
Copying a row based on part of a field
SolvedHello, I am trying to get an excel macro to do a search of Sheet1 that will go through each row in column E and copy any row that contains a X or ...
Conditionalformating: if cell a1 = 0% to 50%
SolvedHello, Hope someone can help? I want to format a cell that changes % from a formula. A1= 0-50% format B1 to green, and if A1= 50-100% format...
Ms power point problems
ClosedHello, i have saved my ppt in my documents but after restart the system it did not show my saved file, what i have to do? Configuration: Wind...
Transfer of excel data from a row to another
SolvedHello, I have this excel sheet with numerous rows having columns A,B,C,D &E.column A is numbers & other columns hav data in text.I want to transfer...
Excel
ClosedHello, I was wondering if anybody knew how to take a list of tasks, associate a number with each task, and then be able to put the number in a cell ...
Macro for copying and replacing data
Hello, I'm looking for the best way, which I am assuming is a macro to copy data from one spredsheet to another. The macro must copy all data from...
Vlookup picture
SolvedDear Sir, In $F$8 i have inserted the data validation list Where the name of Pic is to be select. I want to know how to call a picture in excel 200...
Macro to copy and paste
SolvedHello, I would greatly appreciate any assistance with creating an Excel macro that will copy information from cells A1, B11:D11, A13, B23:D23, et...
Comparing five column values in a row
SolvedHi All, I am new to office excel and need your expert help to resolve one issue: I have five columns in different rows with values and I need to...
Split multiple data scans into separate colum
Hello, I'd like to split my data from two columns into multiple columns in order to do averaging. My data looks like this: Mass| Intensity XX ...
Copy a row with condition
Hello, I am doing accounts for a local church. We have almost 400 members with FLY Number and each member is allotted to a Group. I need to sort th...
Drop down list with criteria, please help!
Hello, I have absolutely no idea on how to get the following to work on excel, please help!!! 1. A drop down list is created on Cell 1, with in...
Macro: transpose multiple rows into 1 column
Hello, No previous experience with macros, so any info would be helpful. Suppose I have names in Column A, with 4 scores in B, C, D and E. I wo...
Excel macro help
Hello, I was wondering if it were possible to have a macro that would work for different sheets for having the column be pasted as long as the nam...
Firmnual help if cell is blank go to next ce
Hello, EXCEL FORMULA If cell is not blank automatically look go to next cell (across) and if the cell has text in it the show the text ? I have 35...
Formula help
Hello, I'm trying to create a formula that will list for me in a new set of cells all items in one column that meet the criteria in another colum...
How to pull content from 4 cells to 1 cell
SolvedHello, How can I pull content from 4 cells to I Cell in a specific format so that I have it displayed like this: sm=12.00/W123/F456,MD=13.00/W456/...
Excel 2007 macro
Hello, Could you help me in writing a macro for exporting data from certain cells in sheet 1 to sheet 2. I use Windows 7 and excel 2007 Than...
Vba 2010 open files in current folder loop
SolvedHello there, Think this is a relatively simple code and I've found examples but can't quite piece it all together to do what I want to do. I want t...
Excel working time macros
Hello, I am looking for a macro to extract data between certain hours. My csv has start_time and end_time of driver trips. I would like to see ...
Excel macro needs help fast
Hello, I'm currently trying to introduce macros in my reports at work. Everything works fine but there's one thing that I just CAN'T find an answe...
Vba 2010 saving workshts-workbks new file
Hiya, I've found a fabulous bit of code that saves the individual worksheets as individual workbooks. It works brilliantly and I'm just wondering ...
How can i track old dates of occurrences?
Hello, I need to track each occurence of an event that is recorded on one worksheet in Excel, and am hoping to find a macro that will take info fro...
Macro to transfer data
Hello, I am trying to create a worksheet for stock control. When I add the quantity and items needed, as well as the job reference, signed out by...
Convert pdf to epub on my iphone
SolvedHello! I would like to convert a PDF file to ePub format for reading it on an iPhone. Is there an online/desktop tool that will allow me to do that?...
Vba locate & delete words within a sentence
SolvedHello, I know this is probably very easy but I'm having trouble figuring it out. I'm trying to find a code that will identify key words within a s...
Vlookup not working as expected
SolvedHello, Sorry for my last post I didn't mean to be rude, just posted technical info, so can you please help me? I tried to figure out this by my...
Xl help required
SolvedHello, I need a help for one of my workbook. I have a workbook with a sheet name master and contains the below data: Nokia ...
Password issues
SolvedHello, I bought my acer aspire one zg5 model netbook from a friend and needless to say did not come with a owners manuel so I'm at a total loss when i...
Vlookup with dropdown dont popilate
SolvedHello, I have a dropdownlist lets say in A1, in B1 I have a vlookup that looks up a range from A1 in a diferent sheet (=IF(E10="","",VLOOKUP(E10,'...
Memory password locked
Hello, hi my phone nokia 2700 classic password locked please unlocked Configuration: Windows XP / Safari 534.30
Vlookup table_array parameter as a variable
SolvedHello, Configuration: Windows XP / Safari 534.30 I have this piece of code: ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-10],Position!R2C1:R5...