User Profile
BlueCollarVending
Copper Contributor
Joined Oct 09, 2023
User Widgets
Recent Discussions
Help with data sorting VBA
I need help with data sorting vba. I have a "Reports" tab that automatically generates data from other tabs to show low qty items. But at the moment the info is sorting by default (AZ, column A) but i would like it to sort by quantity instead. Here is the vba i currently have. Private Sub Worksheet_Activate() Application.ScreenUpdating = False Dim invws As Worksheet Set invws = ThisWorkbook.Sheets("Inventory") nrows = WorksheetFunction.CountA(invws.Columns(1)) 'nrows = invws.Cells(invws.Rows.Count, 1).End(xlUp).Row Range("A7:I50000").ClearContents k = 7 For i = 2 To nrows If invws.Range("E" & i) = 0 Or invws.Range("I" & i) = "Yes" And invws.Range("A" & i) <> "" Then Range("A" & k) = invws.Range("A" & i) Range("B" & k) = invws.Range("B" & i) Range("C" & k) = invws.Range("C" & i) Range("D" & k) = invws.Range("D" & i) Range("E" & k) = invws.Range("E" & i) Range("F" & k) = invws.Range("F" & i) Range("G" & k) = invws.Range("G" & i) Range("H" & k) = invws.Range("H" & i) Range("I" & k) = invws.Range("I" & i) k = k + 1 End If Next i Application.ScreenUpdating = True End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) Target.Calculate End Sub[SOLVED] Expense Report
So i have a expense report im working on and i need help with some formulas. The report is multiple sheets, 1 sheet is an overview 1 is the main receipt entry 2 are for more detailed entries (based on the receipt type) 1 Milage Log 1 settings So what i am trying to do is, on my main receipt entry sheet, i enter the receipt basic info. Date, Receipt number, supplier, type, pretax amount, tax and then totals are automatic. on the 2 detailed sheets i would like to reference the main sheet and have it pull info from that sheet (based on "type") and have it auto populate the info there. then i would go in and add the details based on the receipt ( ie. all the items on the purchase). Then i would "group" the purchase details under the auto populated info. I guess my first question would be, If it were to set this up, would it mess up my formulas if i add rows under the auto populated info and group them? I understand this is probably a large request and a lot of formulas. Any advice or direction would be awesome.Re: [SOLVED] Expense Report
I'm not sure i follow what you are asking. If you are referring to the "Inventory and Other" tabs, those details i want to come from the purchase report automatically. As far as the "Total" columns on the Purchase Report, That is generated automatically from the report page.Re: [SOLVED] Expense Report
I tried the formula you posted and it worked but only for a specific cell. And it doesnt allow me to filter the Main PURCHASE REPORT by category and input all the essential data with the choose function. Also what would a formula be to make it autoskip a row? I asked ChatGPT and this is what it sent. Took a bit to get there but.... =IFERROR(CHOOSE({1,2},INDEX('Purchase Report'!A:A,SMALL(IF('Purchase Report'!D:D="Your_Category",ROW('Purchase Report'!D:D)-ROW('Purchase Report'!D1)+1),ROW(INDIRECT("1:"&ROWS('Purchase Report'!D:D))))),INDEX('Purchase Report'!C:C,SMALL(IF('Purchase Report'!D:D="Your_Category",ROW('Purchase Report'!D:D)-ROW('Purchase Report'!D1)+1),ROW(INDIRECT("1:"&ROWS('Purchase Report'!D:D))))))), "") The problem is, is it keeps causing my excel to crash. Plus i dont really understand any of this. I would like to understand some of the code so i could figure out how to make it work properly.formatting help
Hi everyone. I need help with my excel table. I've created a financials workbook for my business and need help keeping it in order. I want to have the data from the "Purchase Report" auto populate to the appropriate tab based on a criteria. I have a tab for inventory and one for other. I want to set it up so when i add a purchase on the main report, it will auto generate it to the proper tab with a line between each auto entry so i can add in the details about the entry. Will it screw up the formula if i insert rows between the formulas on the "inventory and other" tabs? So i can add the itemized data per entry. Is there a will to have it pull multiple lines of data as well? I would like to have it pull the "date, receipt number, supplier, and total" any help is appreciatedRe: How to automatically update different tabs from master tab in Excel?
I was dealing with the same issue with a financial report i was building. I had the months spread across multiple tabs and was running into issues. I later redesigned the whole report and took all the months and set them up on a single sheet. But i basically took each month and added a group under that month. So when collapsed, it would only show the month title with a totals cell. When expanded, it showed all the details for that particular month and i was able to add in rows if need to expand the groups volume.
