GRezGolfer
New Member
- Joined
- Feb 2, 2010
- Messages
- 2
Hi to all:
I am trying to copy a named range from a sheet that contains a field named month and year. These fields are not to be copied. What I am trying to do is use the year field to identify the worksheet (ie 2010 so I have a worksheet named 2010) and the month field is controlled by a list so mistyping is not an issue. I want the month field to be used as the name range for where the data will go on the 2010 worksheet. So I have on the 2010 worksheet a table that identifes each month and a range of cells that match the number of cells that I want to copy, with the name of each month. I want to create a macro that will print the data entry sheet and then cut and paste the data to the proper named range in the table.
I am very new to the VBA programming so I have been searching online for some commands to do this and I do have the dim and set commands to set the variables for mthname and sheetname.
Can some of you brainiacs(complement)
help me?
Thanks in advanced for your help.
I am trying to copy a named range from a sheet that contains a field named month and year. These fields are not to be copied. What I am trying to do is use the year field to identify the worksheet (ie 2010 so I have a worksheet named 2010) and the month field is controlled by a list so mistyping is not an issue. I want the month field to be used as the name range for where the data will go on the 2010 worksheet. So I have on the 2010 worksheet a table that identifes each month and a range of cells that match the number of cells that I want to copy, with the name of each month. I want to create a macro that will print the data entry sheet and then cut and paste the data to the proper named range in the table.
I am very new to the VBA programming so I have been searching online for some commands to do this and I do have the dim and set commands to set the variables for mthname and sheetname.
Can some of you brainiacs(complement)
help me? Thanks in advanced for your help.
