Posts by dloc_26

Good afternoon,

I would like some help on creating a macro to print each barcode and SKU number as an individual print area. So D2 and D3 would print as a .gif then D4 and D5 would be an individual print as so on all the way down column D until the last barcode. Ideally, I would like to route this to a specific folder on my network so I can click the "GO" button and it would loop through until all 1600 on the first tab and 400 on the second tab were complete. See attached worksheet.

Crate Barcode Template.xlsx

Thanks in advance.

Unbelievable. Thank you very much.

Good Morning,

I've conceded figuring this out myself.

I am working on a sales forecast spreadsheet and looking for a COUNTIF that counts the number of quotes based off the service provided. Quotes are entered in the table and the quote date is in column B starting with row 5. The different services provided are headers in AJ4:AW4 with the values of the quote falling in the subsequent rows. I can get the first formula to work and it will count all the cells in the specific row but I cannot get the second formula to work to narrow down between two dates (e.g. dates for the last four months, dates for the next four months). Any help is appreciated.

Some explanations:

ServiceProvided is a dropdown

This works for a total list of quotes within the requested column: =COUNTIF(INDEX('Forecast Details'!$AJ$4:$AW$500,0,MATCH(ServiceProvided,'Forecast Details'!$AJ$4:$AW$4,0)),">0")

When I add a date "sandwich" formula (which works on other formulas within the same spreadsheet) to the COUNTIF above and make it a COUNTIFS it does not work.

=COUNTIFS(INDEX('Forecast Details'!$AJ$4:$AW$500,0,MATCH(ServiceProvided,'Forecast Details'!$AJ$4:$AW$4,0)),">0",'Forecast Details'!$B:$B,">="&EOMONTH($M$2,-1)+1,'Forecast Details'!$B:$B,"<="&EOMONTH($M$2,3))

See attached worksheet. First two tabs are the ones I'm working with. The cell that is in contention is on the Dashboard worksheet cell R6 and will replace the "ZZZ" in the formula in Q6 so that when the Service Provided dropdown in N2 is changed it will update the total count of quotes based off the month in M2. My next step will be to update the quote amount Column O but I think that if the quote count can be figured out then I can update the SUMIFS formula off the solution to this challenge.

Thanks,

Dustin

Thanks. I was able to take your code and change the column lookup and color number and it works beautifully. I would say this is solved!

Thanks for the script. Unfortunately, it didn't work. A couple of things that I saw (I forgot some details :|) were that the column of text is in column "U" and the font color is not the standard red, the RGB: R: 231 G:37 B:46. Hopefully this helps.

It is the result of manual input. I copy the list from a database and that's how it comes in.

Good afternoon,

I am looking for a macro to add to my current script that will delete the row that has red text. It would run this script all the way down a continuous list from rows 75:1500 and delete all instances of red text; another option would be to use text designators such as "questionable", "doubtful", or "out". Here is an example, say row 81, 82, 83, 84:
[TABLE="border: 1, cellpadding: 1, width: 500"]

[tr]

[td]

Player Note

[/td]

[/tr]

[tr]

[td]

Player Name

[/td]

[/tr]

[tr]

[td]

Doubtful

[/td]

[/tr]

[tr]

[td]

Sun @ 12:00 pm

[/td]

[/tr]

[/TABLE]

Thanks!

[USER="14282"]NBVC[/USER], thanks! works perfect.

Good afternoon,

I have a list of 890 rows that have a starting file name and ending filing name. It is for a library indexing system. I am looking for a formula (no VBA/macros) that if I type in a subject that falls between the starting word and ending word it returns the location of the searched file. The example below is a small snip of the whole table that goes from row 5 through row 898. I would like the formula in the middle column where the red text is.

Example:
[TABLE="border: 1, cellpadding: 1, width: 500"]

[tr]

[td]

Searched Name:

[/td]

[td]

Piano Manufacturing

[/td]

[td][/td]

[/tr]

[tr]

