Changing linking so instead of being between tables, it is linking between ranges

[dpaton05]

I have been working on a spreadsheet for months. This spreadsheet involved filling out information in a table, upon finishing, it would be copied to another table on another sheet, where further information would be added. Once this had been done, it would be copied to another workbook. The way I had it set up was a table on the first sheet which would be copied to a table on the second sheet and finally a range in the different work book.

I have been having all kinds of problems and I have had it recommended that I convert it all so it is going from range to range to range. I am not the best at coding, as I am still learning and I wanted some assistance. I am fine with formatting the sheets, just need help with the coding.

The last workbooks are financial year documents and each row in the first sheet will have a date which is transferred to the second sheet with the other relevant information for the row. The rows contain quotes for various services. Each row is transferred one row at a time.

Could someone please help me with the code I would use to transfer each row from one range object to the next?

I have attached a copy of my spreadsheet to give you some idea of what I want.

https://www.dropbox.com/s/fjljdrd0afd0wgs/quoting tool 11.7 WCI.xlsm?dl=0

Thanks,
Dave

 

[dpaton05]

My other concern is that you have a lot of code in sheet modules, where it SHOULD NOT be !!.....and I wonder if this might be affecting the process

A lot of the code is recorded in sheet modules, should it be in regular modules or where should the majority of it be?

 

[dpaton05]

Which post is post 58? I am looking at this on my mobile and it won't show the post number.

 

[MARK858]

Your last post is 62

 

[Michael M]

On the top of each post, over on the RH side is the post No !
In post #58 I asked

Just a thought, but....
1. Is the allocation sheet a shared file, or available to others, so they can use it as well ??
2. Is it possble that someone else has it open when you try to run this code ??
3. Could someone have it sitting open but not using it ??

Regarding Code in Modules.....
Unless the code is some kind of WorkSheet, Sheet calculate, worksheetactivate event, it should be in a regular module.
You can put a number of codes in a module AND you can rename that module to reflect what codes are held within it.
So, if you had a number of codes in a module that related to adding deleting rows.....you might call the module AddingDeleting.....you get the idea ??

 

[dpaton05]

I am trying to put the code in regular modules and I did that but then I double clicked on the button to see if it went to the code and it started a new procedure in the sheet that it was originally recorded under. How do I change it so it points to the code in the module?

 

[Michael M]

Which button for which code ??
Also, did you check the comments I made in the previous post ??

 

[dpaton05]

Which button for which code ??
Also, did you check the comments I made in the previous post ??

I have tried to separate the code into modules, say, all of the code for the buttons on the costing tool, I moved to module 2 and all the code for the quoting sheet I moved to module 1.

None of your comments would be valid as it is run of the local machine.

 

[Michael M]

Ok .....I'll ask again

Which button for which code ??

gave you the problem ??

 

[dpaton05]

Sorry Michael,

I copied the code for cmdAdd_Nlines and pasted it into module 1 and now the button doesn't work.

 

[Michael M]

Which button did you assign it to.....or did you create a new button ??
Remember, the code is NEW, purely because it has a different name. So if it hasn't been assigned to a button it won't work.