Updating Macros to accomodate hidden columns and customize auto generated pages

[jeskea20]

Hello!

I was given what I think is a fairly complicated macros enabled workbook and asked to make changes to it. Plot twist: I have never used macros. I am well aware that I am out of my element and i do not have the time/resources to become an expert in it. I wanted to know if 1: the requests were possible. 2: if there are independent contractors/experts that would be able to do the work.

What i have is a workbook that includes about 4 tabs of instruction, 2 tabs of general information and 5 tabs of various order forms. This is for a furnishings supply company. So, the user would go in and fill in their info, then go through the room tabs and order different items (beds, plants, curtains, whatever). The original developer then created a set of macros enabled buttons that would then pull all the information from the various sheets and put them in another sheet as sort of a final order form.

What the company wants is a lot of specification on this final order form. For example, if the item ordered has a particular set of dimensions - they want that pulled out and placed on the order form. If there are lets say 5 items under "Window Treatments" they want all 5 items to prefill with certain information.

As a caveat, the original macros was done back in 2013/2014.

Any help would be greatly appreciated!!

[TMS]

In theory, anything is possible. If you can do it manually, you should be able to do it in VBA. It all depends on what data is filled in and how that relates to the information that you want to pre-fill ... and where that information is held.

And yes, there are consultants who can do it for you.

But first, you need to share more information. A sample workbook with some typical data ... and example of the source data used to pre-fill the order form.

2013/2014 isn't that far in the past

[PCI]

In the top of the welcome page there is a button "Commercial Services" have a look on it

[TMS]

In the top of the welcome page there is a button "Commercial Services" have a look on it

Sorry, I should have said, if you provide enough information in the open forum, the chances are that someone will be able to help you.

Failing that, Commercial Services is a relatively cheap way of getting a bespoke solution.

Last resort, employ someone to create it for you.

[jeskea20]

Great! I am out of the office right now but will post the workbook with more specific questions tonight. Wasn't expecting such a quick response - thanks!!

[PCI]

OK waiting for your file.
Keep in mind to show what is the final results you need

[jeskea20]

Ok - Here is the file itself.

1. On the Bedroom and Living Area tabs, I hid Columns E and I because they added in a function that the company does not want to use "right now". I changed the formulas on the sheets themselves so the quantities and values would still work, but when I try to run the "casegood report" on the ED tab, I get a run time error. I think it is from those hidden columns, but I don't know how to tell the program not to do anything with them anymore.
2. Under Tab Attach 1, under Additional Information - they want that to autopopulate with the words "see FID Requirement". They want the dimensions W, D, H to autopopulate under Dimensions.
3. Also, I don't know why the pricing in Attach 1 didnt autopopulate - I'm assuming its supposed to.


Thanks for any help. Sorry, I feel like a total idiot about this - like its something simple I should be able to figure out!

[jeskea20]

bumping...any ideas?

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )