Office Software Forum
- Excel (9,610)
- Open Office (109)
- Outlook (618)
- PDF (324)
- PowerPoint (168)
- Word (2,164)
-
modified code sum repeat data
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...
-
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...
-
Problèmes de barres d'erreurs sur Excel 2010
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...
-
Loop through range to create new files with dynamic subfolders
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...
-
Automatically replacing a value in an excel report
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...
-
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...
-
Add an asterisk to specific words
How do you formulate multiple cells in a calendar to place an asterisk at the end of the specific words: Eg: Homework due * (everyday...
-
With picture names in column, add picture to fit cell dimensions
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...
-
Document Convert to Base64 in excel
Hello All, I have a query is this possible in excel? I would like to add a document (pdf/image/word file) in excel. Can that document data...
-
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...
-
HUGE Inventory Assistance - duplicate a row based on a cell value or quantity
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...
-
keyboard shortcut for Smart Lookup
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...
-
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...
-
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...
-
Encoding?
One of my documents is in text form. How do I read it? It is mostly squares.
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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 ...
-
Vlookup with condidion
HI Team Pls help to make a vlookup with condition as explained below. Data reference as below Column A Column B Colum C ...
-
How to convert the data from PST to EML?
I'm not getting exact solution for this
-
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 ...
-
problems with videos in powerpoint
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...
-
Using VBA Code to extract data from a website
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...
-
Simple way convert the data from EDB to PST
I'm facing issues regarding this
-
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,...
-
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...
-
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
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
why does pdf document automatically converts to words documents?
-
error 800ccc0e
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...
-
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...
-
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 System...
-
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 ...
-
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. ...
-
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 ...
-
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...
-
Re-edit the PowerPoint video over 3 times
Hi there Please refer to the video URL below. https://streamable.com/s0wzyh I think that the video above has been re-edited about three...
-
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...
-
Microsoft word file convertor
Hello, after downloading compatibility pack what should i do? System Configuration: Windows / Chrome 81.0.4044.138
-
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...
-
Google slides Animation by paragraph
Hi there Please see the video URL below. https://d.kuku.lu/f6795b206d If the paragraph is unchecked, the 3 words will appear all at once....
-
gestion des creances clients
Salut ! C'est ma toute première fois de poster sur ce forum et vu la performance des membres de celui-ci je sais que j'aurai une réponse à ma...
-
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,...
-
Best MBOX conversion software [Solved]
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...
