The discussions

How to combine if, and, or functions

 Solved

Increment the backers count by 5 if: The launched at month is January OR September The city is Vancouver AND the country trimmed is Canada If these...

1 reply Last reply on 23 Feb 2021 by
TrowaD

Copy row to another sheet if two (2) criterium are true

Hello, I have a worksheet with seven columns. I need to copy some information to another sheet if b2 is a certain color AND g2 contains contains c...

1 reply Last reply on 15 Feb 2021 by
vcoolio

False in excel spreadsheet

Hello, I wonder if anyone can tell me why I am getting a 'FALSE' entry from the following formula: - =IF($E$3=Sheet1!$A$1,Totals!E6,IF($E$3=She...

1 reply Last reply on 12 Feb 2021 by
Mazzaropi

Computer master password needed

 Solved

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

2 replies Last reply on 11 Feb 2021 by
Aliraza

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

2 replies Last reply on 28 Jan 2021 by
Raj

How to make a running balance column from a credit column and a debit column

 Solved

Hello, I am trying to create a running balance column from credit column and debit column. Everything that I have found regarding running balances on...

1 reply Last reply on 28 Jan 2021 by
TrowaD

Populate multiple tabs in an excel spreadsheet based on changes to main tab

 Solved

We have an Inventory Issued spreadsheet with the main tab listing all of our supplies, prices for each supplies and beginning inventory, number of ite...

1 reply Last reply on 28 Jan 2021 by
TrowaD

Copy multiple cells info from sheet if value greater than 0 in another cell

I'm trying to go row by row for a range (c3:c177) to move information from multiple cells in that row that are not grouped together on one sheet to an...

1 reply Last reply on 24 Jan 2021 by
vcoolio

Macro to insert row based on variable cell value (text)

Hello, I receive a large data file every week that needs to be formatted into an accounting journal entry. I have very basic VBA knowledge but it w...

1 reply Last reply on 20 Jan 2021 by
vcoolio

Data entered in one sheet automatically appearing in a master sheet

 Solved

I have an inventory workbook with 5 worksheets inside; One of the sheets is a master listing all inventory items. The others are dedicated to type of ...

1 reply Last reply on 18 Jan 2021 by
TrowaD

If formula for a date range

 Solved

I have two columns, booked date and las rev date for 2021 If the dates in these two columns are between Jan 1 - 24 then it would be a jan report date...

3 replies Last reply on 18 Jan 2021 by
TrowaD

Problem code copy invoice data to archive

hi, experts I've found this code from the internet , and I amended some ranges & sheets name , it works but not completely ,there i...

1 reply Last reply on 15 Jan 2021 by
abdelfatah_0230

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

5 replies Last reply on 13 Jan 2021 by
Mazzaropi

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

6 replies Last reply on 12 Jan 2021 by
Tbonekiller

Splite the multiple column value copy & paste in other sheet

 Solved

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

1 reply Last reply on 5 Jan 2021 by
TrowaD

Teacher

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

1 reply Last reply on 5 Jan 2021 by
TrowaD

Copy data from one worksheet to another using spec criteria

 Solved

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

14 replies Last reply on 4 Jan 2021 by
vcoolio

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

Last reply on 28 Dec 2021 by
vcoolio

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

7 replies Last reply on 25 Dec 2020 by
HelpiOS

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

11 replies Last reply on 25 Dec 2020 by
abdelfatah_0230

How to convert the data from pst to eml?

 Solved/Closed

I'm not getting exact solution for this

Last reply on 25 Dec 2020 by
somtochukwu

Matching 2 sheets

 Solved

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

1 reply Last reply on 24 Dec 2020 by
TrowaD

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

4 replies Last reply on 14 Dec 2020 by
NazCarr

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

3 replies Last reply on 7 Dec 2020 by
TrowaD

Formatting date

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

1 reply Last reply on 30 Nov 2020 by
GeekPeek

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

4 replies Last reply on 23 Nov 2020 by
informatiquetique123

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

2 replies Last reply on 9 Nov 2020 by
klewis24

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

2 replies Last reply on 5 Nov 2020 by
Santos

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

2 replies Last reply on 3 Nov 2020 by
ClefDeDouzeEtDemi

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

6 replies Last reply on 27 Oct 2020 by
abdelfatah_0230

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

4 replies Last reply on 26 Oct 2020 by
TrowaD

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

1 reply Last reply on 26 Oct 2020 by
David Webb  

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

3 replies Last reply on 22 Oct 2020 by
TrowaD

Restore setting password for g'five h91

 Solved

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

3 replies Last reply on 14 Oct 2020 by
Chohan

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

1 reply Last reply on 13 Oct 2020 by
TrowaD

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

1 reply Last reply on 13 Oct 2020 by
TrowaD

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

4 replies Last reply on 12 Oct 2020 by
Raj_1562

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

6 replies Last reply on 1 Oct 2020 by
Raj_1562

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

5 replies Last reply on 29 Sep 2020 by
TrowaD

Transfer data from one excel file to another excel file

 Solved

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?

2 replies Last reply on 18 Sep 2020 by
saurabh2033

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

4 replies Last reply on 15 Sep 2020 by
TrowaD

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

9 replies Last reply on 14 Sep 2020 by
TrowaD

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

1 reply Last reply on 10 Sep 2020 by
TrowaD

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

14 replies Last reply on 7 Sep 2020 by
Raj

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

1 reply Last reply on 1 Sep 2020 by
TrowaD

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

2 replies Last reply on 27 Aug 2020 by
TrowaD

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

1 reply Last reply on 20 Aug 2020 by
TrowaD

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

10 replies Last reply on 7 Aug 2020 by
abdelfatah_0230

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
Results 251 - 300 out of a total of 12,266