I am trying to work around an older inventory program that can export the data to excel. I don’t know if this can be solved with a formula or Macro. I am using Office 2010 if that helps.
Within the inventory program, the export cell size can’t be changed so when the data exceeds that predetermined size it creates another cell vertically. I am trying to merge these rather than retype everything.
I am attaching one of the files as an example.
Thanks for any help you can provide.
Tom
Hi Tom
Welcome to the Forum!!!
Do you need the Header Rows other than the first three rows?
Does the Code need to run in any Excel Version below Excel 2007 (you've attached an .xls File)?
Last edited by jaslake; 03-22-2017 at 02:08 PM.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
You can't actually Merge cells because you'd only get the contents of the top cell.
You'd probably need to loop through the cells and, if the cell in column B is not blank, store its address. If the cell IS blank, concatenate the cell in column C with the value in cell in column C on the stored row.
Then I'd filter for blanks in column B and delete the visible rows.
That's the process, give or take.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
John,
The Header Rows are not needed lower in the document, that is just how it comes out. I can freeze the top if the list gets too long.
As far as other versions of Excel, that is the version that the inventory program exports in.
Hi Tom
Ok...but the Code to modify your Data will run on your 2010 Excel?
Hi Tom
See if this Code in the attached works for you...
Please Login or Register to view this content.
It looks great. That is so far beyond my ability, it is great to have you as an asset.
THANK YOU
Tom
Hi Tom
Interesting exercise. You're welcome...glad it works for you.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Thanks for the Rep Tom...glad it works for you...good hunting.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks