hi here this is the first post and I hope find what I'm looking for despite my request is not easy I have data in sheet1 contains...
Hello, i am having trouble and hopefully someone can help me i am creating an invoice system for the company i am working for and i have created a s...
Bonjour à tous, mon problème est le suivant: j'écris un livre et de ce fait j'utilise la fonction "titres" pour distinguer des chapitres, je fais do...
Hello to All Need for help to import multiple csv/txt files to multiple Excel Sheets/files using Power Query Thanks
Hello, Im struggling abit. I want to make a button where I add a new sheet with a specific name. In this example, "App1". But I also want to c...
Hi! I am looking for: -A FREE PDF editor -For Desktop (Windows 10) -I use Xodo pdf and it is really good but it does not have shortcuts for ed...
Hello, I have different numerical value in one column (say A column), I need to put serial number in another (B) column based in value in A colum...
Bonjour, Voici ma demande puisque je ne parviens pas à solutionner le problème ! En vue de mon prochain championnat, j'ai refait un nouveau calend...
Hello, I am trying to auto copy values from Sheet1, Col A to Sheet 2 only if criteria from Sheet1, Col b is met. I have tried so many different t...
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...
Hello, I am trying to create a way for me to type in a part number as a list for tracking inventory and have the information (parts, description, ...
Hello, 05/05/1981 How to write data of birth in word
Hello, I saw the answer given by Vcoolio that was very useful to me. And how to proceed with the rectification, on especific value, on rows from ...
Hello, my pc in entire words opening wont properly. im using win7.
Hi, I am willing to prepare the data under the catagory used and unused list checking the data table (data_plan) suppose C4A-R1 is placed in any ce...
Hello, I need help copying a row then lookup a value and paste the row next to the value that has been looked up, constructing a table. Thanks...
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...
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...
Hello, I have a question on how to do something specific in excel. I have a workbook with 3 sheets. Sheet 1 contains a master list of records. ...
I'm facing issues regarding this
Hello, I'm attempting to create a distribution list spreadsheet that will have all the names, emails, and agencies in one master sheet, and then h...
Hi Guys, Could someone help me in telling a way to export the data from excel to Microsoft Project automatically without having to use the import w...
Hello, I have done this function but it keeps saying false and that the formula is wrong even though I did what you suggested by using semi colo...
Hello, I am trying to find out if I can create a drop-down list in Sheet1 that when I make my selection, it will copy part of a row from Sheet2 on...
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...
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...
Hello, I am trying to create a macro that will copy a row with 6 columns on the condition that the 6th column is blank. Then it should paste the r...
I need help with a formula that will average numbers that meet a certain criteria. . I need break down the average results for each teacher and facili...
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...
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...
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...
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...
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...
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...
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...
I have two sets of data -Data A and Data B. The data is a time range - Entry in and Exit. I need to compare my two sets of data, within Power Bi to d...
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...
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...
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 ...
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...
I'm not getting exact solution for this
Hello, I am facing the Outlook Error 0x800ccc0f issue while incoming or outgoing MS Outlook messages. Please help me to resolve this error.
hi, experts I've found this code from the internet , and I amended some ranges & sheets name , it works but not completely ,there i...
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...
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 ...
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...
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 & ...
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,...
Hi ! I have an excel document where I'm trying to use a VLOOKUP formula, however it refers to N#A whereas the value actually is in the column. I...
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...
DON'T MISS