Office Software Forum
- Excel (9,631)
- Open Office (110)
- Outlook (626)
- PDF (330)
- PowerPoint (169)
- Word (2,168)
Results 1 - 50 of about 2,550
Back to the forum | Top |
- Solved
-
Conditional Formatting: Font color for entire column based on another column [Solved]
Hi! I would like to format an entire column so that if there is any entry in column B (in the same row) the font in column A will be blue, if there...
-
Clear cell contents based on value of another cell range using VBA [Solved]
I'm new to all of this and I'm stumbling through as best as I can so forgive me if I don't explain this very well. I have a workbook that has over ...
-
VBA Code to Copy Worksheet multiple times and rename based on list [Solved]
Hello, New VBA user.. I have created code to copy a worksheet multiple times and rename based on a list in excel. However, I am receiving an e...
-
Copy data from one worksheet to another using spec criteria [Solved/Closed]
Hello, I have tried to "customize" other answers similar to this question to fit what I need but I am new to the whole macro thing. I have only use...
-
Where did page numbers go? [Solved]
Hello, I am trying to set page numbers and from youtube videos, there should be a list of different designs showing here but it is not? How do I...
-
fixing populating values into textboxes based on showing data in listbox [Solved]
hello I need help about showing wrong values in textbox(credit , debit & balnce) , it should show right value textbox (debit ) based o...
-
Automatically replacing a value in an excel report [Solved]
Hello, I have a CAB Report template with a column called "Change Type" When I extract information the data in this column comes in as either Normal...
-
Use of IF [Solved]
Hello, Guys I am new to excel but I got a complex situation at work. Hope someone can help. I want a formula where if I change the date in one ...
-
HUGE Inventory Assistance - duplicate a row based on a cell value or quantity [Solved]
I have an inventory list that will end up being ~60k rows of data based on the sum of Col1. tab name - "inventory" Col1 - original quantity Col...
-
Match partial text string in one sheet to another text string in another sheet [Solved]
Hi All, I have two different sheets. In one sheet, I have last names. In the other sheet, I have a column that has cells that contain the person's la...
-
Quel bouton utilise cette sous-routine? [Solved]
Bonjour à tous, et merci de lire ma question. Voilà, je dois maintenir un vieux classeur excel qui présente des dizaines de boutons (je suis sous Exc...
-
modified code sum repeat data [Solved]
hello actually i search code to sum repeat values and i have about 2000 rows so that's why i do that by code instead of ...
-
Changing values in one cell depending on drop down list values in another cell [Solved]
Hello, I have created a drop down(pick list) in cell A1. In cell B1 I want it to show a specific number value based on which selection has been chos...
-
Loop through range to create new files with dynamic subfolders [Solved]
I would like to have suggestions for a VBA code that does this: Generate an Excel file for each contract number. When copying the contract number t...
-
Restore setting password for G'Five H91 [Solved/Closed]
Hello, I want to run restore setting on my G'Five H91 hendset, but I dont know what is the password use for it, Please Help Configuration: Wind...
-
With picture names in column, add picture to fit cell dimensions [Solved]
Hello, Im trying to create a macro to bring in images to fit the cell in the column next to the image name This is the code im using and its not wo...
-
Fill color in row if data is not available sheet 1 [Solved]
Dear Experts, In Excel, I have maintained "NAME" and "CODE" lists in Sheet 2. When pasting (copied data from another source) the"NAME" and "CODE" ...
-
Grey out an cell and not allowed to enter depending on a cell [Solved]
Hi All, Can you please help me on below request? In column B the name is entered the Column D partner name cell will be grey out and don't allow...
-
modified code create subfolder and save as pdf to it based on cell [Solved]
hi, all i need help to amend my code actually the code works very well but i need some adjusting i would create subfolders based ...
-
Transfer data from one excel file to another excel file [Solved/Closed]
Is it possible to transfer specific data using a formula from a single worksheet in an excel file to another worksheet in a second excel file?
-
Auto generate serial number in excel based on Column [Solved]
Dear All, I would like to auto update Serial Number based on column D in excel using excel formula. like: Thanks Raj
-
How to copy the Column value into Rows [Solved]
Dear Experts, I would like to copy the team name according to the image shown below. For your reference i differentiate 3 combination but I wou...
-
Rearranging data [Solved]
Hello, We work on a lot of data which is not structured the way we are supposed to use it. Am looking for a script in excel to search for a word in...
-
Auto generate serial number in excel based on input value [Solved]
Dear Expert, I want to auto generate the S.No in column A5 based on input value. I have to enter the No. of record in column C3(Ex: 3).The serial ...
-
keep the data even after the date change [Solved]
Hello, i have 2 sheets one is for the data called employee cost which is having a calculation of employees EOS and the other sheet is a report she...
-
Multiple Rows to one Row [Solved]
Hi, I have data supplied as - And require it to be copied to this format- How can i do this without multiple copy and pasting. Than...
-
IF function with dates [Solved]
Hello, I am trying to get a function to see if a pt needs to have an appointment made. I have been trying the 'if and function' to see if ther...
-
fixing complicated error populate data in listbox based on combobox and textbox [Solved]
Hello, actually theses codes works very well in specific workbook i copy theses and adjusted what i need ranges names ..etc but it s...
-
problem search data by selected combobox & datepicker tools [Solved]
hello i no know why this doesn't work this code and there is no error it should when i select from combo box it should show d...
-
how can I unmerge cells, delete empty col and rows, relocate cells and combine? [Solved]
Hi dears, first of all, I have to thank every one who read this message and he try to help me. its a complicated matter to me. Actually, I re...
-
Is it pointless? [Solved]
When I am writing an important document, I always upload a copy to Google Drive every half an hour because I am afraid of loosing it, although everyth...
-
How to Unlock A Password Protected Word Document [Solved/Closed]
How to Unlock A Password Protected Word Document
-
Count cells containing text per row [Solved]
Hello, I am trying to figure out and if statement to add 1 if there is text in a row so that at the end of the row I will get a total for each time t...
-
how to hide/undie picture based on a cell A1=1/0? [Solved]
Hello, can anyone help me how to hide/unhide picture 1? if A1=0 then hide picture 1 if A10 then show picture1 thanks
-
transpose data from vertical to horizontal [Solved]
Hello, this the code doesn't work i would transpose as what in existed in picture the result from e: h i hope somebody ...
-
copying formula for multiple worksheets [Solved]
I use ASAP utilities to insert multiple worksheets using a template. I'd like to create a formula that automatically inserts sequencial numbers. Ex:...
-
adjusting code divide data of table into tables in each sheet [Solved]
hi, my code really works but the problem when i add a new data it doesn't copy to the multiple sheets because the first time ...
-
how can i blink data in textbox on userform based on condition [Solved]
hello i got this code from the internet about blinking in textbox by command button but i would do this without command button it's directly ...
-
Excel - How to count numbers in Brackets [Solved]
Hello, I would like to know how to count the number of elements(digits) in the brackets after a word. exemple Bimbia(1,2,3,6,7,8). in the Brackets...
-
fixing sum an subtract among sheets [Solved]
hi, i search so much in the internet to fix my code to work but no answering so far i have 6 sheets it suppose copying data from a2...
-
corrupt files [Solved]
Hello, I have been using a document for 2 years now, and a couple of days ago, I had gotten my entire laptop updated to Windows 8.1. Since then, all...
-
Best MBOX conversion software [Solved/Closed]
Last few days I have suffered to the conversion of MBOX files. Can anyone suggest the best way of MBOX conversion? Which is easier and Saves my all MB...
-
Conditioning one Calc cell on another [Solved]
Hello, does anyone know a way to make it so that a cell in Open Office Calc cannot be left empty, or at least that there will be an error message if ...
-
VBA Function code to highlight Odd and Even numbers [Solved]
Hello, I am trying to write a VBA Function code to highlight Odd and Even numbers. But not having much luck. Can anyone help me, please? I would ...
-
Help: Need formula to find missing text comparing 2 cells [Solved]
Hello guys I have the same issue. A2: The price includes VAT B2: The price In the next column, I want the following value (the text difference...
-
VBA: Color cells in table based on multiple condition [Solved]
hello i do code by loop but it doesn't completely work i appreciate if somebody help me why it occurred and give me the alternative ok let'...
-
How to specify macro for current active sheet [Solved/Closed]
Hello, this is a very basic question, I am sorry to ask. I have created a macro in excel that I want to run in the current worksheet that is selecte...
-
How do I scan and then search a document [Solved]
I would like to scan the table of contents from a large number of magazines. What format should I use to save this document? What software will allo...
-
Excel make cell flash red [Solved/Closed]
Hello, In Excel I can make cell red when formula is greater than 4 but how do I GET CELL TO FLASH Office 2003 And can you in same spreadsheet li...
-
inserted row should paste in 7times in next sheet based on the date [Solved]
Hello, i have a template and from client a workbook will i should compare and paste the data if any new row der i should insert in template file an...
Subscribe To Our Newsletter!
