Office Software Forum
- Excel (9,765)
- Open Office (113)
- Outlook (641)
- PDF (334)
- PowerPoint (176)
- Word (2,186)
-
Word in a cell, for a number in adjacent Closed
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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Closed
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 Closed
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 Solved/Closed
Hello, 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% Solved/Closed
Hello, 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 Closed
Hello, 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 Solved/Closed
Hello, 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 Closed
Hello, 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 Closed
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 Solved/Closed
Dear 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 Solved/Closed
Hello, 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 Solved/Closed
Hi 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 Closed
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 Closed
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! Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Solved/Closed
Hello, 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 Closed
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 Solved/Closed
Hello 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 Closed
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 Closed
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 Closed
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? Closed
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 Closed
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 Solved/Closed
Hello! 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Closed
Hello, hi my phone nokia 2700 classic password locked please unlocked Configuration: Windows XP / Safari 534.30
-
VLOOKUP table_array parameter as a variable Solved/Closed
Hello, Configuration: Windows XP / Safari 534.30 I have this piece of code: ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-10],Position!R2C1:R5...
-
releasing filter before running a macro Solved/Closed
Hello, dear all friends, good morning. I have an invoice template in a worksheet in excel 2007.. By clicking two buttons ,I will be able to store ...
-
Matching numbers Closed
Hello, This is me Mustafa Faizi working as Western Union reconciliation officer, so as we know we have the MTCN umbers one from the Company and ot...
-
duplicate data Solved/Closed
Hello, all Please can you help??? I have duplicate data, lets say, Ben Ben Paul Paul Paul Ben Alan I want to lookup the Ra...
-
undo all filters before running a macro Closed
Hello, dear all, I have an invoice template in a worksheet in excel 2007.. By clicking two buttons ,I will store some cell contents of the invoice...
-
Highlight Rows with Conditions met Solved/Closed
Hello Friends, I desperately need a macro to Highlight /or separate rows when specific conditions met. sample file enclosed. Link http://www.spe...
-
Don't display zero if result is null. Solved/Closed
Hello, I'm a newbie, I can't figure out how to get Excel to put what's in a cell to another cell if the cell has a blank in it. For example, there...
-
i forgot my password Solved/Closed
Hello, im using samsung gt c3210 plz tell me how to unlock my mobile Configuration: Windows XP / Safari 534.30
-
Help with Time formula calculation Closed
Hello, I am currently developing a spreadsheet (Excel2003) to calculate overtime hrs in a small business. I have a start time, End time. I have broken...
-
phone password for samsung GT 3653 Solved/Closed
Hello, hi i would like ask if what is a password for samsung GT 3653? thanks!
-
Multible Vlookups Closed
Hello, all Hope you can help, I have a list of colums. HR Category Junior Senior Consultant R 80.00 R 100.00 Analyst R 80.00 R...
-
Calculate the hours per bed in a week Solved/Closed
Hello, I need a formula to calculate the hours per bed in a week divided by average occupancy rate. Which formula I should use? Many thanks! ...
-
excel data comparison and copy data Closed
Hello, Sheet1 details A:employee no (employee no appear more than once) (a2:a5720) B: name C:address1 D:address2 E:address3 F:address4 G:pin ...
-
put a loop for the code which insert pictures Closed
Hello, Please i'm using Microsoft excel 2010 and need to do this code as a loop and if all the pics are inserted then the loop should break. Co...
