Auto fill order form in new sheet.
Basically i have a sheet with various data tables i.e product type A (DVD) and Product type B (CD) etc, in each of these tables i have differing amounts of entries for each product type i.e.
table 1 (dvd a, dvd b,dvd c) and table 2 (cd a, cd b).
each dvd/cd title i have a price and a quantity field for orders, is there any way that when i enter a qnty for purchase, in a new sheet the DVD/cd order form auto fills in a printable list telling me the titles and the total cost?
Anwsers to the Problem Auto fill order form in new sheet.
Make sure the spelling of the worksheets in the macro are exact (Case sensitive)
Dim frm As Worksheet, stk As Worksheet
Dim finalrow As Long
Dim i As Long
Dim Lastrow As Long
Application.ScreenUpdating = False
On Error Resume Next
Set frm = Sheets("Order Form")
Set stk = Sheets("equipment requirements")
finalrow = Cells(Rows.Count, 1).End(xlUp).Row
For i = 4 To finalrow
If Cells(i, 4).Value > 0 Then
Lastrow = frm.Cells(Cells.Rows.Count, 2).End(xlUp).Row
frm.Cells(Lastrow + 1, 2).Resize(1, 3).Value = Range("B" & i & ":" & "D" & i).Value
Application.ScreenUpdating = True
- Click on the Start button on the Taskbar.
- Type "System Restore" (without quotes) in the Search box and hit Enter or,
- Click on System Restore (when you see System Restore pop up in the list of search results).
- Make sure the "Recommended restore" radio button is checked on the restore utility window.
- Click on Next and follow the instructions given.
Note: There is the option on the restore utility to select "Choose a different restore point". Unless you have a specific reason to select a different date and time than what Windows recommends, just select the recommended option stated in the steps above. If you choose to select another one, follow these steps:Click on that desired date and time, and Windows 7 will perform a scan for any affected programs in that restore point.
Once completed, click Next and follow the instructions given.
Once you have selected the restore point, your system will start the restoring process, after which you will have to restart the system.
Another Safe way to Fix the Problem: Auto fill order form in new sheet.:
How to Fix Auto fill order form in new sheet. with SmartPCFixer?
1. You can Download SmartPCFixer here. Install it on your system. When you open SmartPCFixer, it will perform a scan.
2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.
3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.
Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Solution to Error: Attaching wps files to email,Troubleshooting:ArcSoft ShowBiz will not open 'incompatible application',Fast Solution to Problem: Automatic system restore points not being created,Troubleshooting:backgammon on msn not working since last night Error,[Solution] Avery Label and microft word 2010, message about wizard did not install correctly,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?