Office Software Forum
- Excel (9,871)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Splite the multiple column value copy & paste in other sheet Solved/Closed
Hello, I want to copy & paste the value of my data sheet, value are save in column & row, i want to splite the spacific rage of column value copy & ...
-
Teacher Closed
Hello, when I used rank function with count-if function the results of these two function if data has two same number like 292,292 it give the 1,...
-
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...
-
Change fill color depending upon the yes or no dropdown options. Closed
Hi, My question I want to create a vba code for yes or no If yes- If my columns C-N are blank, I want it to be highlighted by some color and afte...
-
Where did page numbers go? Solved/Closed
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/Closed
hello I need help about showing wrong values in textbox(credit , debit & balnce) , it should show right value textbox (debit ) based o...
-
How to convert the data from PST to EML? Solved/Closed
I'm not getting exact solution for this
-
Matching 2 sheets Solved/Closed
I'm driving myself mad trying to figure this out. I have 2 sheets. I need to match First & Last name on both sheets. If the name matches, then I need...
-
Automatically replacing a value in an excel report Solved/Closed
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/Closed
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 ...
-
Formatting Date Closed
My bank has organised my dates as dd/mm/yyyy which is about as useful as a hip pocket in your singlet. The logical way to organise dates is yyyy/mm...
-
keyboard shortcut for Smart Lookup Closed
In Microsoft Word, I cannot create a keyboard shortcut for Smart Lookup (búsqueda inteligente in Spanish). How can I do it? I cannot find it in the me...
-
HUGE Inventory Assistance - duplicate a row based on a cell value or quantity Solved/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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...
-
Problèmes de barres d'erreurs sur Excel 2010 Closed
Bonjour, Je vous présente mon problème. J'ai calculé mes écarts moyens avec la fonction de Excel. J'ai ensuite fais "autres options de barres d'err...
-
Loop through range to create new files with dynamic subfolders Solved/Closed
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...
-
Add an asterisk to specific words Closed
How do you formulate multiple cells in a calendar to place an asterisk at the end of the specific words: Eg: Homework due * (everyday Saturday) ...
-
With picture names in column, add picture to fit cell dimensions Solved/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
Hello, actually theses codes works very well in specific workbook i copy theses and adjusted what i need ranges names ..etc but it s...
-
Vlookup with condidion Closed
HI Team Pls help to make a vlookup with condition as explained below. Data reference as below Column A Column B Colum C X1 ...
-
problem search data by selected combobox & datepicker tools Solved/Closed
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...
-
problems with videos in powerpoint Closed
Hello, When I use a powerpoint when teaching a class VIA Zoom the videos embedded in it are choppy and studder even when I reduce the size of the...
-
Using VBA Code to extract data from a website Closed
Hello, I have little to no programming knowledge or how to work with VBA. I was wondering if there was a way to write a VBA code to extract data...
-
how can I unmerge cells, delete empty col and rows, relocate cells and combine? Solved/Closed
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/Closed
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
-
my pdf documents open in words and there is no option to open the document with Closed
Hello, My pdf documents open in words and there is no option to open the document with other format.
-
why does pdf document automatically converts to words documents Closed
why does pdf document automatically converts to words documents?
-
error 800ccc0e Closed
Periodically (like, after an update or just not logging on for a while), Outlook loses the ability to connect to yahoo.com for email. This is after i...
-
Count cells containing text per row Solved/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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 ...