Hi everyone.
wanted to make my process fast of deleting every selected rows.

wanted a code for command button wherein on execution
if it finds any row with all the columns or cells empty from A to K
then it will delete the value in column or cell L and M of that
particular row.
If any single cell has a value in that row, then it should not delete L & M.

Thanks

]]>VBA ProgrammingPBAhttps://www.excelguru.ca/forums/showthread.php?9676-Excel-vba-to-delete-other-details-in-a-rowHelp with copy auto filtered data into a new workbookhttps://www.excelguru.ca/forums/showthread.php?9675-Help-with-copy-auto-filtered-data-into-a-new-workbook&goto=newpost
Tue, 18 Dec 2018 20:32:02 GMThere is my code, where I am facing an issue. I need to copy 3 sheets from 3 files, in one I have to filter data based on name of sheet from another...

here is my code, where I am facing an issue. I need to copy 3 sheets from 3 files, in one I have to filter data based on name of sheet from another workbook. I've stucked with copy filtered data to a new workbook. before that all works fine.
Sub Click()
Dim xRow As Long
Dim wbnew, wb1, wb2, wb3, wb4 As Workbook
Dim sht, Data As Worksheet
Dim sh1, sh2, subject, body, emailto, Filter As String
Dim Name As String
Dim rng As Range
Dim OutApp As Object
Dim OutMail As Object

'main goal is to copy data from 3 different files to new workbook. Below starting with copying data

Workbooks(wb1).Worksheets(sh1).Copy _
Before:=wbnew.Sheets(1)
Workbooks(wb2).Worksheets(sh2).Copy _
Before:=wbnew.Sheets(2)
'from third file I have to autofilter data for column U in File4.xlsx with criteria from File3.xlsx defined above

]]>VBA Programmingjayagehttps://www.excelguru.ca/forums/showthread.php?9675-Help-with-copy-auto-filtered-data-into-a-new-workbookHelp with a macro that searches, write cell location and divides a numberhttps://www.excelguru.ca/forums/showthread.php?9674-Help-with-a-macro-that-searches-write-cell-location-and-divides-a-number&goto=newpost
Tue, 18 Dec 2018 16:27:28 GMTI would need assistance with developing a new macro. The macro does 2 things: search in a range for numbers 1 to 10 and divide certain numbers by 10,...

I would need assistance with developing a new macro. The macro does 2 things: search in a range for numbers 1 to 10 and divide certain numbers by 10, that’s it.

I have 3 examples at the end and have uploaded my sample Excel workbook showing the expected result.

Thank-you in advance for your assistance.

Notes for below:

- Need 2 decimal places on the left and 2 decimal places on the right in every cell.
- I’m using Excel 2010, Sheet 2.
- Please do not hard code I may need to make changes in the future.

1st to do - is to find each possible number in the range and how it must be written. There will always be a positive result with a minimum of 1 and a maximum of 10 (could be expanded in the future) numbers found.

2nd to do - Divide the number (located in columns E/I/M, 3 cells to the right of the found number) by 10 up to the number 12.00. After 12.00 the remainder would be written to the listed cell. Add to any existing numbers in any of the cells.

3 Examples with expected results – see sample Excel sheet

The above code is run and the following would occur:

1st Found number – Number 4
- Write B20 (number 4 location) to cell H7.
- Divide 10.00 located in cell E20 by 10 cells C7,E7,G7,I7,K7,C14,E14,G14,I14,K14. Add to any existing numbers in the cell.

3rd Found Number - Number 1
- Write J26 (number 1 cell location) to cell B7.
- Divide 12.00 by 10 cells C7,E7,G7,I7,K7,C14,E14,G14,I14,K14. The remaining 8.00 would be written to cell C7. Add to any existing numbers in the cell.

I'm quite new to the VBA coding and I like it, so I would love to learn more.For serveral days I have been trying to figure out how to solve my problem. Unfortunately, the found answers could only respond to part of it, but never succeed in really adapting them.I have 5 databases in different sheets (A, B, C, D and E). The only common information is the column H in each one. And also this value is a unique one.On the first sheet I would like to move the entire row from one of these sheets if the value from B2 is found in column H. And after maybe changing some information to be able to move it back on the same sheet, but at the end of the list.

