Office Software Forum
- Excel (9,664)
- Open Office (111)
- Outlook (629)
- PDF (331)
- PowerPoint (169)
- Word (2,171)
Results 1 - 50 of about 2,560
Back to the forum | Top |
- Solved
-
modified code copy data from userform to the empty last columns [Solved]
hello this is the first post in this forum and I hope finding solution here I got this code from the internet and works wel...
-
Copy Rows to multiple sheets based on drop down validation [Solved]
Hello all, I have tried to find the answer to my query through other questions but can't put my finger on what to do. I would like to copy rows...
-
Macro that changes a row color at the change of each job number. [Solved]
Hello, I have a spreadsheet that is say 5000 rows long and 15 columns wide and contains production job numbers in Column A. The details associate...
-
If a cell has a value, make another cell indicate the number 1. [Solved]
Hello, If I have for example, any data entered into cell f9, how would I enter a formula to make the next cell, f9, indicate 1 or any specific numb...
-
Excel Conditional formating using formula [Solved]
Hi All Agian, I have a table with a list of customers and i have columns with the months and on each month i enter the visit day. I want to format...
-
computer master password needed [Solved/Closed]
Hello, my inspiron 1420 needs a system authentication password and ive tryed so many times to open it bt I need a master password plaese help me than...
-
How to convert an attached image to Base64 format. [Solved]
Hi All, Hope you are doing good! I would like to convert the attached image into Base64 format in excel via VBA. Is it possible to change the i...
-
How to convert the data from PST to EML? [Solved/Closed]
I'm not getting exact solution for this
-
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/Closed]
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/Closed]
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- Facebook Code Not Received
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- How to Install a VPN
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
- How to Disabled Write Protection on a USB