I have asked the same question in this forum but moderator may blocked it without any notification, but showing message of "moderator edited" on it. Why the moderator blocked my question without any reason?. If there was something wrong?
So I am asking the same question again here.
As per the...
how to find a entry match against it and make a report like a the attached sheet Sheet1. In the Sheet1 Report row 13th and 14th row received 3 star item and given 4 star item. How to do that. Can we do with VBA or Formula. Can someone help me to solve this.
Hai
How to use If sumifs formula to calculate between period of date.
My worksheet A4:441 has date column. I want combine the below given sumifs formula with the period of date 01/05/2019 to 31/07/2019. The period of date which need to calculate mentioned in H1 and H2.
01/05/19
31/07/19...
how to use formula for summing the follow with the word that contain 15w b22 in the cells
Item
Qty
Sum
Total
15w b22 cdl ball
15
15w b22
15w b22 ww
25
15w b22 ww re
15
15w b22 prpk
10
15w b22 4star
8
thanks
as per this forum rule
Start a new post every time you ask a question, even if the theme is similar. The original author may continue asking questions whilst the post is in progress and of course if you are answering questions you may need to ask questions of the initial poster.
This is not a...
Can someone kindly help to fill the array formula to accomplish to result
In the sample excel file 3 columns I have filled
IN SHEET1 column D5 NEED FORMULA as Sheet1 B2 NAME=SHEET2 RAGE C:C AND SHEET1 F:F RAGE VALUE=PURCHASE OR SALES RETURN THEN VALUE FROM DATA2 SHEET COLUMN E: (QTY) COME IN...
Hi
Can some one help me to make month wise summary report under each customer as the report sheet in sample sheet with macro . I will be very much thankful to you.
Please look into this problem and give a solution
Thanks in advance
HI
I have posted a threads in ask excel question in this forum, but I did not get a good solution. So I posted here for a Macro solution for that.
I would like to make a stock ledger as the Report sheet on the attached file. Can it be possible with Macro.
Here with I attached a sample file, in...
Hi
Can you someone please help me to make a stock register as per the attached file. Opening stock balance need to be take from database sheet. I also try to make a pivot table.
But it was not
I have an excel work book with 2 sheets named STK and DATA.
STK sheets contain 3 columns, Item code, Item Name, Quantity.
Data sheet contain 3 Columns, Item code, Item Name, Tax.
I want to add Tax column from DATA sheet to STK sheet. Pls. help me.
Can someone help this
I have an excel sheet with data of some configuration. I would like find out how much same configuration occurred in all sheet. Blank line divide each configuration
I want to copy data from one Workbook to another workbook as workbook name JB1 TO JB2 (Workbook Uploaded)
copy start from where in column "A" start a number then COPY columns
JB1 "MODEL" TO JB2 PRODUT ID,
JB1 DESCRIPTION TO JB2 DESCRIPTION,
JB1 QTY TO JB2 QTY,
JB1 MAKE TO JB2 SUPPLIER
and...
I have an excel file as attached.
I want to print the sheet (active excel sheet) by selecting range, each sheet should have 45 line per sheet, margins as the macro in attached file . First macro should show print preview and vba message ok or cancel to print.
I would like to define these value should come at "G15" or desired cell, how to mention that in vba
ie following should come at G15 onwards
1 2 3 4 5
2 4 6 8 10
3 6 9 12 15
4 8 12 16 20
5 10 15 20 25
6 12 18 24 30
7 14 21 28 35
8 16 24 32 40
9 18 27 36 45
10 20 30 40 50
Sub RangeObjects()...
I need to maintain excel sheet daily basis which is imported from another database. The imported excel sheet is not in a proper order. I want to arrange that sheet by following steps. There are several unwanted columns and rows, some columns are merged. I would like to arrange the sheet by...
I have an excel file with Product ID and Description Column. I want a macro to find out the Duplicate entries in that sheet. Herewith I attached a sample file.
I would like to use 2 private sub in one sheet as given below. First one is used for data validation list, and a combobox . Second one is used for Highlight selected Row.
How I can use both these 2 code in one sheet
1st One
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim...
I need a macro which can Total each customer transaction with its Narration. How It possible?
Total of Customer by Customer with its Narration like below
Customer Name Bills Cash Received Cheque Received Sales Return ....
Each narrations total should come one by one column.
Sample file...
Sirs,
I Want to Add Column G As Invoice if column C contains Bill No...... And if column C Contains Credit Note then add to Goods Return.
as in Sample data Invoce-Cash-Cheque sheet.
I have excel workbook contains Name and address as on the format of sample workbook sheet2. I want to copy it in the format of sheet1 of sample workbook. Sheet1 data contains in alphabetical order.Data of Sheet2 starts from B2. I need a macro for copy this data from sheet2 to Sheet1 as the...
Sirs, I would like to sort out and copy each party's sum of sales, cash received, cheque received, discount given, goods return etc. in a new sheet. Sample file attached. Can somebody give a solution
http://www58.zippyshare.com/v/11241576/file.html
Sample excel copy link above
I have more than 200 Customer Name in Database sheet.
I want to search select Customer Name from sheet name Database in the sheet of Invoice-Cash-Cheque sheet at the bottom row for data entry.
I would like to...