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 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, 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...
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...
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 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 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...
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...
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 & ...
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...
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...
hello I need help about showing wrong values in textbox(credit , debit & balnce) , it should show right value textbox (debit ) based o...
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...
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...
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 ...
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...
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...
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...
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 ...
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...
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...
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...
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) ...
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...
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 be c...
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" ...
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...
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 ...
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?
Dear All, I would like to auto update Serial Number based on column D in excel using excel formula. like: Thanks Raj
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...
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...
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 ...
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...
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...
DON'T MISS