I am running a macro that will load external data from a text file. I do a lookup by concatenating values in the data set and inserting a column in the external connection sheet. Unfortunately, when I run my macro that does this, all of the preset formulas are being adjusted to move with the new column. Is there a way to keep the formulas on fixed cells.
Please note I clear the data sheet by using the following code at the beggining of the macro:
Please Login or Register to view this content.
Hi rjj920- What formulas? Your data is in a CSV. file, right? Can we see the macro that inserts the column? And maybe a sample workbook demonstrating said formulas and data.
PS perhaps one easy fix is to use an empty column to the right of the formulas instead of inserting one so you don't move them.
Last edited by leelnich; 02-01-2018 at 02:31 PM.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
Hi Leel,
I took your suggestion of just adding the lookup to the end of the data set...easy fix and saved me a world of trouble. Thanks!
Glad I could help. If that concludes your thread, please mark it as SOLVED (Thread Tools, up top). Thanks - Lee
PS I notice you have a BUNCH of open threads. Please consider closing them too. And while we're discussing protocols... Clicking the Add Reputation star below helpful posts is a nice way to show appreciation to those who contributed to your threads. Just saying...Regards - Lee
Last edited by leelnich; 02-01-2018 at 08:18 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks