TT Master Button

Leads To Error - if i execute one by one from module no error but if i excute master macro button it leads to error
See attached new sample data added in sheet sample data
---TT-WIP-D-1.xlsm

When I'm testing your file I keep getting an overflow error on this line in the sub UpdatingMaster

wsMaster.Range("AC" & rngFound.Row).Resize(1, 7).Value = c.Offset(, 29).Resize(1, 7).Value

Select allOpen in new window

Is that the same error that you get?

Yes Same error

Try changing that line to this:

wsMaster.Range("AC" & rngfound.Row, "AC" & rngfound.Row + 7) = Range("A" & c.Row & ":G" & c.Row).Offset(, 29).Value

Select allOpen in new window

wsMaster.Range("AC" & rngFound.Row).Resize(1, 7).Value = c.Offset(, 29).Resize(1, 7).Value
Not sure that is correct, because specification for TT Add/ Update says columns AD to AJ, and above use AC to AI

I don't see any reason why it does not work, and the file I send run without errors.
Rgonzo1971 made the code, perhaps he can find the reason.

I would suggest to insert the values one by one, by replacing the line with this, then it runs.

For i = 1 To 7
     wsMaster.Cells(rngfound.Row, 29 + i).Value = c.Offset(, 29 + 1).Value
Next i

AC is column number 29, so the values replaced are for columns AD to AJ.

it is my start up in VBA ...i cant understand core VBA coding ...please suggest what   i do?

Thanks

if i run Sub MasterImportUpdating() on old data it is working fine (which is being in sheet sample data in my original post ) but when i run on new data that error pop up....see my 2nd attached file.

Thanks

I used your second file when updating that line. It works fine for me. Are you still getting an error with the update that I suggested?

just out of context ...seen this in EE Lucky draw....seems i am in the race :) :) ;)

Are you still getting the overflow error?

yes

The problem is the data in column AG. you have it formatted as "Custom => d-mmm-yy" Whatever is in that column is what is causing the overflow. Those are not dates. when nI change that column to plain text it works fine.

if that is the case then cant we add one more sub which select all column and format as general....before executing Module M6_UpdatingMaster - Sub UpdatingMaster().

Thanks

Perfect and i am in dilemma ...please understand

No worries, glad to help.