Posts by LanKez

That's amazing thank you so much, little question though when I change priority (Column I) on the main workflow page it doesn't update on the initial tabs (Column G) but everything else does, is there anything I can add or am I pushing my luck??

Thank you again

K

Thanks again for helping but this doesn't seem to be working I have uploaded the spreadsheet with the new code added for you to have a look, if that's ok?

K

I am getting the error when I try to put something In column B and then when I enter into row p and hit return it no longer transfers the data over to the separate initial tabs?? whereas before it would transfer over the data no problem

Hi

I am trying it on the file you provided and nothing moves over to the initial tabs.

I receive the below Debug warning

Set ID = Sheets(Range("P" & Target.Row).Value).Range("A:A").Find(Range("A" & Target.Row), LookIn:=xlValues, lookat:=xlWhole)

do I need to change anything, Any idea? Thanks again for your help

Kerry

Unfortunately this is not working - it doesn't transfer any data over to individual tabs and when I add something into the request from tab I receive end time debug warning - Am I missing something? thank you again for your help

Thank you I am trying it now, I really appreciate your help

What do I need to add to this vba so the comments column in the Initial tabs "Column E" move to the work flow page Column N when they are added also is there something I need to add so when updates are made to the workflow page they update the rows on the initial tabs??? Any help appreciated

Thanks but your right I don't know why it happened but hasn't happened since thank you so much for your help:)

That's just what I want , Thank you - quick question if I add data past row 6 it says there is a time debug error and doesn't transfer the data over - do I need to enter anything so it runs for the whole spreadsheet?

sorry no, that's a mistake all sheets will be the same - thank you so much

sorry no, that's a mistake all sheets will be the same

ok, so I could add a column at the beginning so it becomes column A with unique ID ref - would that solve it?

I have attached the spreadsheet with this modified.

Thank you so much for your help and patience

thank you for your quick reply:

Answers

1. The person who will be doing the work is the persons initials in column J , the name eg Haillie is the contact who put in the initial enquiry not the person doing the work. That's why I need the data to copy over to these initials tabs.

2. the completion date will be added into column E of the initial tabs - I need this completion date to populate column M in the workflow tab - yes the file reference will be unique to each job but not every job will have one

3. I was hoping the trigger would be when the initials are added to column J - as this is work for that relevant person

4 The sheet I uploaded is a replica of the one that will be used. I have attached it again

Let me know if you need anything more

yes - so all the data will go in the workflow tab and I want the rows to move to the relevant initials tab so the person can just work off the tab not the main workflow sheet. Then when they add the date complete I want the row to be removed from the initals tab but kept on the workflow tab with it showing the date complete. Hope this makes sense

I have added the data and how I need it to look, thank you

I am trying to create VBA that copies over data from a summary tab onto separate tabs based on initials in the summary tab. I only need certain columns transferring over.

I have attached a mock spreadsheet for visualisation purposes.

So the all the information is manually added to the summary tab. I then need data from columns C,A,D, N (column N needs to be free text and have the ability to be changed) ,M and H to be transferred to the correct tab based on the initials in column J , and the data is then transferred to the correct tab into columns A-F . Once the work is completed the date complete will be added. Once the date is added I need the row to be deleted from the initial tab but kept on the main summary tab.