GMSuppliesLtd
New member
- Local time
- Today, 20:06
- Joined
- Mar 6, 2013
- Messages
- 3
Hi,
Having an issue with Excel that I'm hoping someone here might have a solution to.
I run a website that has (at present) 14,000 individual products listed,
These products have been split down in excel to be managed by Brand. Each brand has a separate worksheet, currently I have around 220 worksheets/brands.
When my main supplier sends a price update I get given a CSV file with around 11,000 lines in it.
I can easily match SKU's across the worksheets when there is only one worksheet to compare too, but I need to match SKU's over ALL of my worksheets,
I found this video: *edit* My post count isnt high enough to post videos, so please search youtube for video ID: cGrcZFs, you will be given the option to watch a video called "Use the Excel Vlookup Function across Multiple sheets" by a channel called "Computergaga"./*EDIT*
which illustrates the theory of what I would like to do very well, although, it is only really possible to do it for only a handful of worksheets, as the code is rather long.
Really I need a way to do this over all of the worksheets I have so I can then amend various fields.
I would be very grateful if anyone had any ideas on how I could acheive this.
Kindest regards.
Chris
Having an issue with Excel that I'm hoping someone here might have a solution to.
I run a website that has (at present) 14,000 individual products listed,
These products have been split down in excel to be managed by Brand. Each brand has a separate worksheet, currently I have around 220 worksheets/brands.
When my main supplier sends a price update I get given a CSV file with around 11,000 lines in it.
I can easily match SKU's across the worksheets when there is only one worksheet to compare too, but I need to match SKU's over ALL of my worksheets,
I found this video: *edit* My post count isnt high enough to post videos, so please search youtube for video ID: cGrcZFs, you will be given the option to watch a video called "Use the Excel Vlookup Function across Multiple sheets" by a channel called "Computergaga"./*EDIT*
which illustrates the theory of what I would like to do very well, although, it is only really possible to do it for only a handful of worksheets, as the code is rather long.
Really I need a way to do this over all of the worksheets I have so I can then amend various fields.
I would be very grateful if anyone had any ideas on how I could acheive this.
Kindest regards.
Chris
