Office Software Forum
- Excel (9,794)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,186)
-
Excel VBA to open a EULA script when opening a spesific workbook Solved/Closed
Hi Everyone I am busy designing a training pack with formulas in a excel workbook using MS Excel 2013 and have it already password protected using vb...
-
Summing until criteria are met in another column Closed
I have a situation where I want to sum a column of numbers from bottom to top but want the summation to stop when criteria from another column is met....
-
VBA Macro Copy and Paste Loop Help Closed
I need to create a macro that allows me to copy and paste a set of formulas/values down a certain number of times. For example, if I had the following...
-
Conditional Formatting Closed
Hello, Can someone help in figuring out a formula. If in the spreadsheet I enter under the condition column "good" or "bad" I need the next column...
-
I need your help with Macro's please Closed
Hi there, I have been doing some reading up & watching YouTube tutorials regarding Macro's that will copy data from one sheet to another if certain c...
-
Macro sum the values coloumn wise into brekup level Closed
I have a senario where i need to sum the values coloumn wise into brekup level, i have given the example below the number of items can vary so i need ...
-
Populate list Closed
Hello, I'd like to scan a column for a certain word (e.g. "Yes") within particular date in workbook, and i need to copy the text in some other cell ...
-
If value in column A exists between values in column B and C Closed
Hello, Looking for assistance on the following: I want to know if value 302000000 (column A) exists between value range 382777400 (column B) and...
-
Copy all Rows with specific Name to new Sheet Solved/Closed
Dear Friend, Am having a Excel Timesheet with following columns SITE - EMP NAME - EMP ID - EMP JOB TITLE - DATE - TIME IN -TIME OUT - TOTAL - NOR...
-
VBA Formula Closed
I need to create a macro that allows me to copy and paste a set of formulas/values down a certain number of times. For example, if I had the following...
-
Conditional formatting, using a formula to determine cell format Closed
Excel 2010 Hi, I need to make a spreadsheet and I want to use a BRAG rating to do so. To do this I want to type BLUE, RED, AMBER, GREEN into a cel...
-
Vba to change cell colors and highlight rows Closed
Here is what I have going on. I have a spread sheet, across the top are the dates of days that my crew works and the first column is everyone on the c...
-
CONVERTER FOR PDF TO WORD DOCUMENT Solved/Closed
Hello, I would like to know how to get the software for converting PDF documents to Word documents.
-
Excel to Word shortcut Closed
I created a spreadsheet and then tried to create a shortcut but it came up as a word shortcut not excel. I looked at the file properties and under gen...
-
Need help with a formula Closed
Hi I am putting together an expense calendar and need help with a search formula. What I am in need of is a formula that searches the days of the m...
-
Stacking 3 columns into 1 with matching cells and headers Closed
Hello, I have a table with data dating back weekly for 7 years. I am shifting it over to a new system but need to import the data in another form...
-
regarding excel Closed
sir, let me know how to convert date of birth in to words
-
Comparing two string columns in excel sheet Closed
Hi Can anybody help me to correct this data? There is a long list of this type of data.I want shortcut method to solve it as if there are columns tha...
-
macro that will allow tab 1 's information to be copy to tab 2 Solved/Closed
Hello, Please help. My Excel Workbook has two tabs. Tab 1 contains all project information such as project number, customer name, project name, co...
-
transfer a row of data from one sheet to another same workbook Solved/Closed
Hello, I am trying to transfer a row of data from one sheet to another in the same workbook but my code is not working could anyone help me thanks...
-
BOOKLET DESIGN SOFTWARE Closed
Please, I am looking for a simple booklet design software that I can easily manipulate. thanks
-
compare two cells in excel and if matches need to print its adja Closed
Hello, I want to compare two cells in excel and if matches need to print its adjacent value in next column. for example: I need to compare colu...
-
Help with search formula Closed
Need help trying to search for a specific variable, then return another variable that corresponds to the first. I will be entering Informatio...
-
Convert number to letters in Excel Solved/Closed
Hello, I have to define the numbers to their associated letters and based on the combination of numbers the next cell should show the letters. ...
-
Convert date of birth into words Solved/Closed
Sir, Kindly help me in changing date of birth into words. Example:20.03.2001 as twenty march two thousand one
-
PDF to other format converter software. Closed
Hello, I want pdf to other formats converter software which should be free and easy download and not trial version. Whole document should be conve...
-
Macro Copy Paste from one to another based on cell value Closed
Hello, I have two sheets. Phase I and Phase II. Phase I I have columns A-J. Im looking for a macro which would copy columns A-F and paste it to she...
-
Automatically moving data Solved/Closed
Hello, I have a master data sheet that one column in the sheet that represents a sub set of the data. When I add information to the master sheet, I ...
-
Moving Data Closed
Hello Peeps, I'm having some trouble with using a macro to copy some data from one sheet across multiple. I have a master sheet that contains train...
-
how to create new workbooks from current workbook and move data Closed
Hi, I have the following workbook named "org_file": file_name data_1 data_2 File_1 r1 s1 File_2 r2 s2 File_3 r3 s3 . . . File_N rN sN I ...
-
Find word within cell & put "value from a list" in adjacent Closed
Hello, If cell A contains a short statement (e.g: 'supply of computers', 'supply of furniture', 'construction of water taps' and 'construction ...
-
help with macro VBA Closed
Hello, need to get a macro enabling to select a range of cells from one row and tranpose them into fixed position + get value from one cell and retur...
-
Try to scan one shell value and copy that entire row in other sh Closed
Hi, Sir/mam, I Have Two sheet named "carcase"and " shutter". In carcase sheet I have three nos. Of columns and 800 nos. Of Rows, in...
-
Create Macro to create worksheets based summary sheet Closed
Hello, I have an extremely long list of inventory items by department number. What I want to do is create a individual worksheet for each departme...
-
Help with writing macros Closed
I'm hoping someone who knows alot more than me about Macros can help me. I've been trying to get my head round writing Macros for ages now with no luc...
-
Autofill and open worksheet Closed
Hello, I am wanting to be able to search and open worksheets by typing the beginning of a worksheet. I have worksheets X,Y,Z and if I begin typi...
-
Search Cell for Multiple Text Strings, Return each found value Closed
Hello, I have a basic function to search a cell for a specific text string (in this case, the name of an application) and return a value to anoth...
-
Need VBA help Closed
Im pretty sure i will need VBA for this issue and I have no clue. I setting up an online store and I would like to track all my stock and transaction...
-
DUE DATE ALERT FROM EXCEL FILE WHEN WINDOWS STARTUP Closed
Hi, I need clarification that we can create due date alert from an Excel file when windows start up. Is it possible. If yes, Please advice how to c...
-
How to copy rows from one worksheet to another Closed
Hello, I am having problems writing a code to copy the rows from one worksheet to another, if certain criteria are met. A data dump is taken f...
-
How to create an text based spreadsheet Closed
I have access to Excel 2010 in an MS Office Suites. What I am try to do is to create a spreadsheet where I can enter a designated code (i.e. A1, A2...
-
location master file in excel Solved/Closed
I have location master file in excel. 1) I have another file in A2 column there is a address like 422, Ashok Vihar, New Delhi, 2) i want to brin...
-
Create new excel file from existing Excel file. Closed
Hello, I want to create a command button in a existing excel file that will pop-open a new excel file. (it will be good if it ask me "Save as" for ...
-
How to fix doc and docx file? Closed
Hello, Hi! I have couple of ms word documents that I cannot open, they somehow got damaged and I get an error when trying to pen these files "...
-
software development Closed
i want a big software for our company and i also want a software engineer to operate our software and handle all the programs.
-
If "yes" in a column copy other cells to the next tab. Closed
Hi Guys, I have a sheet with participant names and a lot of other information about their attendance. What I am trying to do is to copy their name ...
-
Sales invoice in sheet1 and create summary table in sheet2 Closed
hi im working on sales/inventory worksheet. i made the sales invoices in sheet1, now i want all the details of sales invoice in sheet 2 to create ...
-
If Statements Solved/Closed
Hello, I have a scenario working with a time sheet. So basically the way payments work is from 30 minutes to 5 hours is automatically 5 hours of w...
-
Date formatting Closed
I would appreciate if someone can help me here. When I export transaction list from a Bank Account for example, the dates for some reason appear in d...
-
Need to look up multiple values and return a value from that row Closed
I have a large spreadsheet where within one cell I need to look at the entire file for a value in a certain column that matches the value on a certain...