This is what I was able to do so far (it is only copying the row - but I would like to move it - also I can't get it to search the B2 value in another sheet if is not found in sheet A):

Hope my description is clear and that something like that can be done with the VBA coding.Many thanks in advance for your time!Kind regards.Sam

PS: VLookup formula won't work, as I might change some values apart the column H in that specific row.

Attached Thumbnails

]]>VBA Programmingsamdkhttps://www.excelguru.ca/forums/showthread.php?9667-VBA-code-for-moving-rows-from-to-multiple-sheets-if-meets-conditionDistribute jobs evenly within constraintshttps://www.excelguru.ca/forums/showthread.php?9665-Distribute-jobs-evenly-within-constraints&goto=newpost
Thu, 13 Dec 2018 16:38:47 GMTBest explained with the attached spreadsheet.
The task is to distribute jobs as evenly as possible between 6 machines within the following...

Best explained with the attached spreadsheet.
The task is to distribute jobs as evenly as possible between 6 machines within the following guidelines:
1. minimize machine cleaning by assigning same product to an applicable machine. Machine does not require cleaning as long as the same product is assigned to it.
2. some products can only be done by selected machines as per table
3. The first run starts at 4am, and each machine start time is staggered 30 minutes

]]>VBA ProgrammingRobnhttps://www.excelguru.ca/forums/showthread.php?9665-Distribute-jobs-evenly-within-constraintsQB for tax formshttps://www.excelguru.ca/forums/showthread.php?9664-QB-for-tax-forms&goto=newpost
Thu, 13 Dec 2018 14:59:01 GMTFar from an excel guru as well here. Yet I had never tried QB to fill out the tax forms. Usually, I just download a fillable template from PDFfiller,...

Far from an excel guru as well here. Yet I had never tried QB to fill out the tax forms. Usually, I just download a fillable template from PDFfiller, like this one for the 1099-MISC, or strictly from the IRS website: https://www.irs.gov/pub/irs-pdf/f1099s.pdf and my point is to fill them from Adobe Reader with the help of vba

]]>VBA Programmingcalimbohttps://www.excelguru.ca/forums/showthread.php?9664-QB-for-tax-formsPosting to last empty row stopped workinghttps://www.excelguru.ca/forums/showthread.php?9657-Posting-to-last-empty-row-stopped-working&goto=newpost
Tue, 11 Dec 2018 09:47:14 GMTHi Guys
This code is what I am using to add Data recorded from a userform to the next empty row in a sheet
It was working but now nothing is...

Hi Guys

This code is what I am using to add Data recorded from a userform to the next empty row in a sheet

]]>VBA Programmingtigerdelhttps://www.excelguru.ca/forums/showthread.php?9657-Posting-to-last-empty-row-stopped-workingPopulate VLOOKUP formula using VBA for all rows that have data in column Ahttps://www.excelguru.ca/forums/showthread.php?9652-Populate-VLOOKUP-formula-using-VBA-for-all-rows-that-have-data-in-column-A&goto=newpost
Sun, 09 Dec 2018 04:41:47 GMTHello,
I have a data set that includes scores for individuals, but the report lacks team manager assignments. I have a separate table that...

Hello,

I have a data set that includes scores for individuals, but the report lacks team manager assignments. I have a separate table that contains team manager assignments. The tricky part is that people change managers, and I have to keep the scores tied to the manager, and only new data would then be transferred to the new manager.

My thinking is that I have a query tab that I paste the data into. There is a column that always says "Item" for each record and isn't used for my purposes. So I thought if I made a control button that runs a VLOOKUP to pull the team manager assignment, within an If statement, for If the record contains "Item" in the specified column, then VLOOKUP runs and replaces the work "Item" with the Manager's Name. That way it would preserve the scores tied to the specific manager if someone changes managers.

THE PROBLEM: It seems that the macro runs for the first row correctly, however, it just repeats the same manager's name throughout the entire table where it says "Item". How can I make it pull the VLOOKUP data for each row and populate the correct team manager.

]]>VBA Programmingbradgivenshttps://www.excelguru.ca/forums/showthread.php?9652-Populate-VLOOKUP-formula-using-VBA-for-all-rows-that-have-data-in-column-AVerifying more than one textbox has entrieshttps://www.excelguru.ca/forums/showthread.php?9641-Verifying-more-than-one-textbox-has-entries&goto=newpost
Tue, 04 Dec 2018 19:19:19 GMTHi Guys
I need to ensure that if a combobox has a specific entry, a further txtbox also needs an entry
The code I have used for single entries...