[td]

Crate:

[/td]

[td]

10AD5

[/td]

[td][/td]

[/tr]

[tr]

[td]

Start File

[/td]

[td]

End File

[/td]

[td]

Crate

[/td]

[/tr]

[tr]

[td]

Philippine Islands, Int. Trbls.

[/td]

[td]

Physiology, Research

[/td]

[td]

10AD4

[/td]

[/tr]

[tr]

[td]

Piano Exchange

[/td]

[td]

Poland, Warsaw, Monuments & Memorials

[/td]

[td]

10AD5

[/td]

[/tr]

[tr]

[td]

Poland, Warsaw, Penal Institutions

[/td]

[td]

Powers

[/td]

[td]

10AD6

[/td]

[/tr]

[/TABLE]

Thanks in advance for any help.

Thank you. This is a good start for what I am looking for.

The purpose of row 27 is to keep the chart on a rotating schedule. So when I type a date in D26, it updates row 27 with every M-F in the shown date format. Does the macro require a hard date?

How would I go about optimizing a list of numbers to maximize within a constraint of another number?

EG: I have this list of numbers (1-N) and I want to maximize the list to get as close to 66 as possible.

48
42
11
9
24
36
33
40
27
19
6
48
25
38
14
15
16
50
20
48

It can be anywhere from 1 number up to 4 or 5 as long as the total is under 66. There can be multiple groups of numbers. The end state is to minimize the total groups of numbers.

So the formulas to base the dates off the first date will not work? What do you suggest?

The string is correct. I did type that wrong...D27:DA27.

That is where I don't know what's wrong. The macro should look up the date value in "Compiled Job Data-After" cell B1 (strDATE_FORMULA) across the strCALENDAR_RANGE.

The attached worksheet has some code that was built and works 90% correct. There is one thing that it doesn't do and I cannot figure it out. The data is not updating correctly for the date. On the "Compiled Job Data-After" sheet, cell B1 has the date. It is currently set at 11/12/18 for testing but will actually contain the =Today() formula so it will update daily when I click the button. After clicking the button, the macro is supposed to look across the "Current" sheet range D24:DA27 but it only populates all the desired for all the jobs and doesn't update the data to show only the applicable data for the date reference in cell B1. Can anyone help?

Thanks. [ATTACH]n1212410[/ATTACH]

Thank you. Is there a way to automatically select a specific printer, that is on our network, without having to go to the dialog box?

bump.

I'm looking for a macro that will print to a specific network printer and incorporate a specific printing profile that is setup for that printer. My team runs reports that are printed on different color paper (green paper and gray paper with a staple) and third copy on white paper with a staple and water mark. I already have the profiles setup but I was wondering if there is a way find the network printer, use those profiles and automatically print them with the click of a button.

Thanks

Good Afternoon,

I have attached a file for reference. I would like to click a button that transfers the pertinent information from the "current" tab and move it to the "compiled job data-after" tab. There is also a "compiled job data-before" tab that is blank. I have header columns on the "compiled after" tab in row 2 that I would like the data to move from sheet to sheet. The carpenter #4 would be a manual enter from me. I would ideally be using this everyday to email out the carpenter schedule so as jobs complete I would like them to fall off the report when click the update button.

I'm sure I've left some stuff out that could be helpful (I don't want to be too confusing) but please ask me.

Thanks.

So, fast forward a month, the solution is bugging out a bit. I have saved the attached file with today's date in cell D24. The date in the original file was 10/1/18. I would like to update cell D24 to the first monday of each month. I don't think that has a huge weight on the solution but I just want that to be known. When I update cell D24 to the first monday, it updates column G data on the Compiled Job Data-After tab to "Start Day" which is the first column to the left of actual project data (column C). I can't figure out the code to fix it. I would like the Compiled After tab to show only work that is taking place on the date in cell B1. I can have up to 12-15 jobs in a day that need to be populated from the Current tab to the Compiled After tab.

Thanks.