Office Software Forum
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
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...
-
Generate multiple sheets from master sheet Closed
I really need help in this, I am not very good in programming in Excel, if you can guide me that will be very helpful.Willr eally apprecaite it very m...
-
Macro To Copy Paste Value Until A Condition Is Met Closed
Hello All I could sure use some help on a Macro, i'm still a newbie The Case is : A1 is the sum of row 4 In A3 there is a value of 1, B3 t...
-
auto update data between sheets Closed
Hello, I have 3 sheets with data table all linked to sheet #4. how to set that every time a new data is entered on one of the 3 sheets it will ap...
-
formula Closed
Hello, I am trying to sum up the number of times a certain term is found in a spreadsheet and associate it with the number that is at the top of t...
-
Conditional Formatting in Excel 2010 Closed
Hello, In a celll that contains an if fumula which calculates if a cell is an "Actual" or Forecast" based on a drop down box selection, I would ...
-
Copy and paste entire row above specific cell value Closed
Hello Team I want to copy the first row in the below table and insert wherever the cell has a value as "105125" in column C . Your urgent assistan...
-
Vba code to run faster Closed
Hello, Not much experience with writing macros and with help from some awesome forums and googling have put pieces together. Having issue running...
-
Code to copy entire row into sheet two or three Closed
Hello, I created an excel document with different rows. I would like the ability to transfer these rows to either sheet 2, 3 or 4 based on either ...
-
Excel '10 - A Macro to Populate Month Column Based on Date/Sched Closed
Hello, I'm trying to work on a macro in Excel 2010 to auto-populate certain month (Jan-Dec) columns with an "X" based on the criteria of two oth...
-
Excel 2010 - A Macro to Populate Month Columns Based on Date/Sch Closed
I'm trying to work on a macro in Excel 2010 to auto-populate certain month (Jan-Dec) columns with an "X" based on the criteria of two other columns. ...
-
Counting Names Separately Closed
Hello, I would like to request that how to count names separately if in any one columns contains more than one names. Such as it is given below: ...
-
Conditional format range if one cell contains certain text Closed
Hello, I'm looking to use conditional formatting to make the cell next to a particular recurring word (for example, "new") highlighted. I have a s...
-
memory card password recovery Solved/Closed
Hello, i have nokia 5130 expressmusic mobile phone with 2 GB micro sd memory card .ihave forgot the password of memory card can any body tell me the...
-
how to copy and paste the value corresponding to the matched cel Closed
Hello, A COLUMN CONTAINS VALUES 2, 3, 1, 10. B COLUMN CONTAINS VALUES 22, 1, 2, 36, 24, 10. C COLUMN CONTAINS VALUES 9, 8, 7, 6, 5, 4, 2, 1. NOW...
-
Copy a row based on a cell value. Closed
Hello, I have a very large spread sheet that I am trying to sort on to new tabs. Example tab one has the data and column A is the sorting column t...
-
Filter multiple worksheets based on data input in a master works Closed
Hi, I need some help with creating a VBA. I have a workbook that contains 6 worksheets. The first worksheet is a summary of the data listed in the...
-
trying to print an attachment Closed
I have an e-mail that has an attachment that is typed in Word. I have just installed Office 365 on my laptop which has Windows 10. When I click on...
-
Copy\paste Closed
Hello, Please help with below query Have 2 worksheets in same workbook and below macro is extracting data from other sheet based on firstname a...
-
Creating macro to search two values and delete them Closed
Hello, I´m new here. but I´ll try to do my best. I am looking for a macro where I can search in the column "I" all the values between two value...
-
Auto transfer from one tab to another Closed
Hello, I have been looking for ways on how to transfer a data in gdoc sheet from another tab. Example.. From Original File all data for ca...
-
Verifing-Vin Numbers Solved/Closed
Good Afternoon, I have two Excel Worksheets, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to comp...
-
formula Closed
I have multiple rows and one field is called product and the other is color. I am trying to figure out one formula that can be used on all the cells. ...
-
macro to search 2 values in a colum and delete them Closed
hi friends I´m new here. but I´m trying to make a macro where I can search in the column "I" all the values between two values. Those values are loc...
-
convert 4012016 and 24012016 in date format Closed
dear sir how we convert 4012016 and 24012016 in date format as dd/mm/yyyy in excel.
-
office error Closed
Hello, ms office word opens with squared boxes in back ground instead of blank page HOW TO RECTIFY TO BLANK PAGES
-
Dates from an IF statement Closed
Hello, I ve selected some dates via a simple if statement and can see the dates in the cell where I want them. But when I try to use them in anoth...
-
.xlsx, xls file Closed
Hi, I am not able to open the MS Excel file i receive in xlsx or xls format.How can i open it ? Thanks, Manwendra
