Needing help with a vba

Jaak023

New Member
Joined
Apr 16, 2021
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
Hi there. Long story short I currently have a macro in place for a calculator for work that the person enters the requested materials, fills out with supplier prices and a submit button that then sends the data to a data table for spend analytics later down the track. I need to now make it more advanced which is where I need help. I now need the ability to reopen old data entered to then have the ability to change details and resubmit. There are multiple entries a day so it would be too hard to have it create a separate workbook every time as it would clog the system, best bet would be working from the same sheet if possible. Has anyone got any idea on how or where to point me in the right direction? I know it's possible but just don't know how
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

vw412

Active Member
Joined
Dec 16, 2011
Messages
343
Office Version
  1. 2019
  2. 2016
  3. 2010
  4. 2007
Platform
  1. Windows
An interesting question. Can you post the existing code so we can look at it? Also pictures of the workbook would help also. Right now we are kind of in the dark on how to help you. I agree (as evidenced by my signature line below) that it is possible but we need more info to ask good questions to determine a course of action.
 

Forum statistics

Threads
1,136,303
Messages
5,674,970
Members
419,537
Latest member
ucatchy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top