MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 290|Reply: 4

Adding new data with a form

[Copy link]

1

Topics

1

Posts

5

Integral

Newbie

Rank: 1

Integral
5
Post on 9-14-2016 18:32:03 | All posts |Read mode
I am trying to make a historical cost data sheet that shows costs per square foot for projects.  I want to be able to easily input a new table of values and have it auto fill into the correct areas.  I am having trouble making a form that will allow me to do this.  Is there another way I can have a page were new cost data can be filled in and it can be transferred to all my areas by automatically adding columns into the sheets I have?  I would also like the page for new data to revert to blank ( like a form) after the new information is populated into the analysis.




Reply

Props Report

2

Topics

36

Posts

108

Integral

Conqueror

Rank: 3Rank: 3

Integral
108
Post on 9-14-2016 19:42:38 | All posts



usu you have a combo box to pick your client, then it would run a query to fill in fields.
the combo box would have 2 fields
CLIENT, QRY
JayCo, quFillDataJay
Acme, quFillAcme

the combo would show the client name, and run the query once chosen.
this update query would fill in boxes.
Reply Support Opposition

Props Report

11

Topics

130

Posts

283

Integral

Conqueror

Rank: 3Rank: 3

Integral
283
Post on 2-6-2017 18:12:32 | All posts



the simple formula












Reply Support Opposition

Props Report

13

Topics

1065

Posts

2355

Integral

King

Rank: 6Rank: 6

Integral
2355
Post on 2-6-2017 19:37:35 | All posts



What is the source of the #VALUE# error? My first thought would be to nest the current function in B so that it returns some kind of text string when it errors, then the sum function ImramBhatti suggested would work fine. Are you familiar with the IFERROR() function? https://support.office.com/en-us/art...6-63f3e417f611
Something like =IFERROR(current formula in B,error)











Reply Support Opposition

Props Report

14

Topics

436

Posts

1026

Integral

King

Rank: 6Rank: 6

Integral
1026
Post on 2-6-2017 20:25:54 | All posts



This is inappropriate language. Further offenses will result in a ban.

Common courtesy is the order of the day. Avoid coarse language, personal attacks and inflammatory remarks. Address your concerns at topics and not at people.
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-24-2017 21:27 , Processed in 0.271954 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!