Hi Team, I am working on a request where an excel sheet has few columns with columns format like(SSN , ZIP code and YYYYMMDD format) data. Now on the same sheet there is a button. If I click on that button, then all the sheet data will be exported to a new excel sheet and that will be saved into...
I have a written a script in VBA. while checking a CheckBox, it should check if respective cells(D26,D27,D28) have numerical value or not. The below code is working if I am writing values under/or 10000. If I am giving some larger values, its not working. Please help me how to achieve this.
I have a formula that works but need to put a twist on it to look at another column / Sheet.
{=IF(ROWS(E$5:E5)<=$B$8,INDEX(INDIRECT(E$4),SMALL(IF(Date_Received=$A$8,ROW(Date_Received)-ROW(AuditLog!$B$2)+1),ROWS(E$5:E5))),"")} This is working.
I need to add this to it...
Hi,
I have a macro created by one of my former colleagues. It a bit complex macro with multiple steps which includes application of mutiple formula. He is no longer working for us, and we have decided to move to power automate with Office scripts. I have been decoding each step and converting...
I am trying to build the logic in Excel where the value gets updated based on the Load criteria. I have attached an example where the row should update once the total of the cells in row 2 is in multiples of the load value. The logic should then take the difference i.e Total - Load and then...
I was make Print to PDF With Duplex page , its Work , But How to set (Top, bottom, Left, Right Margin) in this VBA code....
i was Create MODULE and put this VBA code , So Amazing Trick to ,make Print TO PDF with Duplex (Both-side),,,,,
Kindly Provide set VBA code For both page Margin...
Thought it was an easy one but it wasn't ^^", I'm trying to see if value in in Range 1 exist in List 2 or not. If yes return 1 if no return 0 in array (example of expected result in column C). I try COUNTIF, IF, SUMIF, SUMPRODUCT but didn't get the result I want, any suggestion please?
Thank...
how to Get Stock Balance After check " CATAGORY NAME " WITH "PRODUCT LIST" and show result
- I was try but i was failed matching Product list with Category
Kindly Need formula this Query
K3
=SUMIF(A:A,I3,C:C)
L3
=SUMIF(E:E,I3,G:G)
M3
=K3-L3
Hello,
I have an excel sheet of products. I've created a dropdown but what I want now is whenever from the dropdown I select a product, it's price is fetched from another tab and also expenses of that from another sheet. I'm attaching a screenshot which will make it easier to understand...
(1) How to get reference Sheet 1 to Sheet 2
(2) We Need four Option Reference According Match Question on Sheet 1
*Kindly make this formula for "sheet2"
Condition 1 :- i will change Serial Number After Change Question in "sheet 2" (match Serial no. and question to "sheet1")
Condition...
I am to looking at value in A column and see if it's in only column B, but not in column C. If it's true (in column B only) then I want to enter cell A value in column D otherwise blank
A B...
Hi All ,
I am facing an issue with an excel automation .
I have the following excel Sheet …
idx
Group
Family
Quantity
Audit comments y/n
1
Apple
Red
100
2
Apple
Green
20
3
Orange
Mandarin
100
4
Orange
Tangerine
88
5
Pineapple
Brecheche
60
6
Pineapple
Queen
70
7
Apple...
Hi, my boss wants me to create a formula for the prices of his products. He wanted all prices below 99.99 to be rounded up to xx.97 and the values from 99.99 and greater to be rounded up to xx.00 and I have managed to put together a round formula like this...
@ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ????
I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference
# How get Sum value via "HSN Code" vise ??????
Advance Condition :
"if 100 or More Entries in sheets how it possible to solve query via Formula this Concepts "
(without pivotable / without filter/ without VBA)
I have data set consisting information like Salary, Hire Date, Termination Date, Status of employee.
We want to distribute that salary in 12 months and also want to factor 3% increment every year from their joining date. Also want to factor in condition that if any employee joins in current...
Hi,
I am new to VBA, please help me with the below request.
I would like to Copy the data from table1 (sheet1) to table2 (sheet2) based on the criteria "Yes" automatically or some action.
The table 1 is located in Sheet 1 and table2 is located in Sheet2.
For clear understanding I have...
Dear Guys
I have the following formula
=IF(ISNUMBER(N7),"Credit Doc Reviewed","Not applicable")
I would like to add the following to the above formula :-
if n7=number then s7= "Credit Doc Reviewed" else if blank "not applicable"
if O7= number then S7="Sanction letter Sent to LOB"...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.