Unable to create macro due to varying data
If anyone could help me with this, I would be very appreciative! I'm trying to figure out a macro to rearrange some data, however, it varies from item to item so I am unable to simply use text to columns or a cell offset to do the rearranging. I have attached an example for your review. Please let me know if I can provide any additional information.
Last edited by theatricalveggie; 02-23-2011 at 04:00 PM. Reason: Change Title
Hi theatricalveggie
Welcome to the forum
Please Login or Register to view this content.
Thank you so much!
Question though: I copied and pasted this into VBA as is on my example sheet, and I received a Syntax error. Do you know how to resolve this issue?
Thanks!
Originally Posted by pike
one little type-0.. tested this onePlease Login or Register to view this content.
This is sooo close to what I need. When I ran the macro, I got:
Number Fruit Value Brand Color
1 Banana Trader Joe's Chiquita Yellow
2 Banana 3 oz Chiquita Green
3 Apple New Hampshire Washington Green
4 Apple Whole Foods , 5 oz Fuji Red
However, I need to keep the values in a separate row, as they are in the example.
Again, I can't tell you how much I appreciate the help. I cannot figure out how to get the values in their own rows....
one little type-0.. tested this onePlease Login or Register to view this content.
Hi theatricalveggie,
Apologies on the delay as i have been away for the last week or is it two
any way maybePlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks