User Profile
crankcaller
Copper Contributor
Joined Aug 16, 2023
User Widgets
Recent Discussions
Re: Duplicate Row if any data in particular cell
As I typed my previous response I realised that myself. I would like to know if they are all wrong - or what percentage. If they are all wrong then a new load will be required which will cost money. If it's say 25% of items then staff can manually alter the records.2.3KViews0likes1CommentRe: Duplicate Row if any data in particular cell
The person who compiled the spreadsheet has possibly messed up somewhere. Not me i'm glad to say - but i'm having to fix it! The items were imported into a new system from the spreadsheet and some titles have the wrong barcode entirely. We know this as when you search for some items with the book in front of you the barcode doesn't match, they are for a different item entirely. I checked the titles in question on the original spreadsheet and they are wrong there as well - so presumably it wasn't an error when the spreadsheet was mapped to the database. I wish to scan the ISBN and barcode from each physical item into a file. This will give me the correct info. I then wish to compare that to the system and original spreadsheet. Because of multiple copies of items with the same ISBN I wanted one per row - I assumed it would be easier to compare the multiple copies by sorting by ISBN. Sorry if this is too much info - I've been at this a while today and my head is fried!2.4KViews0likes5CommentsRe: Duplicate Row if any data in particular cell
mathetes You are quite correct in what you say! I know there will be a way to do it more elegantly than what I am able to do with my very basic Excel knowledge. I wish to compare a list of books from a library system with a list of books (the spreadsheet) The spreadsheet has one ISBN per row and is an export from an old library system. Each row has multiple barcodes in columns F to N, but only one copy of the Bibliographic info - ISBN, Author, Title etc. Columns A to E. I wanted to duplicate columns A to E if there was info in rows G to N. Isbn First Author Title Classification Section Barcode Barcode 2 Barcode 3 Barcode 4 Barcode 5 Barcode 6 Barcode 7 Barcode 8 9780140621167 Poe, Edgar Allan Selected Tales E POE Explore R07862K0554 R07861J0554 R07860A0554 R07859W0554 R07858F0554 R05666K0554 R05667L0554 R05668M0554 So in that example above it would duplicate that row seven times. That's part 1! Part 2 would be replace the barcode Field in the second row from barcode 2, replace the barcode field in row 3 from Barcode 3 etc etc.2.4KViews0likes7CommentsDuplicate Row if any data in particular cell
Hello, I have a spreadsheet of books. Roughly 3000 rows. Columns A to E are ISBN, Author etc. Columns F to N are Barcodes. Not all cells have barcodes. If the title has one copy then there is only a barcode in F If it has 3 copies there are barcodes in F, G, H etc. All the barcodes begin with R. I wish to duplicate the Row if there is a barcode in G to N so I can then have 3 rows for a title if it has three copies. 6 rows for a title if it has 6 rows etc. I don't know any VBA or anything. I filtered column G to show rows with data and there were 373 - so manually would take forever. Thanks for reading this. I have Office 365 if that makes a difference.2.9KViews0likes12Comments
Recent Blog Articles
No content to show