Formula messedup need future dragging in data sheet

[udprocks]

Dear Guru's,

Happy new year to all.

I have a master sheet in that sheet formula get cut and pasted I need help with it also,

I want to fix the formulas and in the future if I add a column for 12/1/2019 I can just drag the formula

Sorry unable to attach file due to restrictions, you can view here

https://drive.google.com/file/d/1-9L...w?usp=drivesdk

Much appreciated any response.

Thanks in advance.

[samba_ravi]

Try below formula in AK7, copy and paste towards down

Please Login or Register  to view this content.

[udprocks]

Try below formula in AK7, copy and paste towards down

Please Login or Register  to view this content.

Hi,

Thank you for quick response please look into Column B through formula cut

[udprocks]

Also

here is some clarification

We need to go to the data sheet, and then go to the drop down button on the top for the date and pull all the information from the dates that are missing

if you go to the data sheet you can pull 2019 from the drop down and it will give you all the information that you need

and then on the data sheet i need you to fix the formulas from column e-w

[AliGW]

Please attach your file directly here - instructions at the top of the page. If the file is too big, trim it down - we only need to see a sample workbook.

[udprocks]

Please attach your file directly here - instructions at the top of the page. If the file is too big, trim it down - we only need to see a sample workbook.

thank you for suggestion.

please look

[AliGW]

DATA BREACH???

Has the data been desensitised? Are the E-mail addresses real? If so, you must remove the workbook, desensitise it, and then attach it again. Same with the original link you provided.

[udprocks]

DATA BREACH???

Has the data been desensitised? Are the E-mail addresses real? If so, you must remove the workbook, desensitise it, and then attach it again. Same with the original link you provided.

please chek now

[udprocks]

any luck? on this please.

Waiting for any response.

[udprocks]

any one can help me out? please

[samba_ravi]

There lack of explanation (write up) from your side about your requirements.
you need to explain step by step.

[udprocks]

There lack of explanation (write up) from your side about your requirements.
you need to explain step by step.

Thank you for asking sir,

I want to fix the formulas and in the future if I add a column for 12/1/2019 I can just drag the formula


We need to go to the data sheet, and then go to the drop down button on the top for the date and pull all the information from the dates that are missing

if you go to the data sheet you can pull 2019 from the drop down and it will give you all the information that you need

and then on the data sheet i need you to fix the formulas from column E to W

Hope it helps

[udprocks]

No luck?

[udprocks]

No luck?

[AliGW]

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - you bumped the thread twice within an hour. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[Pepe Le Mokko]

Administrative Note:

Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
Use the "Quick reply" instead
Thanks