Hi Guys

I need to ensure that if a combobox has a specific entry, a further txtbox also needs an entry

The code I have used for single entries is working fine but I can't get the dual entry to work

Iam working on a project ''Automation IE'' need help on the same.I am trying to spool one excel report from website by giving From date and To Date are as inputs iam able to give enter dates with my code but iam unable click on generate button..

I have 300+ rows of data in a sheet called "MASTER". A status marker (A or X) is placed in column T. When an X is placed in column T, I would like the entire row (including blanks to save structure) to be moved to the sheet called, "Inactive". I have a code inserted, but it's not working. It's in conjunction with another (working) code that is very important for the file, and maybe that's the issue. However, I am extremely inexperienced in VBA and I'm not sure how to fix it.

]]>VBA ProgrammingHHuttonhttps://www.excelguru.ca/forums/showthread.php?9622-Moving-row-based-on-cell-valueVBA - Find Previous Date of Purchase Orderhttps://www.excelguru.ca/forums/showthread.php?9618-VBA-Find-Previous-Date-of-Purchase-Order&goto=newpost
Tue, 27 Nov 2018 21:35:04 GMTHello,
I have a table with dates of certain purchase orders (PO) and their values (amount)
I found a formula that help me to find the...

Hello,

I have a table with dates of certain purchase orders (PO) and their values (amount)

I found a formula that help me to find the previous date and amount of each purchase order.

In the amount of some purchase order, I have the text "Out", in this situation, the formula skip those records and give us the amount of the previous date.

When I adapt this formula to my worksheet that have at least 50000 records, my spreadsheet gets super slow.

Is there possible to create a VBA code to calculate this formula?

I am not an expert and I need some help to find a solution. Any suggestions would be greatly appreciated!

]]>VBA ProgrammingMartMartnzhttps://www.excelguru.ca/forums/showthread.php?9618-VBA-Find-Previous-Date-of-Purchase-OrderMacro to move row data to another sheet when a cell selection is enteredhttps://www.excelguru.ca/forums/showthread.php?9617-Macro-to-move-row-data-to-another-sheet-when-a-cell-selection-is-entered&goto=newpost
Mon, 26 Nov 2018 21:09:18 GMTI have done this in the past, albeit a long time ago. And I cannot for the life of me figure this out, and I no longer have access to the spreadsheet...

I have done this in the past, albeit a long time ago. And I cannot for the life of me figure this out, and I no longer have access to the spreadsheet that I created before to steal the macro from.

So, any help would be greatly appreciated.

I am creating a spreadsheet that a few people will be using across the country via a server. And macros are not my strong point.

Essentially, When an order has shipped, I would like the row to be moved to the Shipped tab when "yes" is selected in he column drop down.

]]>VBA Programmingblkvoodoohttps://www.excelguru.ca/forums/showthread.php?9617-Macro-to-move-row-data-to-another-sheet-when-a-cell-selection-is-enteredprint specific range of specific tabs based on cell value in each tabhttps://www.excelguru.ca/forums/showthread.php?9614-print-specific-range-of-specific-tabs-based-on-cell-value-in-each-tab&goto=newpost
Sun, 25 Nov 2018 03:21:58 GMTHi All!
I’ve been searching for a print macro to print a workbook but have been unsuccessful in finding one that works.
I have a workbook...

Hi All!

I’ve been searching for a print macro to print a workbook but have been unsuccessful in finding one that works.

I have a workbook with 30+ tabs. Each tab contains a template that the user can fill out or not. Each tab is meant to be one page pdf. I’m looking for a macro to do the following…

>Print tabs that have a value in cell M7 of said tab (users will add a page number in cell M7 of each tab. Tabs that do not need to be printed will have blank in M7. Examples of M7 are 1, 2, 3…, 26 or …””)

>Print only page 1 of each tab from above (some tabs have a lot of crap in margin making it print excess pages, some blank or random calcs)

>Print using ‘Microsoft Print to PDF’. (some other printers seem to change the margins/etc.)

>Looking for one pdf combined will all pages

>When the window opens to save the pdf, have it open to file path listed in cell “=data!D22”

>Name pdf based on cell “=data!D24”

Alternatively, I could add code myself to combine which pages need to be printed into a single cell. In this case, I would need a macro to: