The discussions

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 X1 ...

2 replies Last reply on 3 Aug 2020 by
Karthikeyan1207

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...

5 replies Last reply on 23 Jul 2020 by
TrowaD

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 the...

5 replies Last reply on 21 Jul 2020 by
HelpiOS

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 data...

1 reply Last reply on 20 Jul 2020 by
Concensure

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...

10 replies Last reply on 16 Jul 2020 by
TrowaD

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...

3 replies Last reply on 14 Jul 2020 by
informatiquetique123

How to unlock a password protected word document

 Solved/Closed

How to Unlock A Password Protected Word Document

Last reply on 7 Jul 2020 by
David Webb  

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.

1 reply Last reply on 2 Jul 2020 by
GeekPeek

Why does pdf document automatically converts to words documents

why does pdf document automatically converts to words documents?

1 reply Last reply on 2 Jul 2020 by
GeekPeek

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 after i...

3 replies Last reply on 2 Jul 2020 by
GeekPeek

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...

1 reply Last reply on 22 Jun 2020 by
TrowaD

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

1 reply Last reply on 18 Jun 2020 by
TrowaD

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 ...

4 replies Last reply on 16 Jun 2020 by
abdelfatah_0230

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:...

3 replies Last reply on 11 Jun 2020 by
TrowaD

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 ...

6 replies Last reply on 28 May 2020 by
abdelfatah_0230

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 ...

3 replies Last reply on 28 May 2020 by
TrowaD

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 times ...

1 reply Last reply on 24 May 2020 by
David Webb  

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...

1 reply Last reply on 18 May 2020 by
TrowaD

Microsoft word file convertor

Hello, after downloading compatibility pack what should i do?

1 reply Last reply on 15 May 2020 by
David Webb  

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...

15 replies Last reply on 14 May 2020 by
TrowaD

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. If ...

4 replies Last reply on 9 May 2020 by
Utajima

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 question...

1 reply Last reply on 6 May 2020 by
David Webb  

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...

2 replies Last reply on 3 May 2020 by
hasnat

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 all MB...

2 replies Last reply on 21 Apr 2020 by
larsaden

Generating report sheets

I was developing Excel program for students' results calculation . How do I generate report sheet for all the students individually????? Thanks in...

1 reply Last reply on 16 Apr 2020 by
TrowaD

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 ...

7 replies Last reply on 16 Apr 2020 by
TrowaD

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 ...

3 replies Last reply on 16 Apr 2020 by
TrowaD

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...

1 reply Last reply on 14 Apr 2020 by
TrowaD

Reversing background colour and text colouring?

A friend sent me a couple of slides to use in my notes. Unfortunately, the slides have white lettering on a black background. I would like to know i...

2 replies Last reply on 9 Apr 2020 by
WesternGuy

Saved photos in paint - getting them back to original size

Hello, I have saved all of my photos on a Seagate portable hard drive. When I open these photos they’re saved as an img in Paint and they are zoom...

1 reply Last reply on 9 Apr 2020 by
David Webb  

Call barring cancel code

Tell me code Gfive DON keypad mobile for call barring cancel

1 reply Last reply on 1 Apr 2020 by
David Webb  

About automatic appearance of my password in outlook

When I want to enter to my outlook emais, my password appears automatically. I prefer, as it was before, me to put each time that I want to enter in...

1 reply Last reply on 27 Mar 2020 by
David Webb  

Download office 2019

Need help downloading Microsoft Office 2019* Bonjour à toutes et à tous, je viens de passer 30min à essayer de trouver un lien sur le site de Micro...

1 reply Last reply on 26 Mar 2020 by
David Webb  

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'...

2 replies Last reply on 24 Mar 2020 by
abdelfatah_0230

How to specify macro for current active sheet

 Solved

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...

18 replies Last reply on 20 Mar 2020 by
Dave

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...

3 replies Last reply on 20 Mar 2020 by
David Webb  

Excel make cell flash red

 Solved

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...

13 replies Last reply on 13 Mar 2020 by
Rjc

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...

3 replies Last reply on 9 Mar 2020 by
TrowaD

Vba to reference newest sheet

 Solved

Hello, Im a complete beginner in excel and the vba process. I'm trying to make a macro create a new sheet, copy the style/structure from a pre-det...

1 reply Last reply on 5 Mar 2020 by
TrowaD

Macro to select multiple columns by columns specific headings to delete dupes

 Solved

Hello All, I have been struggling to find a code that allows me to select multiple columns by name to then delete duplicates in those specific colu...

2 replies Last reply on 3 Mar 2020 by
TrowaD

Date counter and then stop when new date is entered

I am attempting to calculate the time between B9 and Z9. and the same with D9 and Z9. the person who created the file is only calculating from "Today'...

1 reply Last reply on 2 Mar 2020 by
TrowaD

Macro to compare 2 sheets and copy differences

 Solved

Hello, I’ve been working with this macro to compare two worksheets and copy the matches to a third sheet. Not knowing vb very well can someone show...

2 replies Last reply on 15 Feb 2020 by
AirMaple

Combine cell text

 Solved

Hi, I am after an easy way to combine text in several rows into one cell. The number of rows that need combining will vary from 2- 10 (Would be...

4 replies Last reply on 11 Feb 2020 by
ad1959

Vba error -2147417848 (80010108) automation error

So I am trying to make a spreadsheet that tracks our usage by diameter and individual serial number. I perform some basic checks using conditional for...

8 replies Last reply on 10 Feb 2020 by
Tbonekiller

Copying data from one excel sheet to another.

 Solved/Closed

Hello, Newbie here. Okay, I have an Excel workbook that houses a form on the first sheet. What I'm trying to do is to automatically copy the da...

Last reply on 10 Feb 2020 by
Kav

Copy rows from excel to another sheet once a date in a specific field is filled

 Solved

I have a current spreadsheet that lists our customers, job names, and delivery dates for the materials. I would like to have those lines copy automati...

16 replies Last reply on 3 Feb 2020 by
vcoolio

Cells copying and pasting in a empty cell of another sheet

 Solved

Hello, One Excel file has 2 Sheets. First sheet called "source" and second one called "Bestand" In sheet "source" one cell (a1 for example) must...

1 reply Last reply on 30 Jan 2020 by
TrowaD

I cant send or recieve emails from my new outlook account. urgent help needed

I just set up a new outlook email account but Im unable to send or recieve emails. Im desparate as Im applying for jobs and am waiting for replies.......

1 reply Last reply on 30 Jan 2020 by
David Webb  

Punching time

 Solved

Hi again! I have this task ofcalculating the punching time of our agents. I have 4 sheets in one excel. "Deliveroo Data" This is where the orders ...

16 replies Last reply on 24 Jan 2020 by
luigidelmonte

Yahoomail ads

 Solved

If I follow these instructions, will I still see the yahoo ads and "news"? I was planning to open an Outlook account and just forward Yahoomail to it...

1 reply Last reply on 22 Jan 2020 by
HelpiOS
Results 301 - 350 out of a total of 12,268