Originally Posted by GhostofDoom p45cal, i see when we import from a new file we get the same ID numbers ? any solution for that please Change: .Cells(1) = 1 to: .Cells(1) = .Cells(1).Offset(-1).Value + 1
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Forum Rules