Copy Selected Range To New Workbook
I am trying to create a method to select the values of contiguous range selections on excel worksheets.
Users will be making new worksheets in new workbooks out of the data from the old sheets.
Currently users make a selection is and copy it to a new worksheet.
Is it possible to retrieve from the 'clipboard', the values from the associated cells?
And then to parse them into columns in a new worksheet?
Earlier I tried this bit of ( it didnt work )
Sub AddNew()
' for passing highlighted text into the form so that I can pass it
'to a new workbook.
Dim PassData1 As String
Selection.Value = PassData1
Set NewBook = Workbooks.Add
With NewBook
.Title = "xxx"
. SaveAs Filename:="xxx.xls"
End With
Range("A1").Value = PassData1
End Sub
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Copy Selected Range To A New Workbook
I have a code that will allow me to copy three worksheets from an open workbook to a new workbook. That works great, but I only need only a selected range from each of these worksheets to be copied (Range A1:AV60). Here is the code I use to select and copy the worksheets, how do I add a range within this code for each worksheet. Sheets(Array("Req Page 1", "Req Ext 1", "Req Ext 2")).Copy
View Replies!
View Related
Copy Selected Sheets To New Workbook
I have a workbook with about 25 sheets. All the sheets are named. I'd like either a Macro or some VBA code whcih, when the user clicks a button will Unhide selected sheets, say "Equip Labor", "Equipment", Proj. Summary" and "Implementation Guide" and then copy these sheets into a new workbook created on the fly (Book1.xls) and then in the original workbook re-hide all the selected sheets. This way the user can save the new workbook as whatever name they want. Is this possible? The closest post I could find was this: http://www.mrexcel.com/forum/showthr...opy+Worksheets I tried to modify this, but I'm not that good yet with VBA.
View Replies!
View Related
Copy Selected Worksheets As Values To New Workbook
I have a workbook with 30 some sheets. I would like to have a macro that if i select multiple sheets, will paste the values and formats of those sheets into a new workbook. I would like this to keep the names of the worksheets when transfered to the new workbook. Thus far, I have been using this code, which does nearly everything i want, but instead of pasting the values, it gives me #VALUE! for nearly all the cells. Most of the cells are using Vlookup and/or Indirect functions to reference other sheets- not sure if this is relevant. The few cells that do paste accurately are either text or simply reference another cell on a different worksheet without a function. Here's my code. Sub PasteShtVal() Dim w As Worksheet ActiveWindow.SelectedSheets.Copy For Each w In ActiveWorkbook.Sheets With w.UsedRange .Value = .Value End With Next w End Sub
View Replies!
View Related
Copy Selected Data To Workbook On Desktop..
As the buyer edits orders, I have a macro which pulls out all the parts with changes and puts them on a sheet named "Changes" in the attached "Sample" workbook. Since the buyer will do dozens of these edits a day, I'm trying to create a simple way for them to create a list of parts they may want to try and buy from another source. I would like to add a macro that would open a message box telling the buyer to select the parts they want to copy. They could select whatever rows they want to copy to the "Backorder List", and select "OK" or hit "Enter", and the macro would open the workbook named "Backorder List.xls" on their desktop, (mine is located under "C:Documents and Settingsjerry.hutchesonDesktop"), and copy the selected rows to the workbook, then save changes and close the "List" workbook. It should only paste the values, to preserve whatever formatting is in the book being copied TO, and it should copy below any data already in the workbook. To make things even more difficult, the macro would also need to copy the Vendor # and PO # from the top of the "Sample" workbook, (cells B2 and B3 respectively), and enter that data beside the other data just pasted beside the parts data in the backorder list. (I have entered sample data in the backorder list to show what I mean.)
View Replies!
View Related
Why Won't This Selected Range Copy To Another Sheet?
I have a button on the Players worksheet that has this Why would it not work? Range("NewData").Range("B5:B" & Cells(Rows.Count, "B").End(xlUp).Row).Copy Sheets("Players").Range("A3").PasteSpecial Paste:=xlValues I am trying to copy Column B starting at B5 down to the last used cell in column B. into the players sheet starting at cell a3. I try it and it highlights 4 cells and that is it??? Michael
View Replies!
View Related
Copy Selected Range & Save To Text File
I also use VBA in a terminal emulation program that I use the following command to 'screen scrape' the current display memory and quickly Save it to a .txt file: .SaveDisplayMemory "C:File1.txt", rcOverwrite What I want to do in Excel is, Copy the current selected Range() and Save it to a .txt file. I know how Save the current Sheet to a .txt file, but can't figure out how to Save just a Range() of cells.
View Replies!
View Related
Range Copy: Differ Depending On The Active Cell That's Selected
The rows will differ depending on the Active Cell that's selected and I don't know how to specify this. The range I want to copy is from Column B to DA on the worksheet ("Staff") which I want to paste to another worksheet ("Leavers"). This is as far as I got 'FindRemove = lstRemove.Value 'If FindRemove = "" Then End ' Goes to the start of the Data column 'Sheets("Staff").Select 'Range("B4").Select ' Tests current cell against FindRemove 'Do 'If ActiveCell.Value = FindRemove Then 'Call CopyPerson 'Exit Sub 'Else: ActiveCell.Offset(1, 0).Select 'End If 'Loop Until ActiveCell.Value = "" 'End Sub
View Replies!
View Related
Formula To Copy Lines Depending On Date Range And Agent Selected
What I would like to do with the information that I have put together on a different workbook is to reference an Agent (column A), and a time range (Date is in column D) and then copy the row from A to I for each occurrence during that range of dates so we can see how many and what errors have occurred during any range of dates selected. (I will have different people inputting errors at different times so the dates will not be sorted unless they have to be). I want to be able to select different agents/date ranges to be able to get a glance of how that particular agent did during this time frame. Here is an example of the work sheet where the data is originaly. [Removed] Here is an example (in a different workbook) of what the sheet should look like if I was searching errors for Albert Ozier between 1/25/2010 and 1/28/2010. [Removed]
View Replies!
View Related
Copy Rows To New Sheet Based On Date Range Selected On A Form
This spreadsheet must perform calculations for every line since new items are added every day, so VBA is probably better than copying formulas down every line of the spreadsheet: With the press of a button, I need to be able to select a range of dates and copy all lines within the range to a seperate sheet with the desired name under the same headings they currently reside under. I have included some modified code that is being used in another spreadsheet that was created for me, but I do not pretent to understand all of it and I no longer work with the creator of the spreadsheet. How do I use a button to open the form for date selections and entering the name of the new sheet, and then use the start button on the form to begin the matching and copying to a new sheet? If there is an easier way I am all for that too. Also, I need to keep a total of all items by month as well as a monthly and annual average of the Total Item Value on the FY09 tab. This will eventually produce another sheet when a button is pressed to submit as a report. I think part of this answer is in using the MONTH(serial_number) function but I can only get this to work for a single cell. I need to search the entire Distribution 'D' column, match all the months to the FY09 tab to the respective month, and calculate the totals and averages. I think SUMIF may also be needed as well but need the MONTH(serial_number)to work first. If there is a way to code all of this in VBA that would be fine as well. I have a pivot table on Sheet1 where I am trying to get the totals and averages described above but I am not sure it can do what I need. In column 'B' I need the total number of each item as well as the total number of all items. I tried various formats and adding the totals from the Totals tab but I have not figured it out.
View Replies!
View Related
Copy A Range Of Cells In Another Workbook Opened In A Separate Instance Of Workbook
I m not able to use the standard Excel Paste Special function when I copied a range of cells in another Excel workbook opened in a separate instance of Excel. Instead, Paste Special thinks that I have copied some non-Excel objects and gave me the Paste As options. This is not the case if I open both workbook within the same instance of Excel. Could you share with us if there is a trick to trigger the normal Paste Special options in such situations (without having to invoke Macro procedures)?
View Replies!
View Related
Copy Range To New Workbook & Close Existing Workbook
I have a very brief question dlgAnswer = Application.Dialogs(xlDialogOpen).Show Selection.Copy Windows("Derivative YK pricing Mod G.xls").Activate Columns("B:B").Select Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Range("C5").Select Application.CutCopyMode = False Windows("EXPORT1.xls").Activate ActiveWindow.Close As you can see, I open a workbook with the dlgAnswer, I was wondering how I could close that opened workbook Currently I have Windows("EXPORT1.xls").Activate ActiveWindow.Close however the workbook will not always be called export1.xls, I want it to close whichever one I opened earlier.
View Replies!
View Related
Copy Range From Workbook To Workbook
Background Excel 2000. I would like to be able to copy a range on worksheet 1 in workbook 1 to a range in worksheet 2 in workbook 2. Walk - Task described above with all fixed identities. Double- Can the task be performed using variables (sheets(variablee)) for the worksheets and ranges? Home Run - Can task be done with variables in workbook, worksheet, and range? Or just recommend a book or link that can get me there.
View Replies!
View Related
Copy Range To Different Workbook
I am trying to copy a small range from one sheet in a workbook to another sheet in a different workbook. My ranges are spelled out in the SrcBook and the DestBook in the code below: Sub CopyData() Dim SrcBook As Workbook Dim DestBook As Workbook* ****Application.ScreenUpdating = False ****Set SrcBook = ThisWorkbook *** *** '*On Error Resume Next ****Set DestBook = Workbooks.Open("E:WIPIWS WIP.xls") *** '*If Err.Number = 1004 Then ********Set DestBook = Workbooks.Add ********SrcBook.Worksheets(1).Range("D4:D6").Copy ********DestBook.Worksheets(1).Range("C10").PasteSpecial.Values ********Application.CutCopyMode = False ********DestBook.SaveAs ("E:WIPIWS WIP.xls")...........................
View Replies!
View Related
Copy Range To Another Workbook
I want to copy a range (Columne J: first row to rows.count) from one workbook to another workbook which already exists. The target range is always different. The code I have is: So far it only copies ONE cell, but even that doesn't work. I would need the whole range to be copied! Sub FinalImport() Call WhatRows 'to get the intZeile variable (number) via a inputbox Workbooks("import.txt").Sheets("Sheet1").Range("J" & Rows.count).Copy _ Workbooks("Air Distance Table.xls").Sheets("Sheet1").Range("D" & intZeile) End Sub
View Replies!
View Related
Copy Data Range From 1 Workbook To Another
I need to copy the same data range from Sheet 1 of different workbooks in the same subdir to output.xls (also in the same subdir). In workbook output.xls, I've defined the range of workbooks (source files) as name filenames. I need to copy the same data range (say B8:R8) from each source file to the cells adjacent to the filenames in output.xls. Eg. I have defined the range of files to copy data from as filenames in Col A of Sheet 1 in output.xls. Col A sales_10-09-06 sales_10-10-06 sales_10-11-06 Workbook sales_10-09-06 contain sales data of various product to different firms as below: Col A Col B Col C .................................. Col R prod A prod B prod q Firm 1 50 20 100 Firm 2 20 25 80 Firm 3 30 50 20 How do I copy B8:R8 of sales recorded for each day in sales_date.xls to Col B of Sheet 1 in output.xls? There are 200 files (specified by the name filenames in output.xls) that I need to copy B8:R8 from.
View Replies!
View Related
Copy Named Range From Another Workbook
In my project I have two workbooks. I am working on getting one to pull data from another depending on which employee is selected from a drop down list. TestLOG.xls contains a worksheet for each employee, with named sections within for various training the employee has, and down each row has information on the date this was received, initial, recurrent, etc. It is only this single worksheet for each employee that any data entry occurs, which makes things a lot more organized and efficient. TestFORMS.xls is the workbook accessed by the records department which has different worksheets depending on what data is to be presented. When an employees name is selected, I need the form to pull the specific data from another workbook, and post it on the current worksheet. This get repeated a couple times to fill the adjacent columns of data. I can't just select the whole table from the other workbook because in this current worksheet for example, only specific columns are pulled from the other workbook. To better explain the flow... Current workbook is TestFORMS.xls Current sheet is Test Closed workbook is TestLOG.xls In TestFORMS, sheet Test, when named cell Employee is selected with a value... Then open TestLOG in the background and open sheet of same name as Employee, and cope range ACtype. Back in TestFORMS, sheet Test, paste the ACtype data in the range named Type. Private Sub Worksheet_Change(ByVal Target As Range) Dim Ename As String Ename = Range("Employee").Value If IsEmpty(Ename) Then Exit Sub Workbooks("TestLOG.xls").Sheets(Ename).Range("ACtype").Select Selection.Copy Workbooks("TestFORMS.xls").Sheets("Test").Activate Range("Type").PasteSpecial Paste:=xlPasteValues End Sub Within the same sub, I would add additional lines of code to copy and paste the other ranges needed on the current worksheet. My current hangup is that I get an error at Range("ACtype") as that is not the proper way to call the range. There's more work to be done with the macro yet, like having it pull the data with TestLOG closed, which I believe is done by listing the path to filename. Then I need to maintain cell formatting on the new table when the data is posted to it. Hopefully the final task is to get this working so that when a new employee is selected in TestFORMS, the previous employees data is cut and the new posted, as the worksheet is just printed out for each employee and put on hardfile.
View Replies!
View Related
Macro Copy Range To Different Workbook
I am using command buttons to perform various macros. I have worksheetA with a defined range of cells of information that i sometimes want to copy to the index file. I click the command button to run the macro that copies the range to the next available row in #Index.xls How can i change the following macro to only copy the values, and NOT the formatting? Also, why does this particular macro cause the Command Button to remain stuck in the pressed position? It is the only command button triggering a macro that actually stays pressed, requiring my to click it again to depress it. here is the macro i have so far: ----------------------------------- Sub copy_to_index() Dim bk As Workbook Dim bSave As Boolean Dim lRow As Long ' test to see if #Index.xls is already open On Error Resume Next Set bk = Workbooks("#index.xls") On Error GoTo 0 If bk Is Nothing Then...........
View Replies!
View Related
Compare Range In Workbook And Copy To Another
i have 2 workbooks attached, in the "work order masterlist 2006.xls" workbook, i'm trying to compare column F which is the R date to see if it matches the dates in the "2006 Calendar.xls". if it's the same date, i would like to copy from "work order masterlist 2006.xls", column C, which is the Client's name to "2006 Calendar.xls" under its appropriate date, assuming that:Dates of the months will not change column/row in the "2006 Calendar.xls"it will be an added bonus if i can copy and paste the description as a comment...
View Replies!
View Related
Copy Range From Closed Workbook
I put the following codes in the module of Workbook BS. The codes successfully opened the workbook of 2008. Unfortunately, nothing was pasted to Workbook BS of sheet2. let me know any things missing from my codes. Sub COPY() Dim wb1 As Workbook Dim wb2 As Workbook Dim rng As Range Set wb1 = Workbooks.Open("C:Documents and SettingsuserMy Documents20082008.xls") Set wb2 = Workbooks.Open("C:Documents and SettingsuserMy Documents2008BS.xls") wb1.Worksheets("S").rng("B:B").COPY wb2.Worksheets("Sheet2").Range("A:A").End(xlToLeft).Offset(, 1) End Sub
View Replies!
View Related
Named Range: Create Copy From Another Workbook
I have a named range within a sheet. It was pulled across when i performed a move/copy - create copy from another workbook. The name contains characters that cannot be displayed or recognised and so they are displayed as square symbols. This causes me an issue as i cannot delete the name. Even if i paste the list names, i cannot copy/paste the name as the characters are not recognised. I also tried using a macro to delete all names, which did delete all names, with the exception of this one. The VB code used was : Sub Del_Names() Dim myname As Name For Each myname In ActiveWorkbook.Names myname.Delete Next myname End Sub
View Replies!
View Related
Copy Paste Range To Closed Workbook
Copy and paste the values only from one workbook and a set of named ranges (Name1, Name2, Name3) but only the rows within the range were TRUE is found in column A - To a CLOSED workbook named Data / Sheet1 - located at C:NetworkTemplate starting with cell B10.
View Replies!
View Related
Add New Workbook & Copy Range To It
This happened because I mentioned worksheet instead of workbook. The purpose of my code is as below: 1. Add new workbook (say wb2) 2. Activate the workbook wb2 3. Copy a predefined range from already open workbook (say wb1) 4. Select the target cell in wb2 through user prompt by using mouse or keyboard 5. Paste the copied range from wb1 at the selected location of wb2 I am facing problem in selecting the cell in wb2 as wb1 always remain in foreground and new workbook does not come to foreground even I click on that. What I wanted to mean by user form is that before the above code runs, another code runs that brings up one user form. In that user form user can select if he/she wants to copy the selected range to a new workbook or an existing workbook. Suppose user selects new workbook. This time the inputbox comes and asks user to select the target cell of the new workbook. The input box pops up but I can not select the cell in new workbook as the user form always stay there and does not allow the second work book to come in front. I ran the above code seperately without running the user form code and it worked perfectly. Hence I would like to know how to deactivate the user form
View Replies!
View Related
Copy Range Based On Value To Closed Workbook
I would like to be able to have a user execute a macro by clicking a command button that would copy some named ranges (Name1,Name2,Name3) BUT ONLY the rows/cells that have "True" in column A. The destination for the pasted data is a closed Workbook named Data – Sheet1 located on a network drive (\NetworkTemplate) Example: One named range are cells D10:D50, a second named range are cells F10:F50, and a third is G10:G50. – But ONLY rows 11, 13,14 have True in column A, so I only want to copy the 9 cells not the entire row from those select ranges and open a closed workbook and paste the values only starting with cell B10. I can not find anything that looks for a value in one column and only copies select cells to another workbook.
View Replies!
View Related
Copy Range & Transpose To Another Workbook
Copy a specific row of column summations (row to be copied varies by # of entries for the month) from each sheet in the workbook into sequential columns on the 1st Sheet. For example, copy Sheet2Row103 columns A thru O and transpose to Sheet1 column “A” rows 1 thru 15, Sheet 2Row56 column A thru O and transpose to Sheet 1 column “B” rows 1 thru 15, etc.). Excel fails to identify the Sheet Number/ Name if you use copy, transpose and paste, it only works if the transpose is performed on the same Sheet!
View Replies!
View Related
Copy Selected Rows & Insert As Many Times As Rows Selected
The following code inserts a row below the selected row, and copies the formula of the row above into it. Dim Rw As Integer Rw = ActiveCell.Row Selection.Insert Shift:=xlDown Rows("" & Rw - 1 & ":" & Rw - 1 & "").Copy Rows("" & Rw & ":" & Rw & "").Paste However, I need to alter this to work for inserting more than one row at a time. ie. the user selects 'x' number of rows and 'x' rows are inserted below (in the same way 'Insert Row' works in Excel) and the row above the selection is copied down.
View Replies!
View Related
Copy Range From Multiple Sheets & Paste To Another Workbook
I am looking for either formula which will allow me to copy data from a workbook with multiple named sheets into a workbook with a single named sheet. For instance workbook 1 has sheets named bob, sue, and tom and there is a workbook 2 which only has sheet bob. I want to copy the range fo data from sheet bob in workbook1 to workbook 2 as long as workbook 2 has sheet bob.
View Replies!
View Related
Open Chosen File, Copy Range & Paste Into Workbook
I'd like to know if it is possible to run a macro in a workbook that will open another workbook (of the users choice) extract data from it, such as columns from its sheets then paste that data into the workbook the macro is running from. The file to be opened will change, so i've found some code that enables the user to select the file to open then open it. Dim strFile As String strFile = Application. GetOpenFilename If strFile <> "False" Then Workbooks.Open strFile This brings up the standard windows choose file to open box, then opens the selected file. Am I correct in thinking that the Dim here will store the file name I select in the open file box? If so, I'd like to know how to select the workbook using the dim so I can manipulate it from the workbook I'm running the macro in. Incidentally, once the the data has been copied, I'd like the workbook opened with the macro to be closed.
View Replies!
View Related
Open Workbook Where Named Cell Contain Name & Path, Copy Range And Paste Values
I am successfully opening a .csv file using a variable value stored in a named range in my Main file (the variable includes the directory and path). I copy data from the .csv file to the Main file then I need to close the .csv file without saving but I want to do that by using the Windows("xxxx").Activate command where "xxxx" is the namedrange in my Main file which stores the .csv filename (without the directory and path prefix). I can use the ActiveWindow.ActivatePrevious command but if I have another workbook open, this one closes instead of the .csv file I opened from the macro. I realise this is probably very basic and I've searched the forums but can't find any identical postings.
View Replies!
View Related
Set Range From Selected Cells/Range
I have a macro which I manually have to change the range in order to run the macro, e.g. Set rngData = Range("B4:I12") rather than having to change the range for each macro, I was wondering if I could run the macro for the highlighted area. I have tried this, but doesn't seem to work. Set rngData = Range. CurrentRegion.Select
View Replies!
View Related
Calculate The Sum Of Selected Cells From Another Workbook
I am trying to create a workbook that calcualtes the sum of selected cells from another workbook. I have quite a few formulas, so i would like to use the fill command to help. I cannot get excel to pick up the pattern so I can use the fill formula. The pattern is as follows. Sum(n5:n11) Sum(n12:n18) Sum(n19:n25) Sum(n26:n32) etc.
View Replies!
View Related
Macro To Open Workbook - In Selected Destination
I currently have a macro that goes into a specified folder and opens all the files within that folder. This works great for me, but if i have to change the location of the folder i need go into the macro and change the destination code. I was hoping to let other people use this, but not necessarily people who would be able to go in and manually change the folder location. What i was wondering is if there is a function out there which would pop up a browse box which would allow the user to specify the folder location in which the files are kept? This would mean any user could use the tool to open the files without having to have the spreadsheet setup up on their machine.
View Replies!
View Related
Import Sheet1 From A Selected File Into Another Workbook
I have a workbook I add report data to, in the form of imported sheets. I know how to do this with text files, but I'm lost on existing excel files. I want to add Sheet1 from one excel file to another workbook. I got this far, but I don't know how to tell the computer to import the data from Sheet1 in the old file into the new version of Sheet1 in the workbook. So I currently get a blank new sheet. Sub OpenExcelFile() Dim FileToOpen As String Dim wks_exp_src As Worksheet Dim i As Long Dim strSourcePath As String Dim strSourceName As String Dim strSourceExt As String Dim strNewShName As String Dim strNameFinal As String Dim FirstPos As Long Dim bolShCreated As Boolean ChDir ThisWorkbook.Path & "" ' "C:"
View Replies!
View Related
VB Script- Open Another Workbook, Paste Selected Cells
I have a cell in one worksheet xxx in workbook XXX column F selected I want to run a macro that will open (if not already open) Worksheet yyy in workbook YYY (in C:/Test/ directory) And copy values from columns B and C of workbook XXX worksheet xxx (the row determined by the cell selected in the F column) to columns D and G respectivley of workbook YYY worksheet yyy I'm hoping the data will be pasted to a new row at the bottom of all existing rows on worksheet yyy (xlup?) If multiple cells in column F worksheet xxx are selected, it would be nice if the data was sent over to yyy in the same fashion, ordered top to bottom all at once...I don't want to have to select each row individually and run the macro
View Replies!
View Related
Copy Selected Lines
I have two sheets. sheet 1 has a list of invoices. on sheet 2 I just want to list certain invoices. so sheet 1 may be like this: 001 rmb $25.00 1356 002 ght $35.02 4568 003 ght $45.23 5689 004 rmb $12.25 4568 005 bnj $1.25 4568 006 sdr $12.54 4568 007 rmb $65.25 4568 009 bnj $56.54 4568 On sheet 2 I need it to pull out all the rmb lines. 001 rmb $25.00 1356 004 rmb $12.25 4568 007 rmb $65.25 4568 I could make sheet 2 in to a list and sort it that way. but what I need to do is pull the information into sheet 2, it's no good being able to sort it on sheet 1.
View Replies!
View Related
Copy Selected Sheets
I use the command ActiveWindow.SelectedSheets.Copy to copy selected sheets into a new workbook. As a result of this line is a new workbook created and a the selected sheets are pasted into the new workbook. Is it possible to paste only values by using a single line like this?
View Replies!
View Related
How To Copy Selected Data From One Sheet To Another
Hi excel masters, I have questions on how to built a macro to copy selected the data from one sheet (contains data) to a summary sheet, I used excel 2007. The macro I want to run to achive those result: The data on the data sheet listed similar like below: in first column (contains name) as below, xx xx xx xx yy yy zz zz in the summary sheet, I want to copy one particular name from datasheet to cell A17 and below, based on the the selection criteria I enter in cell B1. For example, if I want to show xx in summary sheet, I input xx in cell B1, and run macro to list xx one by one from A17, A18, A19.... I need to macro to run to search entire list to include the value I selected.
View Replies!
View Related
Copy Selected Records From One Sheet To Another
I have a sheet with the pricelist and a sheet with the actual price offer. I would like to copy selected Items from the price list to the price offer. I dont want to do that by copy and paste method. I would like to create check boxes, so that I can check / uncheck each Item I want to be copied and then press the button copy to the price offer ... how can I do that. I asssume I would need a macro for that. The columns in the pricelist and the price offer sheet will be identical of course.
View Replies!
View Related
|
TRACKER
