I have a large report 20,000+ rows that is generated every day and I want to add additional data in columns without changing the headers. In the attached file you will see the information I receive in the Data tab and what I need to add in the Example tab highlighted in yellow. As you can see each of these are numbered, BC_Custom Field 1/Name and BC_Custom Field 1/Value and I need to go out to 30 of these even if there is no information.
Last edited by MSchibs; 05-30-2022 at 06:38 PM.
Try this...
Please Login or Register to view this content.
Last edited by sintek; 05-29-2022 at 12:53 PM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
This is close but it stopped at 15 and as you can see I still have more columns that I need to complete. I can go up to a maximum of 30.
Remove red snippet...
or make 30... 60?Please Login or Register to view this content.
Thought you only wanted 30 columns analyzed...
Last edited by sintek; 05-29-2022 at 02:05 PM.
Thanks, that worked.
I have one last thing maybe you could help me with. I have a list of attributes on tab "Remove" that can grow or shrink from week to week that need to be removed from the data along with their corresponding value in the cell to the right. Then shift the entire row to the left once they are removed. This needs to be completed for every row in the worksheet. I'm not sure if it is possible but can I use a tab like this to keep the information to be removed in my template where I can change the information as needed and it can be referenced for the macro?
Please 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