I found a code which is very useful for my project, I have somehow copied the coding and tried to use it, however, I seek help to accomplish it. My question is as follows:-
I have 3 forms,namely PO1,PO2 & PO3. All the data is extracted from the spreadsheet, how do I call up the PO2 form if the row selected is PO2? Attached is my file for better understanding.
The file consists of 3 sheets:Orders,Order Form PO1 & Purchase Order. When I mark "x" in the row that I want to print, Order Form PO1 will be displayed with all data in the specific columns. However, it only allows me to select one row at a time. Now, I want to select multiple rows so that it will pass the data to the sheet Purchase Order.
View 13 Replies View RelatedI am trying to come up with a way to print out data that is variable in the amount of rows to print.
1. Cells C1 thru M6 is heading of report
2. Cells C7 thru M400 all have formulas and display information only when criteria in Column C in each row is met, if condition is not met it displays no informtion. (There lies my problem).
I need a way to print out only the area that information is displayed in and skip the areas that are not displayed. (Currently I have hard coded the print range using the largest report)
I need to print hundreds of pre-numbered surveys with two variables: class number and student number.
For example:
District
Number of classrooms
Number of students per class
A
50
20
B
100
25
C
35
20
I can create a separate template with district name, but don't know how to automatically print multiple copies with an auto-number. The result I want would be that it would print the following..
1. Class 1 / Child 1
2. Class 1 / Child 2
3. Class 1 / Child 3
... etc. through class 1 / child 20
21. Class 2 / Child 1
22. Class 2 / Child 2
etc.
I am willing to do this within Word, or as a mail merge with Excel or Access as long as I don't have to create a spreadsheet with thousands of numbers in it.
I'm trying to call a form I've created when the Print command is run (so when someone prints the document, the document number gets incremented.
I believe I have the command buttons setup correctly, as they aren't giving me any errors in the code, but when I do click the print button, the form isn't popping up. Could anyone give me a hint as to the direction to take?
I currently have a training matrix that has course titles along one row and names down one side. I am trying to create a form that when this SS is opened you will be presented with a form or dialog box that will offer you a dropdownlist of the courses available and once selected then enter your name in the next box and the relevant cell would be selected and the users can enter information.
I have attached a sample of the sheet that i am using and trying to semi automate
is there a way to use VBA and select a specific print area.
i want only up to column 'z' and to select from row 'a' to the final row with data in it.
I am trying to swith between different printers to print out sheets within a single workbook. Recording the macro doesn't work very well and the code I found online doesn't work either (error: object doesn't support property).
How can I set this up to be a dynamic printer setting?
Code I tried:
I need to get a button to print specified columns of data. There are columns in between the data that I don't need. So what I need is something that will allow me to print everything in column D starting at row 4 down to the last cell with data in it as well as G and H starting at row 4 down to the last cell with data in it. I have somewhat figured it out but the data ends up being put on different pages when printing. If possible I need it to print side by side on the same page.
View 1 Replies View RelatedWhat code can I write to print Sheet1 and Sheet2 on specific Printer and Sheet 3 to another printer, then all other sheets to another printer.
View 9 Replies View RelatedI am seeking the most efficient code to print all excel worksheets beginning with sheet "XYZ" and ending with the last sheet in the workbook.
- Sheet "XYZ" is always the starting point
- The number of sheets after "XYZ" is variable
- The names of the subsequent sheets are unique and not sequentially named/numbered
- The printing will be to one report (i.e. don't print pages individually)
I have a code that copies a column data from one workbook to another workbook
[Code] .....
This copies only D column to A coulmn of another workbook
I want 2 more columns to copied and pasted in another workbook
G column---- C Column
H column---- E Column
i have workbook that has form to login
what i need is how to get the data from textbox every time user login(fill the textbox) ,and put it in specific sheet with range.offset ?
I have a form to collect employee details. If i give the number of employees in one form, I will throw another form to collect the employee details. If I give 5 in first form, then the second form should be thrown 5 times and get the details. If I use for loop, then all the 5 form are thrown at once.
View 2 Replies View RelatedI have a workbook that has multiple sheets for patients (each named with SSN) with all such sheets having identical structure. I have the VBA code below that prints all sheets. Each sheet will have 7 pages when printed. Is it possible to amend the code so that it prints page 1 and page 3 from each sheets only?
VB:
Sub PrintSpecificSheets()
Dim WS As Worksheet, mySheets()
Redim mySheets(0)
[Code]....
I'm looking to setup a macro that will print specific pages on the current worksheet. What pages will print in that same worksheet will be determined on the value of a specific cell.
Here is what I have that isn't working.
VB:
Sub Print_Specific_Pages()
'''''''''''''''''''''''''''''''''''''''''''''Prints only pages that contain data
''''''''''''''''''''''''''''''''''''''''''''
If Range("B3").Value = 0 Then
Worksheets.PrintOut from:=1, to:=1 'Prints page 1 when there is no data.
[Code] ......
I am after a code that will sort out the below printing problem
I want excel to hide column E from the printer, i want to see the information myself but when i press print column E will not show
http://www.excelforum.com/excel-new-...ml#post2034148
I'm trying to find a solution to print to PDF specific worksheets in multiple Excel files. The files reside in the same directory, and I would like to be able to print them all at once to PDFs.
View 3 Replies View RelatedI have a report which is split into page sized chunks, in column P I have an identifier Planned, Booked or Running.
Is it possible to build a macro which says something along these lines
If P1 = "RUNNING" Then
Print that Page
Else
Go to P44
If P44 = "Running" Then
Print that page
Else
Go to P87
and so on until the cell selected is blank then stop.
I am currently trying to keep the print feature disabled in excel untill any of three specific cells are filled out. So that any of the following possibilities would work:
A2 H2 P2
[x] [ ] [ ]
[ ] [x] [ ]
[ ] [ ] [x]
[x] [x] [ ]
[ ] [x] [x]
[x] [x] [x]
This is what I've got so far.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If IsEmpty(Range("A2,H2,P2")) Then
Cancel = True
End If
End Sub
This code works for A2 but I can't get it to work for H2 or P2. i.e. print will be enabled if A2 has content and disabled if all three cells are blank, but if A2 is empty and H2 has content print will remain disabled.
I am trying to print one of the Sheets in my Workbook by looking at a specific cell that can have one of the sheet names.
View 7 Replies View RelatedI have an excel workbook with about 40 worksheets. I have a formula in A1 of each sheet that returns a 1 or a 0 depending on whether or not the name of the worksheet is in a list.
What I am trying to do is create a macro that will print all worksheets that have a 1 in A1.
Currently I am using the Kickbutt VBA Find Function of Aaron, but I would like to have something that works more efficiently. What I currently do is (assuming all possible values for Column J are A - F):
Find_Range("A", Columns("J"), MatchCase:=True).EntireRow.Delete
Find_Range("B", Columns("J"), MatchCase:=True).EntireRow.Delete
Find_Range("C", Columns("J"), MatchCase:=True).EntireRow.Delete
Find_Range("D", Columns("J"), MatchCase:=True).EntireRow.Delete
Find_Range("E", Columns("J"), MatchCase:=True).EntireRow.Delete
although I just want some code that says: delete all rows except those that have "F" as content in Column J. I already tried something like:
Range("1:65536").Select
For Each cl In Range("J:J")
If cl.Text = "A" Or cl.Text = "B" Or cl.Text = "C" Or cl.Text = "D" Or cl.Text = "E" Then
Rows(cl.Row).Delete
End If
Next
but it also takes much to long. The major problem I think, is that the number of records is variable so I search the entire worksheet...
i have created a form in excel sheet1 (not a VBA form) and there are 10 cells with headings in the form which need to fill the data but i want to copy certain cells (suppose 6 different cells) from my form which is in sheet1 and paste to another sheet2 to certain columns horizontally.
View 1 Replies View RelatedI am attempting unhide the same exact rows in multiple worksheets in Excel, Print the entire workbook, and then re-hide the same cells. As I am still learning VB i have been unsuccesfull. I have attached the code that I am using,
Sub Printdoc()
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
With sh
Rows("105:116").Select
Range("A105").Activate
Selection.EntireRow.Hidden = False
.PrintOut
Rows("105:116").Select
Range("A105").Activate
Selection.EntireRow.Hidden = True
End With
Next sh
End Sub
I can assign a number of copies to print by adjusting ActiveWindow.SelectedSheets.PrintOut Copies:= , but what I want it to have the number of copies auto adjust to the value of a cell that contains a formula. I was hoping it would something as simple as Copies:=cell but no luck...
View 2 Replies View RelatedHow do I write a vba code to print active sheet to pdf, auto save in specific folder then mail using outlook
im using 'Nitro PDF Creator'
also id like it to automatically save the pdf as the same file name as the active worksheet and also auto enter the following when opening the email server:-
Address: Cell D18
Subject: Cell D21
Email body:
find attached quotation
Optional installation available on request
how to create a barcode in an excel spreadsheet? I am trying to print out a sheet that includes a code 128 barcode of a specific number that I type in.
View 2 Replies View RelatedI have a customer database for specific contact details and instructions. The user can use filters to sort by branch, customer etc and then mark the selected customers he wants to printout.
Problem is, is that that the data layout within the worksheet is not a clear layout and as the number of printout entries will always be variable, is there a way I can print to a template a bit like labelprint software.
I'd like to be able to search a spreadsheet for a specific word or series of characters. Once all of the ROWS that contain the characters are found, I'd like to be able to have another spreadsheet with ONLY those rows (all columns).
View 8 Replies View Related
